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