To demonstrate Dependent of value set let’s first define a concurrent program.
1. Define Executable.
Navigation: Application Developer > Concurrent > Executable
Enter Information as below
Note: You don’t really need to have PLSQL package defined for this demo.
Save it.
Navigation: Application Developer > Concurrent > Program
Enter Information as below
Save it.
Assign this Concurrent program to “XXMS Custom Application” responsibility by adding it to Request group.
Save it.
Dependent Value Set
To define a Dependent value set we also need one Independent value set.
Example: To List down States in a Country we need to have list of Countries for which states need to be defined.
First Define list of countries in a independent value set
Navigation: Application Developer > Application > Validation > Sets
Enter Values for the above value set
Navigation: Application Developer > Application > Validation > Values
Enter Values in the below screen
Now define another Value set
Navigation: Application Developer > Application > Validation > Sets
Click Edit Information Button to link this Dependent Value set with Independent Value set defined in previous step
Enter Values for each country
Navigation: Application Developer > Application > Validation > Values
Ensure to Select Country name in “Independent Value” field before click Find.
Click Find and enter states for Country India
Save it.Now repeat the above two steps to enter states of country USA
Ensure to select country as USA before clicking Find button
Save it.
Navigate to Concurrent Program Parameters screen and enter Country parameter as shown below
Navigation: Application Developer > Concurrent > Program > Query our Concurrent Program > Parameters.
Save it.
Add another parameter to link State Value set as shown below
Save it.
To test “Dependent Value set” navigate to concurrent program submission window
Select country and you can observe that list of values in State parameter will change automatically depending on value select in Country parameter field.
