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 DECEMBER 09, 2022

Applies to:

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

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