Error when run a GL report with large data
Hi there,
Suddenly we started getting error when running a GL report called Actual versus Budget Expenditures and Revenues, when there is large data involve. Whichever account code combination is used, if there is large data it gives the SAME error as below.
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 2428
Date: 18-MAY-22 10:44:37 CSP DETAIL LISTING OF OBLIGATIONS AND BUDGET REPORT BY DIV ( ALL ) Page No: 1
Current Period: APR-2022
0001.190.0000.0000000.0000.00.0000000.00000.0000
0001.190.9999.9999999.9999.99.9999999.99999.9999
Any suggestions, thoughts are highly appreciated.
Regards,
DE