Introduction

In one of the previous article (Creating a Parameterised ESS Job in Oracle HCM Cloud Application) we have seen how a parameterized ESS job is created in Oracle HCM Cloud Application, but in that example we only used one single parameter and there were no specific linking between the ESS Job and the BI Report to uniquely identify the parameter. Since we only dealt with one parameter we didn’t faced much problems but in case there are multiple parameters one may have some trouble mapping the ESS Job parameter to the corresponding BI Report parameter. There is no concept of Token (I hope you guys remember this was used in EBS while defining Concurrent program parameter) in Oracle Cloud and the entire mapping is done based on the parameter sequence.

So, we need to arrange the parameters in the same order in BIP Report and the ESS Job. Parameter 1 of BIP Report becomes argument 1 of ESS Job, Parameter 2 of BIP Report becomes argument 2 and so on.

We would demonstrate the same in this post here.

We would need to perform the following steps:

Create a SQL Query Based BIP Data Model which has multiple parameters

Create a BIP Report from the SQL Data Model

Creating a Custom ESS Job for the BIP Report

Running the Custom ESS Job and verifying the results

Create a SQL Query Based BIP Data Model which has multiple parameters

We will create a SQL Query which will fetch person number, hire date, primary flag and worker type. The SQL query is mentioned below:

The details of the various parameters used are mentioned below:

Create a BIP Report from the SQL Data Model

We will create a BIP Report from the above Data Model, and when we run the report the output will be as shown below:

Creating Custom ESS Job

We would now need to create a custom ESS job. We would need to search for “Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications” task under Setup and Maintenance. Next we need to click on (+) button and populate the following details

Once populated the UI will appear as below:

Now, we will create the parameters using the following details

Once all these details are filled the parameter section would appear as below:

*Note: One can use the up-down arrow buttons (highlighted in yellow above) to re-order the parameters. One should ensure that the parameter order should exactly be same as that of BIP Report parameter sequencing.

Running the Custom ESS Job and Verifying Results

Now as a last step we will run the ESS Job and try to verify the results. For this we need to navigate to Navigator->Tools->Scheduled Processes-> Schedule New Process ( Search for Person Details ESS Job and submit the same)

And the process when gets completed displays the below information

Summary

So, from the above screenshot we can easily conclude that if we keep the ordering / sequencing of the parameter same in BIP Report and ESS Job then the application automatically maps the parameter with the ESS Job argument and no explicit linking is required.

Ashish Harbhajanka

Add comment