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 laterInformation 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 |