Introduction
One of the business need for an HCM Cloud implementation project is to get detailed information about the Assignment Changes which has taken place in the application along with the insight of who performed the change and when. These details can be fetched if the Audit Functionality is enabled.
In this article we will try to demonstrate how we can create a custom ESS job which can be used to get Assignment Audit History Table.
Worked-Out Example
We would have to follow the below mentioned high level steps in order to accomplish the same:
- Enable Auditing for Assignment Business Object
- Create a custom data model
- Create a custom report
- Create a custom ESS Job
- Run ESS Job to get results.
Enable Auditing for Assignment Business Object
Navigation: Setup and Maintenance -> Search (Manage Audit Policies)->Configure Business Object Attributes
Creating a Custom Data Model
We would need to create a custom data model using SQL.
Create a Custom Report
We would now need to create a report from the data model. The Report would appear as below:
Create a Custom ESS Job
In this step, we would create a custom ESS job.
Navigation->Setup and Maintenance-> Search (Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications)
Before we proceed with creating a new Custom ESS job we could create a custom List of Values which we will utilize for “Assignment Action Code”.
Navigation->Setup and Maintenance-> Search (Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications)->Manage List of Values Sources
Details to be populated in the LOV are as below:
Now we will create the ESS Job. Details used are as below:
Parameter Details:
Verification
As a last step we would try to run the newly created custom ESS job “Assignment Audit Report”
Navigation: Tools-> Scheduled Processes -> Assignment Audit Report
And once we click on “Default Document” an excel file will open which would appear as below
You can download the files from the link below:
AssignmentAuditReport.xdo.catalog
AssignmentAudit_dm.xdm.catalog