My Oracle Support Banner

HRS_APP_NTFY ORA-00001: Unique Constraint (SYSADM.PS_HRS_APP_NOT_TAO) Violated Error (Doc ID 2635475.1)

Last updated on FEBRUARY 04, 2020

Applies to:

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

Symptoms

After turning on the feature to notify applicants with unsubmitted job applications, the process gave the following error.


ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_HRS_APP_NOT_TAO) violated
Failed SQL stmt: INSERT INTO PS_HRS_APP_NOT_TAO (HRS_PERSON_ID ,HRS_RCMNT_ID ,HRS_JOB_OPENING_ID ,POSTING_TITLE ,FIRST_NAME ,EMAIL_ADDR ,APP_PER_STATUS ,HRS_SITE_ID ,HRS_DRAFTAPP_NOTFY ,HRS_USUB_TEMPLT_ID ,HRS_REMINDER_DAYS ,HRS_STOP_NOTFY_HRS ,HRS_APP_CREATED_DT ) SELECT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_JOB_OPENING_ID ,A.POSTING_TITLE ,COALESCE(D.FIRST_NAME , ' ') ,COALESCE(E.EMAIL_ADDR ,' ') ,B.APP_PER_STATUS , COALESCE(C.HRS_SITE_ID ,1) , COALESCE(C.HRS_DRAFTAPP_NOTFY ,'Y') , COALESCE(C.HRS_USUB_TEMPLT_ID ,'HRS_APP_NOTIF_UNS') , COALESCE(C.HRS_REMINDER_DAYS ,2) , COALESCE(C.HRS_STOP_NOTFY_HRS ,24) , A.HRS_APP_CREATED_DT FROM PS_HRS_APP_OAPL_VW A LEFT OUTER JOIN PS_HRS_UNSUB_NT_VW C ON (A.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.HRS_RCMNT_ID = C.HRS_RCMNT_ID) LEFT OUTER JOIN PS_HRS_APP_PRINM_I D ON (A.HRS_PERSON_ID = D.HRS_PERSON_ID) LEFT OUTER JOIN PS_HRS_APP_EMAIL_I E ON (A.HRS_PERSON_ID = E.HRS_PERSON_ID) , PS_HRS_APPLICANT B WHERE A.HRS_DRFT_STS_IND = 'Y' AND A.HRS_PERSON_ID = B.HRS_PERSON_ID

Process 1240277 ABENDED at Step HRS_APP_NTFY.MAIN.AppData (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 10.00.10 2020-01-20


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


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