GP BRA: ESOCIAL - Unique Constraint Error in the Initial Load. (Doc ID 2303254.1)

Last updated on AUGUST 31, 2017

Applies to:

PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Error running  the initial load process:


ERROR
-----------------------
File: e:\pt85415b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_GPBR_BWAG_TAO4) violated
Failed SQL stmt: INSERT INTO PS_GPBR_BWAG_TAO4 (PROCESS_INSTANCE, COMPANY, GPBR_WAGE_TYPES_ID, PIN_ELEM_NUM, GPBR_ES_MAP_DT, PIN_NM, GPBR_ACTION, NUMROWS, GPBR_ROW_SEQUENCE, GPBR_ES_PS, GPBR_EFFDT, GPBR_DRIVER_SEQ) SELECT 335088, C.COMPANY, B.GPBR_WAGE_TYPES_ID, B.PIN_ELEM_NUM, B.BGN_DT, GP.PIN_NM, 'ADD', 0, 1, X.GPBR_ES_PS, ' ', 324 + ROW_NUMBER() OVER (ORDER BY C.COMPANY) FROM PS_COMPANY_TBL_BRA C, PS_GPBR_ELEMENT_DT B, PS_GPBR_CMP_TAO4 X, PS_GP_PIN GP WHERE X.COMPANY = C.COMPANY AND X.PROCESS_INSTANCE = 335088 AND B.COMPANY = C.COMPANY AND B.GPBR_WAGE_TYPES_ID = C.ID_TBL_ED_BRA AND EXISTS( SELECT 'X' FROM PS_GPBR_RCRSLT_T5 A WHERE A.PROCESS_INSTANCE = 335088 AND A.OPRID = 'ROSLUCE' AND A.RUN_CNTL_ID = 'e' AND A.GPBR_ES_SOURCE = 'ILB' AND A.GPBR_EVNT_STATUS = 'A' AND A.GPBR_EVENT_CD = 'S-1010' AND A.COMPANY = C.COMPANY) AND B.BGN_DT = ( SELECT MAX(B1.BGN_DT) FROM PS_GPBR_ELEMENT_DT B1 WHERE B1.GPBR_WAGE_TYPES_ID = B.GPBR_WAGE_TYPES_ID AND B1.COMPANY = B.COMPANY AND B1.PIN_ELEM_NUM = B.PIN_ELEM_NUM AND B1.BGN_DT <= X.GPBR_ES_LAST) AND NOT EXISTS( SELECT 'X' FROM PS_GPBR_DRIVER_DAT GDH , PS_GPBR_DRVWAG_XRF GDX WHERE GDH.GPBR_EVENT_CD = 'S-1010' AND GDH.GPBR_EVENT_CD = GDX.GPBR_EVENT_CD AND GDH.COMPANY = C.COMPANY AND GDX.GPBR_WAGE_TYPES_ID = B.GPBR_WAGE_TYPES_ID AND GDX.PIN_ELEM_NUM = B.PIN_ELEM_NUM AND GDH.GPBR_ES_MAP_DT = B.BGN_DT) AND NOT EXISTS( SELECT 'X' FROM PS_GPBR_BWAG_TAO4 TMP WHERE TMP.PROCESS_INSTANCE = 335088 AND TMP.COMPANY = B.COMPANY AND TMP.GPBR_WAGE_TYPES_ID = B.GPBR_WAGE_TYPES_ID AND TMP.PIN_ELEM_NUM = B.PIN_ELEM_NUM AND TMP.GPBR_ES_PS = X.GPBR_ES_PS)

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