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 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;
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