My Oracle Support Banner

"ORA-20001: The primary key specified is invalid" While Executing "HR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP" API (Doc ID 3037411.1)

Last updated on JULY 25, 2024

Applies to:

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

Symptoms

When trying to execute hr_ex_employee_api, following error appears

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_EX_EMPLOYEE_API", line 2633
ORA-06512: at "APPS.HR_UTILITY", line 970
ORA-06512: at "APPS.PER_PDS_BUS", line 2705
ORA-06512: at "APPS.HR_EX_EMPLOYEE_BK2", line 60
ORA-06512: at "APPS.HR_EX_EMPLOYEE_API", line 2257
ORA-06512: at line 17



The issue can be reproduced at will with the following steps:

1. Login to database.

2. Execute the API "hr_ex_employee_api.final_process_emp".

---------------------------------------------------------------------------------------------


-----------------------------------------------------------------------------------------

3. Encounter the above error.

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


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