Transfer To GL Detail Report Errors: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
(Doc ID 2603367.1)
Last updated on OCTOBER 29, 2019
Applies to:Oracle Payroll - Version 12.1 HRMS RUP12 and later
Information in this document applies to any platform.
When running the Transfer to GL Detail Report for the first time, the process errors with the following messages:
ORACLE error 20001 in FDPSTP
Cause: FDPSTP failed due to ORA-20001: Error in procedure tgl_extract
ORA-06512: at "APPS.PAY_TRANGL_DETAIL_REP_PKG", line 246
ORA-06512: at line 1
The SQL statement being executed at the time of the error was: SELECT R.Co
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The issue can be reproduced at will with the following steps:
Run Transfer to GL Detail Report (XML)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document