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.
numeric or value error
character string buffer too small
On : 12.1.3 version, AGIS General Ledger
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.
Added a Descriptive Flexfield segment using any value set longer than 80 characters.
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