You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Duplicate records in Seniority Dates

edited Apr 29, 2025 2:32PM in Human Capital Management 1 comment

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!