Data Archive Manager Process For HRS_APPLICANT Is Going To Error - "unique constraint (SYSADM.PS_HRS_APPLICA_HST) violated "
(Doc ID 3065820.1)
Last updated on FEBRUARY 26, 2025
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
SQL error occurring when running Data Archive Manager process for HRS_APPLICANT.
Steps to reproduce the issue:
1. Navigate to Main Menu >Peopletools > Data Archive Manager > Archive Data to History
2. Run for HRS_APPLICANT
Return: 805 - ORA-00001: unique constraint (SYSADM.PS_HRS_APPLICA_HST) violated
Statement: INSERT INTO PS_HRS_APPLICA_HST (PSARCH_ID, PSARCH_BATCHNUM, HRS_PERSON_ID, APPLID, APP_PER_STATUS, SEX, BIRTHDATE, BIRTHPLACE, BIRTHCOUNTRY, BIRTHSTATE, EMPLID, HRS_APP_PREF_CONT, STATUS_CODE, STATUS_REASON, STATUS_DT, HRS_EXT_TRN, POI_TYPE, HRS_PREF_MODE, HRS_ROW_ADD_DTTM, HRS_ROW_ADD_OPRID, HRS_ROW_UPD_DTTM, HRS_ROW_UPD_OPRID) SELECT 'HRS_APP', 1, A.HRS_PERSON_ID, A.APPLID, A.APP_PER_STATUS, A.SEX, A.BIRTHDATE, A.BIRTHPLACE, A.BIRTHCOUNTRY, A.BIRTHSTATE, A.EMPLID, A.HRS_APP_PREF_CONT, A.STATUS_CODE, A.STATUS_REASON, A.STATUS_DT, A.HRS_EXT_TRN, A.POI_TYPE, A.HRS_PREF_MODE, A.HRS_ROW_ADD_DTTM, A.HRS_ROW_ADD_OPRID, A.HRS_ROW_UPD_DTTM, A.HRS_ROW_UPD_OPRID FROM PS_HRS_APPLICANT A, PS_HRS_APP_PROFILE B, PS_HRS_RCMNT E
Statement: INSERT INTO PS_HRS_APPLICA_HST (PSARCH_ID, PSARCH_BATCHNUM, HRS_PERSON_ID, APPLID, APP_PER_STATUS, SEX, BIRTHDATE, BIRTHPLACE, BIRTHCOUNTRY, BIRTHSTATE, EMPLID, HRS_APP_PREF_CONT, STATUS_CODE, STATUS_REASON, STATUS_DT, HRS_EXT_TRN, POI_TYPE, HRS_PREF_MODE, HRS_ROW_ADD_DTTM, HRS_ROW_ADD_OPRID, HRS_ROW_UPD_DTTM, HRS_ROW_UPD_OPRID) SELECT 'HRS_APP', 1, A.HRS_PERSON_ID, A.APPLID, A.APP_PER_STATUS, A.SEX, A.BIRTHDATE, A.BIRTHPLACE, A.BIRTHCOUNTRY, A.BIRTHSTATE, A.EMPLID, A.HRS_APP_PREF_CONT, A.STATUS_CODE, A.STATUS_REASON, A.STATUS_DT, A.HRS_EXT_TRN, A.POI_TYPE, A.HRS_PREF_MODE, A.HRS_ROW_ADD_DTTM, A.HRS_ROW_ADD_OPRID, A.HRS_ROW_UPD_DTTM, A.HRS_ROW_UPD_OPRID FROM PS_HRS_APPLICANT A, PS_HRS_APP_PROFILE B, PS_HRS_RCMNT E
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 |