Duplicate records in Seniority Dates
Summary:
Hi Experts,
Duplicate records showing in Seniority Dates. Two records of data with the same Seniority dates.
Eg. Adjusted Service Date shows 01/01/2024 as Seniority Date.
I could see Position got changed once in his tenure. Position Seniority Date shows different Seniority dates based on the position changes. I referred Oracle Doc and ran the Diagnostics report (Seniority Date Records Violating Unique Constraint - Correct) to correct the Seniority Dates. The report ran successfully. and ran the Recalculate Seniority Date, last updated date is not changed and then no changes to the duplicate records.
On checking the log for the process Calculate Seniority Date, below is the message for Position Seniority Date Rule in the log file: