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 AUGUST 03, 2016

Applies to:

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

Symptoms

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
R_STANDARD_LINE FULFILL_LINE #EXCEPTION 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

 

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