Order Lines Failing Fulfillment With ORA-20001 ORA-01403: No Data Found in Package OE_Line_Fullfill Procedure Update_Blanket_Qty

(Doc ID 1944812.1)

Last updated on JANUARY 31, 2018

Applies to:

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


When attempting to progress several (blanket) sales order lines, they are not completing the Fulfillment activity
and failing to interface to AR. A retry attempt of Fulfillment is failing with the following error.

Error Name :-20001
Error Message: ORA-20001:
Error Stack: OE_Fulfill_WF.Fulfillment(OEOL, 1875488, 262787, RUN, E1,E6,E22-1,E22-2,) Wf_Engine_Util.Function_Call(OE_FULFILL_WF.START_FULFILLMENT, OEOL, 1875488, 262787, RUN)

Line validation Errors
ORA-01403: no data found in Package OE_Line_Fullfill Procedure Update_Blanket_Qty OPEN
Workflow activity Fulfill has failed. Please fix the errors and retry the activity from the Order Form or the Workflow Monitor. OPEN
User-Defined Exception in Package OE_Line_Fullfill Procedure Process_Fulfillment OPEN



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