DATAFIX - Unable To Book The Sales Order Line As It Is Stuck In Entered Status. (Doc ID 1492391.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Jun-2014***
***Checked for relevance on 30-Dec-2015***

Symptoms

On : 11.5.10.2 version,

ACTUAL BEHAVIOR 
Unable to Book the Sales Order line as it is Stuck in Entered status. Order Line is stuck in
Entered status and the workflow is stuck in Shipped Manual Stage.

ERROR
  WORKFLOW LINE STATUS >>> FORCED
  22201709 Ship - Line, Manual Ship Force Complete SHIP_CONFIRM SHIP_LINE 11-SEP-12_11:00:46 11-SEP-12_11:02:21 -20001
  22201709 Ship - Line, Manual Ship Exception Error SHIP_CONFIRM SHIP_LINE 11-SEP-12_11:05:37 -20001

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 
 

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