Error 'ORA-01426: numeric overflow' Occurs while Running Create Intercompany AR Invoice Program (Doc ID 1233843.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

Create Intercompany AR Invoices concurrent program (INCIAR) completes with below 
ERROR
------
APP-FND-01564: ORACLE error 1426 in inilcoi()
Error: Fatal error detected. Program aborting
ORA-01426: numeric overflow
Inciar log file 
---------------
SQL error in inilcoi()
APP-FND-01564: ORACLE error 1426 in inilcoi()
Cause: inilcoi() failed due to ORA-01426: numeric overflow
The SQL statement being executed at the time of the error was: and was executed from the file .
Error: Fatal error detected. Program aborting
End Processing Transaction ID: 5206.000000
Transaction ID: 5206.000000 Status = FAILURE
In inlico.lpc, inilfoc()
In inlico.lpc, getOrgInfo()
.Returning success
End of inilfoc().
ORA-01426: numeric overflow
For a run with Inventory debug mode enabled, the following is seen in the request log:
[
Getting Transaction flow information
global->invInfo.ap.custTrxLnId =
35979570913082558096475128260500000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000.000000 
custTrxLnId =
35979570913082558096475128260500000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000.000000 
Discrete Org
SQL error in inilcoi()
APP-FND-1564: ORACLE error 1426 in inilcoi()
Cause: inilcoi() failed due to ORA-1426: numeric overflow
]
Following error occurs while attempting to run the request "Create Intercompany AR invoice",ERROR

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