Delivery Status Open, Deliveries have Shipped Interfaced Delivery Details

(Doc ID 1131085.1)

Last updated on DECEMBER 19, 2017

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;



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