ESOCIAL: Error when Running eSocial Basic Initial for event S-2200 in SQL Server.

(Doc ID 2370626.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 eSocial Basic Initial for event S-2200:

ERROR
-----
PeopleTools 8.56.05 - Application Engine
Copyright (c) 1988-2018 Oracle and/or its affiliates.
All Rights Reserved
File: e:\pt85605d-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error
Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion
failed when converting date and/or time from character string. (SQLSTATE 22008) 241
Failed SQL stmt: INSERT INTO PS_GPBR_M_09_TMP4 (PROCESS_INSTANCE,
GPBR_DRIVER_SEQ, GPBR_DRV_SPLIT_SEQ, SEQNUM, DESCR254) SELECT
JOB.PROCESS_INSTANCE, JOB.GPBR_DRIVER_SEQ, JOB.GPBR_DRV_SPLIT_SEQ ,
CASE WHEN ( SELECT MAX(M09.SEQNUM) + 1 FROM PS_GPBR_M_09_TMP4 M09
WHERE M09.PROCESS_INSTANCE = JOB.PROCESS_INSTANCE AND
M09.GPBR_DRIVER_SEQ = JOB.GPBR_DRIVER_SEQ AND M09.GPBR_DRV_SPLIT_SEQ =
JOB.GPBR_DRV_SPLIT_SEQ) IS NULL THEN 1 ELSE ( SELECT MAX(M09.SEQNUM) + 1
FROM PS_GPBR_M_09_TMP4 M09 WHERE M09.GPBR_DRIVER_SEQ =
JOB.GPBR_DRIVER_SEQ AND M09.GPBR_DRV_SPLIT_SEQ =
JOB.GPBR_DRV_SPLIT_SEQ) END, 'Exame Toxicologico: '+ DRUG.EXAM_DT + ' - ' +
LAB.LAB_CNPJ_BRA + ' - ' + MED.MED_CRM_BRA + ' - ' + MED.STATE + ' - ' +
DRUG.EXAM_NBR_BRA FROM PS_GPBR_JOB_TMP4 JOB, PS_EMP_DRUG_TS_BRA
DRUG, PS_LAB_PROVID_BRA LAB, PS_PHYSICIAN_BRA MED WHERE
JOB.PROCESS_INSTANCE = 398755 AND DRUG.EMPLID = JOB.EMPLID AND
DRUG.EXAM_DT = ( SELECT MAX(DRUG_ED.EXAM_DT) FROM PS_EMP_DRUG_TS_BRA
DRUG_ED WHERE DRUG_ED.EMPLID = DRUG.EMPLID AND DRUG_ED.EXAM_DT <=
JOB.EFFDT) AND LAB.LAB_ID_BRA = DRUG.LAB_ID_BRA AND LAB.EFFDT=(SELECT
MAX(EFFDT) FROM PS_LAB_PROVID_BRA LAB_ED WHERE
LAB_ED.LAB_ID_BRA=LAB.LAB_ID_BRA AND LAB_ED.EFFDT<=DRUG.EXAM_DT) AND
MED.NON_EMPLOYEE_ID = DRUG.NON_EMPLOYEE_ID
O processo 398755 foi INTERROMPIDO na Etapa GPBR_ES_MAP.Empl_Tmp.Emp_tm9b
(SQL) - RC = 8601 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Global Payroll & Absence Mgmt-> Global Payroll & Absence Processing-> Reports-> eSocial BRA-> eSocial Basic Initials.
2 - Select S-2200 event
3 - Select Limit Date: 02/23/2018 Adhere to eSocial : 01/05/208 Active employees date ref: 04/01/2018

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