HC_HR_JOBDATA Incremental Search Index Throwing Unique Constraint Error

(Doc ID 2224813.1)

Last updated on FEBRUARY 14, 2018

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On : 9.2 version, Other

HC_HR_JOBDATA Search Index throwing unique constraint Error


Starting program PTSF_GENFEED (35,36)

File: e:\pt85509c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_HR_JOB_NAME_TMP) violated

Process 126312 ABENDED at Step HR_SRCH_JOB.LoadJobI.Step03 (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 09.17.08 2017-01-19

The issue can be reproduced at will with the following steps:
1. Terminate an activate Contingent Worker with effective date as of today
2. Add New Employment relationship for same emplid with effective date as of today.
3. Run the Incremental Index


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 hundreds of Community platforms