Introduction
In some of the previous articles we have seen how to run some of the Diagnostic Tests like “HCM Delete Diagnostics”, “Person Setup Validations” and “Person Validations”. In this article we will try to get you acquainted with “Assignment Data Integrity Report”.
While person records do form a core part of any HCM Application Work Relationship and Assignments are considered to be the areas of prime interest to all. Any issues/errors with the work relationship records may cascade to other part of application and pose greater issues. As such, it is always advised to have a regular health checkup time-to-time for the Assignment data to ensure they are compliant and have no data integrity issues.
Oracle HCM Cloud Application has provided a delivered diagnostic test for the same. It is called “Assignment Data Integrity Report”. This report gives a complete detail of the records, which have issues along with a possible resolution too. It takes up BusinessGroupId as an input parameter ( It holds the value of 1 in most cases, but may run a query against PER_BUSINESS_GROUPS database object to find the exact value applicable for a specific environment.) In our example, the value of BusinessGroupId is 1.
The various facts which this reports checks includes:
-
Lists all Assignment Records having multiple entries with PrimaryAssignmentFlag as ‘Y’
-
Lists all Assignment Records having multiple entries with PrimaryFlag as ‘Y’
-
Assignments with Invalid Effective End Date
-
Duplicate Assignment Numbers
Let-us now try to execute this diagnostic test and check results.
Worked Example
In order to run this diagnostic test we would need to login to application with an user who has “Application Diagnostic Administrator” role. We are using HCM_IMPL and the user has all the requisite role. Next, we need to navigate to “Run Diagnostic Test” link under the top right hand corner (under the username).
Once we click on the link a new popup window would appear. We need to search for diagnostic test “Assignment Data Integrity Report” and once the Test comes up, you need to select the “Add to Run” option. Pass BusinessGroupID as 1 and run the report.
Click on “Run” and a information dialog box will appear.
A quick look at the Report would show the following results:
Summary
From the results we can clearly make out the total number of assignment records which has issues. For this example we could see that there multiple occurrences where the PrimaryAssignmentFlag and the PrimaryFlag is Y . There are however no records which has an invalid effective end date neither there is any duplication of assignment number.
As such, we may infer that this Diagnostic Report can come very handy to check the integrity of Assignment records and provide a summarized view of all erroneous records which can be identified and corrected accordingly.