AGIS Batch Having Long Description Got Stuck, Throwing: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
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)
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.
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
Long description entered for the batch.
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