Validation type 'Translatable Dependent' in Value sets in Oracle

Definition:- A Translatable Dependent value set is similar to Dependent value set in that the available values in the list and the meaning of a given value depend on which independent value was selected in a prior segment of the flexfield structure. However, a translated value can be used.

Flexfield Value Security cannot be used with Translatable Independent or Translatable Dependent value sets.

Note: The Accounting Flexfield does not support Translatable Independent and Translatable Dependent value sets.

Lets create a Translatable dependent value set based on parent value set we created in an earlier post.

Translatable Independent Value set


Lets create a Translatable dependent value set.

Select the parent value set. i.e. XX_INDEPENDENT_VALUE_SET

Enter values against each parent value of XX_INDEPENDENT_VALUE_SET which we selected as parent for XX_DEPENDENT_VALUE_SET.

After attachment of value set to a form field, result was as below.

Please note that values saved for these value sets will be PAK for Pakistan and LHR for Lahore.

Value Sets in Oracle Apps

I hope you enjoyed the post.

Kindly provide your feedback.