ESOCIAL - Error Position: 0 Return: 805 - ORA-00001: Unique Constraint (SYSADM.PS_GPBR_M_08_TMP4).

(Doc ID 2391635.1)

Last updated on MAY 11, 2018

Applies to:

PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Error when running the eSocial Employee Initial, events S-2200 and S-2300.

ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_GPBR_M_08_TMP4) violated
Failed SQL stmt: INSERT INTO PS_GPBR_M_08_TMP4 ( PROCESS_INSTANCE ,GPBR_DRIVER_SEQ ,GPBR_DRV_SPLIT_SEQ ,EMPLID ,EMPL_RCD ,LAST_HIRE_DT ,EFFDT ) SELECT 1249933 , MAP.GPBR_DRIVER_SEQ , MAP.GPBR_DRV_SPLIT_SEQ , JOB.emplid , JOB.EMPL_RCD , JOB.last_hire_dt , JOB.effdt FROM PS_JOB JOB , PS_GPBR_DRVEMP_XRF XRF , PS_GPBR_MAP_TMP4 MAP WHERE JOB.EMPLID = XRF.EMPLID AND JOB.EMPL_RCD = XRF.EMPL_RCD AND MAP.GPBR_DRIVER_SEQ = XRF.GPBR_DRIVER_SEQ AND MAP.PROCESS_INSTANCE = 1249933 AND JOB.EFFDT = ( SELECT MAX(JOB2.EFFDT) FROM PS_JOB JOB2 WHERE JOB2.EMPLID = JOB.EMPLID AND JOB2.EMPL_RCD = JOB.EMPL_RCD AND JOB2.ACTION = JOB.ACTION AND JOB2.ACTION_REASON = JOB.ACTION_REASON AND JOB2.EFFDT <= MAP.GPBR_ES_PS AND EXISTS ( SELECT 'X' FROM PS_GPBR_HIR_TMP4 HIR WHERE JOB2.ACTION = HIR.ACTION AND JOB2.ACTION_REASON = HIR.ACTION_REASON AND HIR.GPBR_EVENT_CD IN ('S-2200') AND HIR.PROCESS_INSTANCE = MAP.PROCESS_INSTANCE AND GPBR_HIRE_CODE IN ('2','3') ) ) AND JOB.LAST_HIRE_DT < JOB.EFFDT AND NOT EXISTS ( SELECT 'X' FROM PS_GPBR_M_08_TMP4 TMP2 WHERE TMP2.PROCESS_INSTANCE = MAP.PROCESS_INSTANCE AND TMP2.GPBR_DRIVER_SEQ = MAP.GPBR_DRIVER_SEQ )

Process 1249933 ABENDED at Step GPBR_ES_MAP.Empl_Tmp.Emp_tmp8 (SQL) -- RC = 805 (108,524)

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


Changes

 

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