My Oracle Support Banner

Invoice Doesn't Appear To Bring Over Ship To Location for Drop Ship PO - Location Null on Form (Doc ID 1557771.1)

Last updated on AUGUST 24, 2021

Applies to:

Oracle Payables - Version 12.0.1 and later
Oracle Purchasing - Version 12.0.1 and later
Information in this document applies to any platform.

Symptoms

Steps to reproduce:
Create a PO from a drop ship 
Validate PO 
Match invoice to PO 
Check invoice line ship to field... it's NULL
Run aplist and see the ship_to_location_id is populated correctly 
Why is it not showing on the form?
 

Changes

Select LOCATION_CODE 
from HR_LOCATIONS 
Where location_id = XX; 

NOTE: if the above query doesn't return rows then check how is it being used in receiving when the location details are absent in HR.

As per current payables supported code, ship to location must be part of the inventory setups of an organization and hence should be present in HR_LOCATIONS_ALL. 
HZ_LOCATIONS is for external suppliers and has least to do with ship to location. For drop ship sales order, we need information from purchasing which ship to location is being considered. Ideally it should come to the inventory or the ship to location defined in Financial options or at supplier site.

The drop shipment sales order is created first, the PO is created from the drop ship. If the PO has an invalid ship to location, then it is coming from the drop shipment.

For a drop-ship Sales order a PO created automatically inherits the location from the Sales order.

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.