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 JULY 20, 2018
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
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 :
L_MSG_DATA=ORA-01403: no data found in Package OE_Invoice_PUB Procedure Interface_Single_line
Order Number :XXXXXXX Line Number :2.4
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
order number: <your order number>
HTMomse output shows:
Line ID: XXXXXXX
Line Status: FULFILLED
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!