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 FEBRUARY 26, 2018

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  ABC           26482        00009952        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    ABC             26482         00009952           EMP-Employee (3)   
01-May-2049  31-Dec-4712   ABC             26482         00009952           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    ABC           26482         00009952           EMP-Employee (3)     
01-May-2049    31-Dec-4712   ABC           26482         00009952           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.