My Oracle Support Banner

When Rehiring Former Contingent Worker, Error occurs: Duplicate key value -- not allowed. (15,7) (Doc ID 1682789.1)

Last updated on JULY 01, 2016

Applies to:

PeopleSoft Enterprise HRMS Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On : 9.2 version, Manage Applicant

When attempting to use Add a Person to rehire a former Contingent Worker, the Biographical page shows old effective date in the name grid instead of the latest effective date and the following error occurs:

Duplicate key value -- not allowed. (15,7)

You have entered a key value for a scroll item that is a duplicate of another scroll item. The record definition indicates that the record does not allow duplicate entries. Either correct the key for the duplicate entry or contact your system administrator to change the record definition.


1.) Navigate to Workforce Administration > Job Information > Job Data and select a CWR (eg:KUN009).
2.) Terminate the CWR by adding a new row in Job Data (termination).
3.) Navigate to Recruiting > Create Applicant. Create a new applicant and provide the same NAME details (first and last name of KUN009) in create applicant page. Also ADD new address details in that page.
4.) Navigate to Recruiting > Search Applicants. Search Applicant and link an existing Job Opening to applicant.
5.) Make Offer and then Offer Accepted and then Prepare for Hire.
6.) Provide the desired start date and Add Person.
7.) In Add a Person, the Name grid shows Old Effective Date.
8.) Click on Contact Information tab.  The address type shows as Invalid and the above error message pops up.

Due to this issue, users cannot rehire a Contingent worker.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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