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 FEBRUARY 13, 2019
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.
-------------------------
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
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |