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