Error Running Search Index for HC_HRS_APP_INDEX: "ORA-00001: Unique Constraint (PSDB.PS_HRS_APPACMP_TMP) Violated "
(Doc ID 1631496.1)
Last updated on APRIL 04, 2025
Applies to:
PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When trying to build search index HC_HRS_APP_INDEX, the application engine HRS_APP_SCH runs to NO Success.
STEPS TO REPLICATE
--------------------
1. Build Search Index Settings - Recruiting > Administration > Build Search Index Settings - all Statuses selected. Eff Date of 1901/01/01
2. Deploy Search Definition HC_HRS_APP_INDEX - Ptools > Search Framework > Administration > Deploy/Delete Object
3.Navigation : PeopleTools > Search Framework > Administration > Schedule Search Index
Add Run Control ID
Enter Search Definition : HC_HRS_APP_INDEX
Select Full index
Select All Language
Save and Run the Process
Click OK on Process Scheduler Request page.
But Process error out.
ERROR MESSAGE
-----------------------
The error log is as follows:
PeopleTools 8.53.02 - Application Engine Copyright (c) 1988-2013 Oracle and/or its affiliates.
All Rights Reserved
Starting program PTSF_GENFEED (35,36)
Process PTFPSESARCH completed successfully. (158,2801)
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (PSDB.PS_HRS_APPACMP_TMP) violated
Failed SQL stmt: INSERT INTO PS_HRS_APPACMP_TMP (HRS_PERSON_ID, HRS_PROFILE_SEQ, JPM_CAT_ITEM_ID, JPM_CAT_TYPE, JPM_CAT_ITEM_QUAL, JPM_CAT_ITEM_QUAL2, JPM_DESCR90) SELECT A.HRS_PERSON_ID, A.HRS_PROFILE_SEQ, A.JPM_CAT_ITEM_ID, A.JPM_CAT_TYPE, A.JPM_CAT_ITEM_QUAL, A.JPM_CAT_ITEM_QUAL2, A.JPM_DESCR90 FROM PS_HRS_APPITM03_VW A, PS_HRS_APPI_ALL_VW B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = B.HRS_PROFILE_SEQ
Process 162212 ABENDED at Step HRS_APP_SCH.JPM_OFF.Step01 (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |