My Oracle Support Banner

ORA-20001: The primary key specified is invalid When Running API HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA (Doc ID 2656259.1)

Last updated on APRIL 06, 2020

Applies to:

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

Symptoms

When attempting to run api HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA, the following error occurs.

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.
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 16616
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 15179
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 14964
ORA-06512: at line 67


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA
2. The above error can be seen

Also already checked the following document, which means that the object version number is correct.

- HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA API Errors with "ORA-20001: The primary key specified is invalid" (<Document 737145.1>)

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
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.