Invoice Error ORA-01403: No Data Found in Package OE_INVOICE_PUB, OE_Invoice_PUB.Get_Regular_Qty_To_Invoice (Doc ID 2181481.1)

Last updated on FEBRUARY 03, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Transaction Entry

Order Line Status Interfaced but not available in interface
System did not Interface the Invoice but Sale Oder line status is "Interfaced"

The following error is noticed after setting the OM: Debug Level system profile to '5' for the USER,

and running the Retry Activities in Error (Concurrent Program) in Order Management:

 

No prepayments for the order
ENTER TO GET QUANTITY TO INVOICE ( )
THIS IS NOT REMNANT PTO
OTHER EXCEPTION. EXITING INTERFACE_SINGLE_LINE : ORA-01403: no data found
RETURN STATUS :S OUT RESULT :
LEAVING OE_MSG_PUB.ADD
..
ENTER Save_API_Messages
l_errmsg ORA-20001:
L_MSG_DATA=ORA-01403: no data found in Package OE_Invoice_PUB Procedure Interface_Single_line
Order Number :XXXXXXX Line Number :2.4


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as order management responsibility
2. Run Retry Activities in Error Concurrent Program
enter parameters:
order number: <your order number>
mode: execute

HTMomse output shows:
Line: 2.4
Line ID: XXXXXXX
Line Status: FULFILLED


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