HC_HR_JOBDATA Incremental Search Index Throwing Unique Constraint Error (Doc ID 2224813.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms

On : 9.2 version, Other

HC_HR_JOBDATA Search Index throwing unique constraint Error

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

STEPS
-----------------------
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



Cause

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