My Oracle Support Banner

Unable to Close Deliveries. Get Error: Delivery XXXX Status Cannot Be Changed (Doc ID 299197.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Oracle Shipping Execution - Version 11.5.9 to 11.5.10.2 [Release 11.5 to 11.5.10]
Oracle Shipping Execution - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Form:WSHFSTRX.FMB - Shipping Transactions Form




Symptoms

There are deliveries that have been ship confirmed and then interfaced to OM and INV.
However, the deliveries still show a status as OPEN instead of CLOSED.

While in the Shipping Transactions form, query the delivery and see all details are interfaced.  However, when trying to close the delivery get the following message:

Delivery xxxx cannot be closed because there are unshipped lines assigned to this delivery


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Shipping > Transactions.
2. Query the delivery and see all details are interfaced
3. Attempt to close the delivery get the message: Delivery <delivery number> cannot be closed because there are unshipped lines assigned to this delivery

 NOTE:

These deliveries should have a status of closed as the following scenario exists:

a) OE_ORDER_LINES shows the order line with FLOW_CODE = CLOSED
b) WSH_TRIP_STOPS shows trips are closed and None are Pending Interface
c) WSH_DELIVERY_DETAILS shows that the delivery detail is shipped and interfaced to OM and INV.

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!


In this Document
Symptoms
Changes
Cause
Solution
References

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