Introduction
One of the most important data insight required for any Oracle HCM Cloud Absence Management Implementation or Support project is “Employee Absence Plan Balance” Report.
However, there isn’t a delivered report for the same. Hence we would try to create a custom report and also encapsulate the same within a Custom ESS Job so that end-users can easily run the same.
So, without further ado let’s get started.
In order to complete this activity we have to perform following steps:
- Create a Custom Data Model
- Create a Custom BI Publisher Report
- Embed the Custom BI Publisher Report within a Custom ESS Job
- Run the Custom ESS Job
- Data Verification
Create a Custom Data Model
We would create a BI Data Model based on SQL query. The SQL query used is given below for ready reference:
Create Custom BI Report
We would now create a BI Report based on the above BI Data Model and the output would appear as below:
Creating Custom ESS Job
Now we would try to build a custom ESS job and encapsulate this BI Report within the ESS Job.Navigation for creating ESS Job is :
Setup and Maintenance-> Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications->Manage Job Definitions->Create
Next, we need to populate below details and create ESS Job:
We would also need to define parameters for this ESS Job
Running the ESS Job
We can run the Custom ESS Job from below navigation: Tools->Scheduled Processes->Get Employee Absence Plan Balance
Once the ESS Job completes we will find that a Excel Document gets downloaded and it has following output:
Verifying the Results
We would need to check the values from application. Navigation: My Client Groups ->Person Management-> Search for Person Number 100-> Absences-> Absence Records
You can download the files from below links:
EmployeeAbsencePlanBalance_dm.xdm.catalog
EmployeeAbsencePlanBalance.Sql
EmployeeAbsencePlanBalanceReport.xdo.catalog