Dependent LOV Parameters in Custom ESS Job

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)