Order Line Stuck in SHIPPED Status. Unable to Close Line. Line Workflow Suspended. (Doc ID 1574598.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 13-JAN-2015***

Symptoms

On : 12.0.4 version, WMS, Shipping & Transportation

Order Number 13891 has stuck line 2.3. The line shows flow code = SHIPPED.
Shipped Qty is updated but Fulfilled and Invoiced Qty = 0. Unable to progress the line and cannot invoice the customer.

Need to progress the line so invoice can be sent to customer.

 

Order output (HTMomse) shows the following:
OE_ORDER_LINES shows line with flow code = SHIPPED
          Ordered and Shipped Quantity are populated.    Fulfilled and Invoiced Qty are Null
.
WORKFLOW LINE STATUS shows no forcing and line is at Process = SHIP_CONFIRM and Status = Suspended
WSH_TRIPS shows Trip is closed
WSH_TRIP_STOPS shows no stop id is pending interface.
WSH_NEW_DELIVERIES shows delivery is closed.
WSH_DELIVERY_DETAILS shows delivery detail is Shipped and interfaced to OM and Inventory
MTL_MATERIAL_TRANSACTIONS shows the sales order issue

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot invoice this critical shipment

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