My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.