Sales Order Lines Stuck Fulfilled Status with Invoice Interface - Line Invoice Interface Exception Error
(Doc ID 2763339.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Order Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Symptoms:
Actual Behaviour:
- When attempting to progress order lines to closure
- Sales Order Line Stuck at Invoice Activity and not getting closed with
- 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
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 |