Employee record in per_all_people_f not in sync with the update in forms in a shared HR install
(Doc ID 2363587.1)
Last updated on JUNE 02, 2024
Applies to:
Oracle Human Resources - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.6 version, Shared HR Issues
ACTUAL BEHAVIOR
---------------
In a shared HR install, from front end, employee record is end dated with a future date. Then email address is changed on the same record. But when checked in the backend, only the future record is getting updated. Following illustrates the same.
Data in per_all_people_f
1. When employee created:
Eff_Start_Dt Effe_End_Dt Full Name Person Id Emp Number Person Type (ID) Email Address
01-Jul-2016 31-Dec-4712 <Employee_name> <99999> <00009999> EMP-Employee (3) <email@xxxxxxx.com>
2. When an Employment End Date is entered:
Eff_Start_Dt Effe_End_Dt Full Name Person Id Emp Number Person Type (ID) Email Address
01-Jul-2016 30-Apr-2049 <Employee_name> <99999> <00009999> EMP-Employee (3) <email@xxxxxxx.com>
01-May-2049 31-Dec-4712 <Employee_name> <99999> <00009999> EX_EMP-Ex-employee (6)
3. When Email Address is changed:<email@xxxxxx.com>
Eff_Start_Dt Effe_End_Dt Full Name Person Id Emp Number Person Type (ID) Email Address
01-Jul-2016 30-Apr-2049 <Employee_name> <99999> <00009999> EMP-Employee (3) <email@xxxxxxx.com>
01-May-2049 31-Dec-4712 <Employee_name> <99999> <00009999> EX_EMP-Ex-employee (6) <email2@xxxxxxx.com>
EXPECTED BEHAVIOR
-----------------------
Both the records in per_all_people_f are expected to get updated with the new email id.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to the HR Foundation responsibility
2. Find the employee
3. Enter Employment End Date and save
4. Update the email id and save
6. Check the data in per_all_people_f
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |