Pre-Requisites:
1. Access to Setup and maintenance
2. Access to Scheduled Process screen
Process:
1. Create independent Value sets
2. Create View Object (VO) for value set
3. Add parameters to ESS Job
4. Link Parameters
5. Verify the Results
Example: Getting Template
value based on Business unit value in custom ESS job
Step 1: Create independent Value
sets
Navigate to Manage value sets
and create value set for Business unit as shown below
Click on manage values and Enter values for BU Value set as shown
Create Value sets for the Values created in the above screenshot
Step 2: Create View Object (VO)
for value set
To get the Values
from Value set register the VO
oracle.apps.fnd.applcore.flex.vst.model.publicView.ValueSetValuePVO in Manage List
of Values Sources as shown
Step 3 : Add
parameters to ESS Job
Open the Existing ESS
job and Create the
two parameters to map it to the newly registered VO as shown
Step 4: Link Parameters
To create
link between the two parameters
In the
Manage List of Values Dependencies map first LOV to the first created 'XX_BU_Name'
value set using ValueSetCodeCriteria as shown
Map the
second Parameter using the same ValueSetCodeCriteria but this time use the
Mapped Parameter and select the first parameter as shown below
Arrange
the parameters as shown to display BU first and Template second
Step 5: Verify the Results
Now
navigate to schedule process screen and verify the results
Reference:
How to
Create Dependent LOV Parameters for Custom ESS Jobs Using Value Sets? (Doc ID
2173057.1)
