AGIS Transactions Ends With Error When The Amount Is Greater Than 9 Integer Digits

(Doc ID 2330485.1)

Last updated on NOVEMBER 22, 2017

Applies to:

Oracle General Ledger - Version 12.0 and later
Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

Issue Clarification
---------------------------

When Running the Advanced Global Intercompany Transactions to AR (AGIS) the workflow is not transferring the data to the interface tables and erroring.

ERROR / ISSUE
-----------------------
Error Message = ORA-6502: PL/SQL: numeric or value error: character to number conversion error
Error Stack =
FUN_INITIATOR_WF_PKG.CHECK_AR_SETUP


STEPS
-----------------------

Create an intercompany transaction with more than 9 digits for the currency amount.
Error occurs

BUSINESS IMPACT
-----------------------
Not able to create intercompany transaction and create the invoices.

Cause

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