Thursday, 10 October 2013

How To Create A Dependent Value Set

A dependent value set can be defined as a sub value set for each value in an independent value set.
A dependent value set depends on an independent value set and hence and independent value set must be defined before defining a dependent value set.
For example lets say we have two value sets :
1. QUARTER_OF_DAY_VS : Independent Value Set
2. HOUR_OF_DAY_VS : Dependent Value Set
QUARTER_OF_DAY_VS has value Q1, Q2, Q3 and Q4.
HOUR_OF_DAY_VS has value 0000, 0100, 0200……2300, 2400. Values 0000 to 0600 should be available only in Q1, 0700 to 1200 in Q2, 1300 TO 1800 in Q3 and 1900 to 2400 in Q4. So we create a dependent value set HOUR_OF_DAY_VS which is dependent on QUARTER_OF_DAY_VS.
Now lets move on to how to create a dependent value set. Creation of a dependent value set can be broadly divided into following tasks :
1. Create independent value set
2. Create dependent value set
3. Add values for independent value set
4. Add values for dependent value set
Creating independent value set and Adding Value to it (Step 1 and Step 3) has already been covered in blog before. So I won’t be covering that in the steps below :
1. Responsibility : Application Developer
2. Navigate to Application > Validation > Set.
http://oracleappsebs.com/wp-content/uploads/2013/07/value-set-navigation1-262x300.png
3. Create Independent Value Set with details as shown in the screenshot below :
http://oracleappsebs.com/wp-content/uploads/2013/07/dependent_value_set-1.png
4. Save it and clear the record (short cut key : F6)
5. Create dependent value set by filling the information as shown in the image below :
http://oracleappsebs.com/wp-content/uploads/2013/07/dependent_value_set-2.png
6. Click on Edit Information and button and enter the Independent Value Set and default value information
http://oracleappsebs.com/wp-content/uploads/2013/07/dependent-vs-3.png
Note : Default dependent value must be entered for each value in the independent value set. For any new value entered in the independent value set, application will take the default value as specified here.
7. Save and Exit.
8. Navigate to Application > Validation > Values to add the values to the value sets.
9. Search for your independent value set and add the values.
http://oracleappsebs.com/wp-content/uploads/2013/07/dependent-vs-5.png
10. Save and Close.
11. Search for your dependent value set. Enter the dependent values for the first independent value. So in our case we need to enter dependent values for Q1.
http://oracleappsebs.com/wp-content/uploads/2013/07/dependent-vs-4.png
12. Save. Click on Independent Value field and press down arrow to fill values for other independent values.

No comments:

Post a Comment