My Oracle Support Banner

Sales Order Lines Stuck Fulfilled Status with Invoice Interface - Line Invoice Interface Exception Error (Doc ID 2763339.1)

Last updated on MARCH 24, 2021

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Finance & Accounting

When attempting to progress order lines to closure,
the following error occurs.

ERROR
-----------------------
Invoice Interface - Line Invoice Interface Exception Error

Sales Order Line Workflow Status Errors
Invoice Interface - Line Invoice Interface Exception Error -20001 ORA-20001: OE_Invoice_WF.Invoice_Interface(OEOL, NNNNNNN, NNNNN, RUN) Wf_Engine_Util.Function_Call(OE_INVOICE_WF.INVOICE_INTERFACE, OEOL, NNNNNNN, NNNNN, RUN)

 

Sales Order Line Process Messages
ORA-01403: no data found ORA-01403: no data found in Package OE_Invoice_PUB Procedure Interface_Single_line

STEPS
-----------------------
The issue can be seen with the following steps:
1. Order Management responsibility
2. Navigation: Orders,Returns>Order Organizer
3. Query order and see errors

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot progress shipped lines to invoice.

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
References


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