Cannot Process Transactions due to Error ORA-01426: Numeric Overflow in 12.0.6 and 12.1.3 (Doc ID 1951612.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle XML Gateway - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.6 version,
When attempting to send POs to trading partner,
the following error occurs.

ERROR
-----------------------
Error Message = 6012: XML Gateway process aborted : 'ORA-01426: numeric overflow
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.ECX_OUTBOUND", line 1353
ORA-01426: numeric overflow - ECX_DEBUG.PRINT_LOG'. For further details, see the log corresponding to FND-Logging AFLOG MODULE Name: 'ecx.plsql.CXML.out.PO.PRO.7285651:0:23.549532.log'.
Error Stack =
ECX_STANDARD.getXMLCover(CXML, PO, PRO)
ECX_STANDARD.getXMLTP(PO, PRO, 3129742, 2276181)
Wf_Engine_Util.Function_Call(ECX_STANDARD.GETXMLTP, POXML, 9826352-321534, 315967, RUN)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create POs in PO module.


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