ESS job dependent parameters in Oracle Fusion

ESS job dependent parameters in Oracle Fusion

In this post , We will be discuss about ESS job dependent parameters in Oracle Fusion. We will share the detail steps to create the ESS job dependent parameters in Oracle Fusion. In oracle fusion , We can create the ESS job parameters which dependent on other ESS job parameters. Using ESS job dependent parameters , We can control the output and list of value of second ES job parameter based on the First Parameters selected value. ESS job dependent parameters is very useful when we want to filter the ESS job parameters values based on the user selected ess job parameter value in oracle fusion. Here below is the detail about ESS job dependent parameters in Oracle Fusion.

Step by Step to create the ESS job dependent parameters in Oracle Fusion

Step1:- Go to Setup and Maintenance. 

Use task "Manage Value Sets" to create value set called for example XX_VS and have values/description of the first parameter:

XX_BU/Business Unit
XX_LG/Ledger
XX_LE/Ledger Entity

ESS job dependent parameters in Oracle Fusion

Step2:- 

• Use task "Manage Value Sets" to create 3 more value set called for example XX_BU, XX_LG, XX_LE which will have the desired values for the dependent LOV for the second parameter.

For example for XX_BU value set:

ESS job dependent parameters in Oracle Fusion

Step3:- 

ESS job dependent parameters in Oracle Fusion

Step4:- 

If not registered register the VO: oracle.apps.fnd.applcore.flex.vst.model.publicView.ValueSetValuePVO in Manage List of Values Sources

ESS job dependent parameters in Oracle Fusion

Step5:- Create or modify the two parameters to map it to the registered Value Set LOV

ESS job dependent parameters in Oracle Fusion

Step 6:- Here We are in the ESS Job Parameters.

ESS job dependent parameters in Oracle Fusion

Step 7:- 

In the Manage List of Values Dependencies map first LOV to the first 'XX_VS' value set created using the ValueSetCodeCriteria

ESS job dependent parameters in Oracle Fusion

Step 8: -

Map the second LOV using the same ValueSetCodeCriteria but this time use the Mapped Parameter and select the first field

ESS job dependent parameters in Oracle Fusion

Step 9:- 

ESS job dependent parameters in Oracle Fusion

Step 10:- 

ESS job dependent parameters in Oracle Fusion

ESS job dependent parameters in Oracle Fusion