My Oracle Support Banner

AGIS Batch Error Generating Intercompany Accounts - ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package FUN_XLA_TAB_PKG Procedure write_online_tab (Doc ID 2675670.1)

Last updated on MAY 29, 2020

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
AGIS
FUN_XLA_TAB_PKG
ORA-06502
Descriptive Flexfield
numeric or value error
character string buffer too small
write_online_tab

Symptoms

On : 12.1.3 version, AGIS General Ledger

ACTUAL BEHAVIOR
---------------
AGIS Batch:Error generating Intercompany Accounts

AGIS Batch after the approval was going to Error with Error msg:Error generating Accounts: Outboundbatch93,Transaction1 encountered errors deriving Intercompany Accounts

If the user enters a value longer than about 70 characters for any DFF field on "Intercompany Transaction Headers" using the "150 Characters" value set, the transaction errors as follows after approval:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package FUN_XLA_TAB_PKG Procedure write_online_tab

If the user enters a transaction where the DFF field is 70 characters or less, the same transaction will go through without error.

 

Changes

 Added a Descriptive Flexfield segment using any value set longer than 80 characters.

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.