Error "ORA-20001: The primary key specified is invalid", When updating Attribute2 column of PER_PERIODS_OF_SERVICE table for Ex-employees Using API HR_PERIODS_OF_SERVICE_API.UPDATE_PDS_DETAILS in case of Multiple Termination records
(Doc ID 2833033.1)
Last updated on JUNE 02, 2024
Applies to:
Oracle Human Resources - Version 12.2.8 and laterInformation in this document applies to any platform.
Symptoms
When attempting to update Attribute2 column of per_periods_of_service table for ex-employees through API HR_PERIODS_OF_SERVICE_API.UPDATE_PDS_DETAILS in case of multiple termination records(person hired, terminated, rehired, terminated) the following error occurs.
ERROR
-----------------------
ERROR: ORA-20001: The primary key specified is invalid
Cause: The primary key values specified are invalid and do not exist in the schema.
Action: Check the primary key values before attempting to carry out the operation again.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to update the Attribute2 column of per_periods_of_service table for ex-employees through API HR_PERIODS_OF_SERVICE_API.UPDATE_PDS_DETAILS
2. Error is thrown in case of multiple termination records(person hired, terminated, rehired, terminated)
3. Person with Single terminate record, it is working fine
Changes
None
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 |