ESOCIAL: ORA-22835: Buffer Too Small for CLOB to CHAR or BLOB to RAW Conversion. (Doc ID 2391752.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Symptoms

Error running the eSocial Employee Initial(Global Payroll & Absence Mgmt > Absence and Payroll Processing > Reports > eSocial BRA > 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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.