My Oracle Support Banner

DATAFIX: Unable To Book Sales Order Line As It Is Stuck In Entered Status With Ship - Line, Manual Ship Exception Error -20001 In Line Workflow (Doc ID 1492391.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle Order Management - Version 11.5.10.2 to 12.2.7 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 26-Jun-2014***
***Checked for relevance on 30-Dec-2015***

Symptoms

ACTUAL BEHAVIOR 
Unable to book a Sales Order line as it is Stuck in Entered status.  Workflow line status shows Ship Exception Error ORA- 20001. 

 

ERROR
----------

WORKFLOW LINE STATUS ERRORS
-------------------------
22201709 Ship - Line, Manual Ship Exception Error -20001 ORA-20001: OE_Shipping_WF.Shipping_Activity(OEOL, 22201709, 188500, RUN, 20120420521351,6,10,44,46,Shp-E-4E-34) Wf_Engine_Util.Function_Call(OE_SHIPPING_WF.START_SHIPPING, OEOL, 22201709, 188500, RUN)

LINE PROCESSING MESSAGES
---------------------------------
2 2.1 2086226 22201709 W=Workflow Schedule Could not schedule. Line on hold.
2 2.1 2086226 22201709 W=Workflow Ship Workflow activity Ship has failed. Please fix the errors and retry the activity from the Order Form or the Workflow Monitor.
2 2.1 2086226 22201709 W=Workflow Ship User-Defined Exception in Package MSC_ATP_PVT Procedure Schedule
2 2.1 2086226 22201709 W=Workflow Ship Error: Import order line has failed as order lines were not found.



STEPS
1. Responsibility: Order Management Super User
2. Order Organizer > Sales Order
3. Header is in BOOKED status
4. Go to line 2.1 > Observe line status is stuck in ENTERED 
 

Changes

 

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.