Error Applying OFCCP HR 9.1 VET Patch 17456416: "ORA-00001: Unique Constraint (SYSADM.PS_HRS_APP_MIL_USA) Violated " (Doc ID 1917160.1)

Last updated on FEBRUARY 09, 2016

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Applying the OFCCP HR 9.1 Vet Patch (<Patch 17456416>) and while running the below DMS script, the following error is triggered:

Content of DMS query: (rs908147_02.dms) which is giving unique constraint error

INSERT  INTO PS_HRS_APP_MIL_USA
(HRS_PERSON_ID,MIL_DISCHRG_DT_USA,INFO_RCVD_DT,HRS_ROW_ADD_DTTM,HRS_ROW_ADD_OPRID,HRS_ROW_UPD_DTTM,HRS_ROW_UPD_OPRID)
SELECT DISTINCT
PS_HRS_APPLICANT.HRS_PERSON_ID,PS_PERS_MILIT_USA.MIL_DISCHRG_DT_USA,%CURRENTDATEIN,%CURRENTDATETIMEIN,%OPERATORID,%CURRENTDATETIMEIN,%OPERATORID
FROM PS_PERS_MILIT_USA , PS_HRS_APPLICANT  WHERE PS_PERS_MILIT_USA.EMPLID=PS_HRS_APPLICANT.EMPLID;

Error Message copied and pasted below:
PeopleTools 8.52.12 - Data Mover Copyright (c) 2014 PeopleSoft, Inc.
All Rights Reserved

Message Set Number: 200
Message Number: 0
Message  Reason: File:
E:\pt852-903-R1-retail\peopletools\src\psdmtx\dmtcmd.cppSQL error. Stmt  #: 346 Error Position: 0 Return: 805 - ORA-00001: unique constraint
(SYSADM.PS_HRS_APP_MIL_USA) violated Failed SQL stmt:INSERT INTO PS_HRS_APP_MIL_USA
(HRS_PERSON_ID,MIL_DISCHRG_DT_USA,INFO_RCVD_DT,HRS_ROW_ADD_DTTM,HRS_ROW_ADD_OPRID,HRS_ROW_UPD_DTTM,HRS_ROW_UPD_OPRID)
SELECT DISTINCT
PS_HRS_APPLICANT.HRS_PERSON_ID,PS_PERS_MILIT_USA.MIL_DISCHRG_DT_USA,TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'),CAST(SYSTIME (200,0)

Logging status in C:\Users\prcs\AppData\Local\Temp\datamove.log

Error:
SQL execute error for INSERT INTO PS_HRS_APP_MIL_USA
(HRS_PERSON_ID,MIL_DISCHRG_DT_USA,INFO_RCVD_DT,HRS_ROW_ADD_DTTM,HRS_ROW_ADD_OPRID,HRS_ROW_UPD_DTTM,HRS_ROW_UPD_OPRID)
SELECT DISTINCT
PS_HRS_APPLICANT.HRS_PERSON_ID,PS_PERS_MILIT_USA.MIL_DISCHRG_DT_USA,TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'),CAST(SYSTIMESTAMP
AS TIMESTAMP),'PS',CAST(SYSTIMESTAMP AS TIMESTAMP),'PS' FROM
PS_PERS_MILIT_USA , PS_HRS_APPLICANT WHERE
PS_PERS_MILIT_USA.EMPLID=PS_HRS_APPLICANT.EMPLID

ORA-00001: unique constraint (SYSADM.PS_HRS_APP_MIL_USA) violated

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