Thursday, 7 November 2013

How to Create Independent Value Set

To demonstrate different types (Independent, Dependent and Table) 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.
Now Start Defining Value Sets.
Navigation: Application Developer > Application > Validation > Sets


Save it.
Create Values for the value set we defined above
Navigation: Application Developer > Application > Validation > Values
and Click on find button



Enter information as below

save it.
Attach this value set to Concurrent program parameter
Navigation: Application Developer > Concurrent > Program > Parameters.


Enter information as below and save it

Navigation: XXMS Custom application > View > Requests > Submit New Request > Single Request > OK
Enter Concurrent Program Name that we defined at the beginning of this tutorial
Click on LOV button to see the values available for this parameter.