Delivery Status Open, Deliveries have Shipped Interfaced Delivery Details
Last updated on DECEMBER 19, 2017
Applies to:Oracle Shipping Execution - Version 126.96.36.199 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