How to create dependent parameters in custom ess job
We are going to discuss the dependent parameters in custom ess jobs. We will be create the dependent parameters for ess job parameters. Dependent Parameters for custom ess job means , parameters output will depend on each other. if we have two parameters in custom ess job , and we have created the dependent parameters , then the output of the second parameter will be depend on the value selected by user in the first parameter. In dependent Parameters , The List of value (LOV) of the second parameter dependent on the values selected in the first parameter. Dependent parameters , help to provide the more refined values for the selection to user as only the relevant values dependent on the pre selected parameter in the custom ess job. Here below , We will share the details steps to create the dependent parameters in custom ess job.
Steps to create dependent parameters in custom ess job
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
XX_LG/Ledger
XX_LE/Ledger Entity
 |
| How to create dependent parameters in custom ess job |
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:
 |
| How to create dependent parameters in custom ess job |
Step3:-
 |
| How to create dependent parameters in custom ess job |
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
 |
| How to create dependent parameters in custom ess job |
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
 |
| How to create dependent parameters in custom ess job |
Step 8: -
Map the second LOV using the same ValueSetCodeCriteria but this time use the Mapped Parameter and select the first field
 |
| How to create dependent parameters in custom ess job |
Step 9:-
 |
| How to create dependent parameters in custom ess job |
How to create dependent parameters in custom ess job
1 comments:
Can we do something similar with more dynamic (i.e query-based) Parameters? The above example is just using had-coded Value-Set, whereas I need to be able to utilize dynamic parameters...
Post a Comment