Thursday, 15 May 2014

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.

Translatable Independent Value sets in Oracle


Now lets enter its values from Flexfield values form:-

Translatable Independent Value sets in Oracle



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. 

Translatable Independent Value sets in Oracle



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.

No comments:

Post a Comment