Report failing with ORA-19011: Character string buffer too small

[VinodN]

Hello Erman,

Hope you are fit and fine. One of our custom reports is failing with the following error on EBS 12.2.10 (19c, RHEL 8):

Call XXST_DASH_GSTR_XML_PRC Start
Error in main procedure.
Error : ORA-19011: Character string buffer too small
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program XXST_DASH_GSTR_REP with request ID 61133603 to start at 27-MAR-2025 00:30:00 (ROUTINE=AFPSRS)


+---------------------------------------------------------------------------+
No completion options were requested.

Output file size:
0
Deleting empty output file.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 26-MAR-2025 02:14:13

Could this be due to OPP buffer size?

Regards,
Vinod

[ErmanArslansOracleBlog]

Check the queries of that report. Probably you have an issue there. Values doesn't fit into the types..  For instance when you try to put a lot of bytes (beyond the limits) to a varchar2, you'll get this error.

Check for getting insight -> ORA-19011: Character String Buffer Too Small When Processing CLOB data in WHERE XML_COLUMN LIKE Conditionals (Doc ID 3076738.1)

[VinodN]

Thanks Erman! Will check.