Return Line Status Shows Fulfilled, Invoice Interface Error ORA-20001 (Doc ID 1136949.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 11.5.10.1 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

Issue is not reproducible at will, but every day , there are many RMAs (3-4) which after receiving in inventory, line status become Fullfilled.

The issue was never faced earlier in 5-6 years of running live, but started happening now after upgrade to RUP ATG 7.

Workflow has the following error:

Invoice Interface - Line, Deferred
Invoice Interface
Exception
Error -20001
ORA-20001: OE_Invoice_WF.Invoice_Interface(OEOL, 1484088, 149054, RUN)
 Wf_Engine_Util.Function_Call(OE_INVOICE_WF.INVOICE_INTERFACE, OEOL, 1484088, 149054, RUN)

 

Changes

The issue was never faced earlier in 5-6 years of running live, but started happening now after upgrade to RUP ATG 7.

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