How to correct the incorrect ship_from_location_id in wsh_delivery_details? (Doc ID 2010823.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

We had to make a change to the ship_from location we use for shipping. Since the location_ids in wsh_delivery_details is not changed when the ship_from_location is changed for the organization in question; what datafix can we use to modify existing delivery details to show the new location id?
 

Solution

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