My Oracle Support Banner

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.

Symptoms

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run Transfer to GL Detail Report (XML)


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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