Assignment Effective Dates Corrupted When Changing Hire Date On Employee With 3 Or More Periods Of Service (Doc ID 2952757.1)

Last updated on JANUARY 25, 2024

Applies to:

Symptoms

Problem Statement:

Assignment Data corruption occurs (in per_all_assignments_f table) when a person is on their third(or more) period of service and the hire date is changed on the third period of service.
The system takes the final process date from the first period of service and it updates every assignment record on the second period of service with final process date (from first period of service).
Expecting effective_end_date for the assignment should not change (with same effective_end as final process date) after rehire and changing hire date.


Steps to Reproduce:

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

1.  Responsibility: US Super HRMS Manger
   
   
2.  Navigate: People > Enter and Maintain > Query the ex-employee with 3 or more period of service
    
3. Re-hire the person.
   
   
4. Change the Hire Date on the third period of service, Save
   
   
5. Assignment Data corruption occurs in per_all_assignments_f table. If there are 20 date tracked records on the second period of service, All 20 records will have the same effective_end_Date. (with first process date of 1st period of service date)

Changes

 Applied 12.2 HR RUP16 -> <Patch: R12.HR_PF.C.delta.16> 33527653   

Cause

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