Validation Type 'Dependent' in value sets in Oracle

Definition: A dependent value set is similar to an independent value set, except 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.

Let's create a Dependent Value set as shown in screenshot below


Define a dependent Value set

Now click Edit Information button and select independent value set as i created in an earlier post.

See : Independent Value Set

Validation Type 'Independent' Value set in Oracle

What you need to do is, to enter values against each parent value i.e XX_INDEPENDENT value set we selected.

Dependent Value set in Oracle

After applying the value set to a field, result will be shown as follows.

Dependent Value set in Oracle


Validation Type 'None' in Value Sets in Oracle Apps

Leave a comment for any query.



5 comments:

  1. how can i create a dependant value set from another dependant value set

    ReplyDelete
    Replies
    1. Hi Lamyaa,

      Kindly follow this link.

      http://waqasora.blogspot.ae/2012/12/using-flex-in-value-sets.html

      Regards,
      Waqas

      Delete
  2. Hi, I wanted to ask how you got to the Value Sets Testing screen in the 4th picture?
    I mean I created an Independent list and a dependent list. I want to check if they are working fine. How do I do that?

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete