Colombian Third Party Generate Balances Program Errors With ORA-06512: At "APPS.JL_CO_GL_NIT_MANAGEMENT" (Doc ID 1945078.1)

Last updated on JANUARY 26, 2015

Applies to:

Oracle Financials for the Americas - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On an 11.5.10.2 version, using Colombia General Leder:


When attempting to run the Colombian Third Party Generate Balances Program, the following error occurs:

ERROR
-----------------------
ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.JL_CO_GL_NIT_MANAGEMENT", line 2130
ORA-06512: at line 1
.

The SQL statement being executed at the
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Create_Trx_Balance: Start
Create_Trx_Balance: Entering FOR LOOP
Generate_Non_Oracle_trx:ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Create_Trx_Balance:ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms