My Oracle Support Banner

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 later
Information 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


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