Record Issue Where Dates On Person Record Are Not In Order

(Doc ID 2337911.1)

Last updated on DECEMBER 11, 2017

Applies to:

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

Symptoms

We have an employee and somehow HR made 2 different changes to the person record on the same day and it created another person record. When they tried to back out what they did, they removed the change on the wrong person record and now everything we try and do we get an error message. We have tried reversing the term but we can't because it states there are future date person records, when we try and remove the next change on the person record we get an error message. See attached screen shots

ERROR
-----------------------
APP-DT-34605: Oracle error ORA-0001 occurrence writing to PER_ALL_PEOPLE_F Attempt to copy a row in the table (named in error message)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. HRMS Manager
2. Enter People and Maintain
3. Trying to terminate the person the error is reported.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms