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: