ESOCIAL: ORA-22835: Buffer Too Small for CLOB to CHAR or BLOB to RAW Conversion.

(Doc ID 2391752.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 running the eSocial Employee Initial, event S-2200:

ERROR
-----------------------
Error Position: 637 Return: 22835 - ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 6328, maximum: 4000)
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 637 Return: 22835 - ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 6328, maximum: 4000)
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, CASE WHEN CONTRCT.COMMENTS IS NULL THEN ' ' ELSE SUBSTR(CAST(CONTRCT.COMMENTS AS VARCHAR(4000)), 1, 254) END FROM PS_GPBR_JOB_TMP4 JOB, PS_CONTRACT_DATA CONTRCT WHERE JOB.PROCESS_INSTANCE = 1250830 AND JOB.GPBR_EVENT_CD = 'S-2200' AND CONTRCT.EMPLID = JOB.EMPLID AND CONTRCT.CONTRACT_NUM = JOB.CONTRACT_NUM AND LENGTH(CONTRCT.COMMENTS) >= 3


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