My Oracle Support Banner

HC_COMP_COMPENSATION_HISTORY Index Failing Due To Unique Constraint error at step HR_SRCH_DR.2ChgIns.Step01 (Doc ID 2550247.1)

Last updated on MAY 03, 2021

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Other

PTSF_GENFEED process is failing to crawl the HC_COMP_COMPENSATION_HISTORY index due to a unique constraint error.

ERROR
-----------------------
-- 10:57:05.830 Process 475277 ABENDED at Step HR_SRCH_DR.2ChgIns.Step01 (Action SQL) -- RC = 805
ROLLBACK
/
-- 10:57:05.874 SQL Error: ORA-00001: unique constraint (SYSADM.PS_HR_SRCH_CHG_2) violated

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
References


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