Error While Applying BUG 21310989 - ORA-00001: unique constraint (SYSADM.PS_DISABILITY_USA) violated (Doc ID 2245979.1)

Last updated on MARCH 20, 2017

Applies to:

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

Symptoms

Script hr918933_01.dms failed when applying Bug Number 21310989

Bug 21310989 Subject : CONSOLIDATED FIX OF ALL POSTED RESOLUTIONS SINCE HR 9.0 BUNDLE #26

ERROR
-----------------------
ORA-00001: unique constraint (SYSADM.PS_DISABILITY_USA) violated

Failed SQL stmt: INSERT INTO PS_DISABILITY_USA(EMPLID,EFFDT,EFFSEQ,DISABLED_VET,DISABILITY_STS_USA,HR_EE_SIGNATURE,HR_DISCLOSURE_DT,LASTUPDOPRID) SELECT A.EMPLID, TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'), 0, A.DISABLED_VET, A.DISABILITY_STS_USA, A.HR_EE_SIGNATURE, A.HR_DISCLOSURE_DT, 'OOD_ADM' FROM PS_DISA (200,0)
Error: SQL execute error for INSERT INTO PS_DISABILITY_USA(EMPLID,EFFDT,EFFSEQ,DISABLED_VET,DISABILITY_STS_USA,HR_EE_SIGNATURE,HR_DISCLOSURE_DT,LASTUPDOPRID) SELECT A.EMPLID, TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'), 0, A.DISABLED_VET, A.DISABILITY_STS_USA, A.HR_EE_SIGNATURE, A.HR_DISCLOSURE_DT, 'OOD_ADM' FROM PS_DISABILITY A WHERE EXISTS (SELECT 'X' FROM PS_DISABILITY A1 WHERE A1.EMPLID = A.EMPLID AND (A1.DISABLED_VET = 'Y' OR A1.DISABILITY_STS_USA IN ('N','X','Y')))



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms