Steps to Create Dependent Value Set in Oracle Apps

$FLEX$.<Independent Value Set Name> is the syntax to reference the parent value set.

Creating First value Set (Independent Value set)

This is a category value set. It is taking values from a custom view CATL_OBJ_PARENT_CATGRY_V. It shows all master categories defined in OLM.

Creating Second Value Set (Dependent Value Set)

This is definition of independent value set. This is based on View CATL_OBJ_SUB_CATGRY_V. In this value set, we are passing the value of master category Id which is selected by user in above value set.

In this way, this value set will show only the sub categories relevant to main category. Main category Id is referenced through syntax $FLEX$.<Independent Value Set Name>

In my next article, i shall share the technique to know about profile value and how to get the possible values in Oracle Apps. If you have liked contents in this post and you think it can be helpful to others, please share it at least once in your circle, in this way, you will join me in my cause to Learn Share and Grow. Come on, Lets Grow Together.