My Oracle Support Banner

AGIS Transactions Ends With Error When The Amount Is Greater Than 9 Integer Digits (Doc ID 2330485.1)

Last updated on FEBRUARY 11, 2019

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.

Changes

 

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.