My Oracle Support Banner

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 MAY 25, 2021

Applies to:

Oracle Human Resources - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version, Shared HR Issues

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)     <>

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)             <>
01-May-2049  31-Dec-4712   <Employee_name>            <99999>      <00009999>           EX_EMP-Ex-employee (6) 

3. When Email Address is changed:<>

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)                <>
01-May-2049    31-Dec-4712   <Employee_name>           <99999>      <00009999>         EX_EMP-Ex-employee (6)     <>

Both the records in per_all_people_f are expected to get updated with the new email id.

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




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

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