Last updated on JULY 19, 2016
Applies to:Oracle Shipping Execution - Version 18.104.22.168 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
Million Knowledge Articles and hundreds of Community platforms