Validation type 'Translatable Independent' in Value sets in Oracle
Definition:- A Translatable Independent value set is similar to Independent value set in that 
it provides a predefined list of values for a segment. However, a translated 
value can be used.
Lets take a scenario...Consider we want to provide list of values of countries and but want to return their shot code like PAK, USA etc. So we need to create a Translatable Independent to achieve this task.
I created a value set show below.
Lets take a scenario...Consider we want to provide list of values of countries and but want to return their shot code like PAK, USA etc. So we need to create a Translatable Independent to achieve this task.
I created a value set show below.
Now lets enter its values from Flexfield values form:-
After i attached the value set to a form field, result was shown as below. Short code like PAK, BAN will be saved in the database. 
Another example can be, if you want to show data in one format and value be returned in different format. 
Display                     Return value
Dammam- Lahore       DMM-LHR
Colombo-Jeddah         JDH-CLM
Leave a comment for any query.



 
 
 
 
 
 
 
 
 
 
0 comments: