In this blog, I will explain the step by step process to implement cascading LOV parameters in Oracle Fusion ESS Job using Value Sets. In the end, we will have a custom ESS Job with two parameters where Parameter 2 value will dynamically change based on the value selected in Parameter 1.
Let's dive in.
Register a new List of Values Source
- Navigate to Setup & Maintenance
- Search for the task 'Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications'
- Go to 'Manage List of Values Sources' Tab
- Create a new LOV Source
- Application: Application Toolkit
- Name: Give desired name (I'm using AJ_LOV_Source as an example)
- LOVType: Predefined
- LOV Source definition Name: oracle.apps.fnd.applcore.flex.vst.model.publicView.ValueSetValuePVO
Create custom Value Sets
- We are going to create 3 Value Sets in my example:
- Value Set 1 (AJ_Vset_1): This will be the main Value Set our Parameter 1 will refer to. This Value Set will have two values - AJ_BU and AJ_LE, which are essentially 2 separate Value Sets.
- Value Set 2 (AJ_BU): This is the Value Set that holds Business Units
- Value Set 3 (AJ_LE): This is the Value Set that holds Legal Entities
Create Value Set 1 (AJ_Vset_1):
- Navigate to Setup & Maintenance and search for Manage Value Sets
- Create a new Value Set named AJ_Vset_1
- Set the desired Module, set Data Type to Character and SubType to Test with length 150
- Assign two values to this Value Set - AJ_BU and AJ_LE
Create Value Set 2 (AJ_BU):
- Create a new Value Set named AJ_BU
- Set the desired Module, set Data Type to Character and SubType to Test with length 150
- Assign two values to this Value Set - BU1 and BU2
Create Value Set 3 (AJ_LE):
- Create a new Value Set named AJ_LE
- Set the desired Module, set Data Type to Character and SubType to Test with length 150
- Assign two values to this Value Set - LE1 and LE2
ESS Job Configuration
- Navigate to Setup & Maintenance
- Search for the task 'Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications'
- Create the custom ESS Job, enter the essential details like Display name, Path, Report ID (for BIP report) etc.
- In my example, I've created a test job named AJ Test as shown below
- Navigate to Parameters section
- Create Parameter 1 as follows:
- Data Type: String
- Page Element: List of Values
- List of Values Source: AJ_LOV_Source (from Step 1 above)
- Attribute: Value
- Display Attributes: Value
- Save and close
- Select Parameter 1 and click on Manage Dependencies icon.
- Move 'ValueSetCodeCriteria' to the Selected View Criteria section
- Set the Default Value to 'AJ_Vset_1'. This is our main value set that will show list of values for other 2 value sets.
- This configuration tells the ESS engine that Parameter 1 should refer to 'AJ_LOV_Source' LOV which is a generic LOV that refers to ValueSetValuePVO source and the dependency configuration adds a where clause indicating that the engine should display values from the Value Set AJ_Vset_1
- Now create Parameter 2 as follows (similar to Parameter 1 definition):
- Data Type: String
- Page Element: List of Values
- List of Values Source: AJ_LOV_Source (from Step 1 above)
- Attribute: Value
- Display Attributes: Value
- Select Parameter 2 and click on Manage Dependencies icon.
- Move 'ValueSetCodeCriteria' to the Selected View Criteria section
- This time, we will set the Mapped Parameter value to Parameter 1.
This configuration tells the ESS engine that Parameter 2 should refer to 'AJ_LOV_Source' LOV which is a generic LOV that refers to ValueSetValuePVO source and the dependency configuration adds a where clause indicating that the engine should display values from the Value Set returned by Parameter 1
- Save and close the ESS Job definition.
Test the output
- Search for our custom job (AJ Test in my case)
- The Process Details popup will show us the two parameters - Parameter 1 and Parameter 2
- When we click on Parameter 1, it shows us the two values AJ_BU and AJ_LE
- If we select the value AJ_BU in Parameter 1 then the Parameter 2 automatically shows us the 2 BUs from the dependent Value Set
- And if we select the value AJ_LE in Parameter 1 then the Parameter 2 automatically shows us the 2 LEs from the dependent Value Set
And that's it! With these configurations in place, we've established the cascading LOV parameters in Oracle Fusion ESS job using custom Value Sets.
The example I provided uses simple Independent Value Sets with static values but this pattern can be extended to fit other types of LOVs as per your actual requirements.
0 comments:
Post a Comment