ESOCIAL: Error When Generating Iniciais Funcionário ESocial Process For Event Code S-2200

(Doc ID 2357556.1)

Last updated on MARCH 02, 2018

Applies to:

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

Symptoms

On : 9.2 version, eSocial

Error when generating event S-2200

ERROR
-----------------------
Processo 468804 reiniciado após o passo GPBR_ES_MAP.Name_Val.Step02 (108,538)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1708 Error Position: 2965 Return: 932 - ORA-00932: inconsistent datatypes: expected CHAR got CLOB
Failed SQL stmt: INSERT INTO PS_GPBR_M_04_TMP4 (PROCESS_INSTANCE ,GPBR_DRIVER_SEQ ,GPBR_DRV_SPLIT_SEQ ,GPBR_EVENT_CD ,ADDR_FIELD2 ,ADDRESS1 ,NUM1 ,GPBR_COMPL ,GPBR_COUNTY ,POSTAL ,GPBR_CODE_CITY ,GPBR_STATE ,COUNTRY ,ADDRESS1_OTHER ,NUM1_OTHER ,ADDRESS2_OTHER ,ADDRESS3_OTHER ,CITY50_OTHER ,POSTAL_OTHER ,GPBR_DISAB_FIS ,GPBR_DISAB_VIS ,GPBR_DISAB_HEA ,GPBR_DISAB_MEN ,GPBR_DISAB_INT ,GPBR_REHABILITATED ,GPBR_COD_CATEG_TSV , GPBR_ABSEN_DT , GPBR_ABSEN_CD , GPBR_DISAB_QUOTA , GPBR_DISAB_QTA_DTL ) SELECT TMP.PROCESS_INSTANCE , TMP.GPBR_DRIVER_SEQ , TMP.GPBR_DRV_SPLIT_SEQ , TMP.GPBR_EVENT_CD , CASE WHEN ADR.COUNTRY = 'BRA' THEN CASE WHEN ADT.GPBR_ESOC_ADDTYPE IS NULL THEN ' ' ELSE ADT.GPBR_ESOC_ADDTYPE END ELSE ' ' END , CASE WHEN ADR.COUNTRY = 'BRA' THEN SUBSTR(ADR.ADDRESS1 ,1 ,55) ELSE ' ' END , CASE WHEN ADR.COUNTRY = 'BRA' THEN CASE WHEN SUBSTR(ADR.NUM1 ,1 ,6) = ' ' THEN 'S/N' ELSE SUBSTR(ADR.NUM1 ,1 ,6) END ELSE ' ' END , CASE WHEN ADR.COUNTRY = 'BRA' THEN SUBSTR(ADR.ADDRESS2 || ' ' || ADR.ADDRESS3 ,1 ,30) ELSE ' ' END , CASE WHEN ADR.COUNTRY = 'BRA' THEN SUBSTR(ADR.ADDRESS4 ,1 ,60) ELSE ' ' END , CASE WHEN ADR.COUNTRY = 'BRA' THEN REPLACE(SUBSTR(ADR.POSTAL ,1 ,12) , '-' , '') ELSE ' ' END , CASE WHEN ADR.COUNTRY = 'BRA' THEN CASE WHEN CCD.CODE_CITY_BRA IS NULL THEN 0 ELSE CCD.CODE_CITY_BRA END ELSE 0 END , CASE WHEN ADR.COUNTRY = 'BRA' THEN SUBSTR(ADR.STATE ,1 ,2) ELSE ' ' END ,CASE WHEN ADR.COUNTRY <> 'BRA' THEN CASE WHEN ESC.ES_COUNTRY_CD_BRA IS NULL THEN ' ' ELSE ESC.ES_COUNTRY_CD_BRA END ELSE ' ' END ,CASE WHEN ADR.COUNTRY <> 'BRA' THEN ADR.ADDRESS1 ELSE ' ' END ,CASE WHEN ADR.COUNTRY <> 'BRA' THEN CASE WHEN ADR.NUM1 = ' ' OR ADR.NUM1 = '0' THEN 'S/N' ELSE ADR.NUM1 END ELSE ' ' END ,CASE WHEN ADR.COUNTRY <> 'BRA' THEN ADR.ADDRESS2 ELSE ' ' END ,CASE WHEN ADR.COUNTRY <> 'BRA' THEN ADR.ADDRESS3 ELSE ' ' END ,CASE WHEN ADR.COUNTRY <> 'BRA' THEN ADR.CITY ELSE ' ' END ,CASE WHEN ADR.COUNTRY <> 'BRA' THEN ADR.POSTAL ELSE ' ' END , CASE WHEN DIS1.DISABLED_TYPE_BRA = '1' OR DIS2.DISABLED_TYPE_BRA = '7' THEN 'S' ELSE 'N' END , CASE WHEN DIS3.DISABLED_TYPE_BRA = '3' THEN 'S' ELSE 'N' END , CASE WHEN DIS4.DISABLED_TYPE_BRA = '2' THEN 'S' ELSE 'N' END , CASE WHEN DIS5.DISABLED_TYPE_BRA = '4' THEN 'S' ELSE 'N' END , CASE WHEN DIS6.DISABLED_TYPE_BRA = '8' THEN 'S' ELSE 'N' END , CASE WHEN DIS7.PPP_SITUATION_BRA = 'REB' THEN 'S' ELSE 'N' END , JOB.EMPL_CLASS , CASE WHEN TMP.LAST_HIRE_DT < COMP_PARAM.GPBR_ES_PS THEN CASE WHEN TKE.GPBR_ABS_CODE IS NULL OR EVT.BGN_DT >= TMP.GPBR_ES_PS THEN NULL ELSE EVT.BGN_DT END ELSE CASE WHEN TKE.GPBR_ABS_CODE IS NULL THEN NULL ELSE EVT.BGN_DT END END , CASE WHEN TMP.LAST_HIRE_DT < COMP_PARAM.GPBR_ES_PS THEN CASE WHEN TKE.GPBR_ABS_CODE IS NULL OR EVT.BGN_DT >= TMP.GPBR_ES_PS THEN ' ' ELSE TKE.GPBR_ABS_CODE END ELSE CASE WHEN TKE.GPBR_ABS_CODE IS NULL THEN ' ' ELSE TKE.GPBR_ABS_CODE END END , CASE WHEN DIS7.DISAB_QUOTA_BRA = 'Y' THEN 'S' ELSE 'N' END , CASE WHEN DIS7.DISAB_QTA_DTL_BRA IS NULL THEN ' ' ELSE SUBSTR(RTRIM(DIS7.DISAB_QTA_DTL_BRA), 1, 255) END FROM PS_GPBR_M_01_TMP4 TMP LEFT OUTER JOIN PS_DISABILITY_BRA DIS7 ON DIS7.emplid = TMP.emplid AND DIS7.EFF_STATUS = 'A' AND DIS7.EFFDT <= tmp.gpbr_es_ps LEFT OUTER JOIN PS_DISAB_TYPE_BRA DIS1 ON DIS1.emplid = TMP.emplid AND DIS1.DISABLED_TYPE_BRA = '1' AND dis1.effdt = dis7.effdt LEFT OUTER JOIN PS_DISAB_TYPE_BRA DIS2 ON DIS2.emplid = TMP.emplid AND DIS2.DISABLED_TYPE_BRA = '7' AND dis2.effdt = dis7.effdt LEFT OUTER JOIN PS_DISAB_TYPE_BRA DIS3 ON DIS3.emplid = TMP.emplid AND DIS3.DISABLED_TYPE_BRA = '3' AND dis3.effdt = dis7.effdt LEFT OUTER JOIN PS_DISAB_TYPE_BRA DIS4 ON DIS4.emplid = TMP.emplid AND DIS4.DISABLED_TYPE_BRA = '2' AND dis4.effdt = dis7.effdt LEFT OUTER JOIN PS_DISAB_TYPE_BRA DIS5 ON DIS5.emplid = TMP.emplid AND DIS5.DISABLED_TYPE_BRA = '4' AND dis5.effdt = dis7.effdt LEFT OUTER JOIN PS_DISAB_TYPE_BRA DIS6 ON DIS6.emplid = TMP.emplid AND DIS6.DISABLED_TYPE_BRA = '8' AND dis6.effdt = dis7.effdt LEFT OUTER JOIN PS_GP_ABS_EVENT EVT ON EVT.EMPLID = TMP.EMPLID AND EVT.EMPL_RCD = TMP.EMPL_RCD AND TMP.GPBR_ES_PS >= EVT.BGN_DT AND TMP.GPBR_ES_PS <= EVT.END_DT AND EVT.PRC_EVT_ACTN_OPTN = 'N' LEFT OUTER JOIN PS_GPBR_ES_ABS_VW TKE ON TKE.PIN_TAKE_NUM = EVT.PIN_TAKE_NUM AND (TKE.ABSENCE_REASON = EVT.ABSENCE_REASON OR TKE.ABSENCE_REASON = ' ') , PS_ADDRESSES ADR LEFT OUTER JOIN PS_CODE_CITY_BRA CCD ON CCD.STATE = ADR.STATE AND CCD.CITY = ADR.CITY LEFT OUTER JOIN PS_ES_COUNTRY_BRA ESC ON ESC.COUNTRY = ADR.COUNTRY LEFT OUTER JOIN PS_GPBR_ADDR_TYPE ADT ON ADT.COUNTRY = 'BRA' AND ADDRESS_TYPE_BRA = ADR.ADDR_FIELD2 , PS_GPBR_JOB_TMP4 JOB , PS_GPBR_C_PARM_SRC COMP_PARAM WHERE TMP.PROCESS_INSTANCE = 468804 AND TMP.GPBR_DRIVER_SEQ = JOB.GPBR_DRIVER_SEQ AND TMP.GPBR_DRV_SPLIT_SEQ = JOB.GPBR_DRV_SPLIT_SEQ AND TMP.PROCESS_INSTANCE = JOB.PROCESS_INSTANCE AND ADR.EMPLID = TMP.EMPLID AND ADR.ADDRESS_TYPE = 'HOME' AND ADR.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ADDRESSES WHERE EMPLID = ADR.EMPLID AND ADDRESS_TYPE = ADR.ADDRESS_TYPE AND EFF_STATUS = ADR.EFF_STATUS AND EFFDT <= TMP.GPBR_ES_PS) AND ADR.EFF_STATUS = 'A' AND ( DIS7.effdt IS NULL OR DIS7.effdt = ( SELECT MAX(effdt) FROM ps_disability_bra WHERE emplid = DIS7.emplid AND EFFDT <= TMP.GPBR_ES_PS ) ) AND (ESC.EFFDT IS NULL OR ESC.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ES_COUNTRY_BRA WHERE EFFDT <= TMP.GPBR_ES_PS)) AND TMP.GPBR_EVENT_CD = 'S-2200' AND TMP.COMPANY = COMP_PARAM.COMPANY

O processo 468804 foi INTERROMPIDO na Etapa GPBR_ES_MAP.Empl_Tmp.Emp_tmp4 (SQL) - RC = 932 (108,524)

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

PSAESRV completed service request at 17.34.19 2018-01-31

STEPS
----
1 - Navigate to Global Payroll & Absence Mgmt-> Absence and Payroll Processing-> Reports-> eSocial BRA-> eSocial Employee Initial.
2 - Prepare data and create XML for event S-2200.

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