Introduction
In one of the previous article (Position Synchronization in Oracle HCM Cloud) we have seen how can we synchronize employee’s assignment data attributes with the position data (if position synchronization is enabled). However, many a times this may result in creation of Duplicate MCPD (Multiple Changes Per Day) Assignment Records. It makes sense to correct these kind of corrected data, and hence in order to facilitate this activity Oracle product development has provided two diagnostic tests. The first one lists all the person records who have duplicate MCPD assignment record issue and the second one corrects such records.
In this post we will run “Duplicate MCPD Assignment Records created by Position Synchronization ESS – Report ” diagnostic test.
Let-us see a worked out example.
Worked Out Example
If you have the appropriate roles and privileges (hcm_impl in this case) we can navigate to “Run Diagnostic Tests”
Once you click on “Run Diagnostic Tests” a UI will open and once you enter “Duplicate MCPD Assignment Records created by Position Synchronization ESS – Report” in the Test Name the diagnostic test will appear as shown below:
We need to select the Test and click on “Add to Run”. Post that we should open the (Input Status) and we should be able to get insight into the various parameters of the diagnostic test
Person Number(s) is an optional parameter. If we provide specific person number values then the test is executed only for those values and if left blank then it runs for entire population.
For this example we will leave the parameter value blank run the report. Once submitted the Test Framework UI page would appear as below.
And when we click on the Report (highlighted above) we will see the following results
Summary
In our example we did not had any person numbers who were having data inconsistencies due to position synchronization, but if you find some records in your environment you should run the diagnostic test “Duplicate MCPD Assignment Records created by Position Synchronization ESS – Correct” by passing the person numbers and the data issues will be fixed.