My Oracle Support Banner

Delivery Status Open, Deliveries have Shipped Interfaced Delivery Details (Doc ID 1131085.1)

Last updated on MAY 29, 2020

Applies to:

Oracle Shipping Execution - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


Find delivery numbers on sales orders still show a status of Open even though all of the lines have been shipped, interfaced, and closed.  When attempting to close the delivery from the form, the following message appears:

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

However, there are no such lines with these deliveries.  You can run the following query to identify such orders:

select distinct wdd.source_header_number, wnd.delivery_id
 from wsh_delivery_details wdd,wsh_delivery_assignments
 wda,wsh_new_deliveries wnd
 where wdd.source_code = 'OE'
 and wdd.delivery_detail_id = wda.delivery_detail_id
 and trunc(wdd.creation_date) > sysdate -365
 and wda.delivery_id = wnd.delivery_id
 and wdd.released_status = 'C'
 and wnd.status_code not in ('IT', 'CL')
 order by 1;



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

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