My Oracle Support Banner

The primary key specified is invalid Error during Rehire with EIT information (Doc ID 1928702.1)

Last updated on FEBRUARY 04, 2019

Applies to:

Oracle Self-Service Human Resources - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.


On : 12.1 HRMS RUP6 version, Hire, CWK Placement, Appl Hire

When attempting to rehire an ex-employee in SSHR application while entering the EIT information, the following error occurs.

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 to Reproduce:
The issue can be reproduced at will with the following steps:

1. Navigate to 'Manager Self-Service' responsibility
2. Select Applicant Hire and Rehire function.
3. Search and Ex-employee.
4. Click Hire button.
5. Enter details in Applicant Hire and Rehire: Person details page. Click Next button.
6. Enter details in Applicant Hire and Rehire: Assignment page. Click Next button.
7. Shows Applicant Hire and Rehire: Select A Pay Action page.

8. Assign a New manager in 'Applicant Hire and Rehire: Change Manager' page. , click Next button.
9. Shows 'Applicant Hire and Rehire: Extra Information' page
10. Click Add button for any EIT.

11. Shows Error.
12. The Error does not occur if the EIT information is NOT entered during the Rehire.

Note: If the Ex-Employee does not have EIT information prior to rehire and EIT is entered during the Rehire, the same error will show after the transaction is submitted and approved.



1. Same error does not occur if the EIT information is not entered - Can submit the EIT without any issue.
2. For a existing employee, Extra Information can be enter without any issue. The issue only occurs Rehire with EIT.


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

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