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:

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

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