DateTrack Issue With Overlapping Assignments (Doc ID 2852813.1)

Last updated on OCTOBER 18, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------


DateTrack issue with overlapping assignments followed by last start date moved forward

When employees rehire starting employment date is moved forward (updated), in circumstances where the prior starting date happens to coincide with the final process date of the prior employment period, the DateTrack of the non-primary assignment version on the overlapping date becomes invalid (Start Date higher than End Date).

The issue seems to be that the non-primary assignment version for the overlapping date was updated incorrectly.

If the new employment date is before the final process date, then updating the effective start date is correct.

However, if the new employment date is after the final process date, since there is now no overlap, then the non-primary assignment should only have its primary flag to ‘Y’ and not change the effective dates.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Hire an employee, say on 2021-09-01

2. Terminate the employee, say on 2021-10-01

3. Add a final process date to the employees’ termination, say 2021-11-01

4. Rehire the employee on 2021-11-01

5. Move the starting employment date forward using the last start date field to 2021-11-02 and choose Correction

6. DateTrack on the non-primary assignment version is now invalid.

Notice the assignment's effective start date is higher than the effective end date.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.