AGIS Batch Having Long Description Got Stuck, Throwing: ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2013279.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Advanced Global Intercompany System (AGIS)

Symptoms

A batch having a very long description (250 characters) has been created in AGIS. Invoicing is not required for it. This batch it did not transfer to GL, its status is 'SENT' and the workflow shows error.

Depending on the setup there may be more symptoms for this issue as described in <Note 1573367.1> FUNGLTRR Transfer Intercompany Transactions To General Ledger Fails With ORA-12899 Value Too Large For Column For REFERENCE10 Field.



ERROR

Failed Activity: Transfer to GL

Activity Type: Function

Error Name: -6502

Error Message: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Error Stack: FUN_GLINT_WF.TRANSFER_TO_GL(FUNGLINT, 123456_1764340138F2AF9F85E05334386B0AF4CE, 196444, RUN)
Wf_Engine_Util.Function_Call(FUN_GLINT_WF.TRANSFER_TO_GL, FUNGLINT, 123456_1764340138F2AF9F85E05334386B0AF4CE, 196444, RUN)



STEPS to reproduce:
1. Review AGIS batches for the period
2. Find that batches having longer descriptions get stuck, throwing error

Changes

Long description entered for the batch.

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