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 04, 2024

Applies to:

Oracle Order Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Symptoms:

Actual Behaviour:

  1. When attempting to progress order lines to closure
  2. Sales Order Line Stuck at Invoice Activity and not getting closed with
  3. Sales Order Stuck with Fulfilled Status and stuck in workflow with below error


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.

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
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.