Invoice Import Does Not Use Ship-to Location From PO Shipments (PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID) (Doc ID 1588399.1)

Last updated on DECEMBER 02, 2015

Applies to:

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

Symptoms

1) The supplier site and the PO header have the same ship to location.

For example:

AP_SUPPLIER_SITES_ALL and PO_HEADERS_ALL have SHIP_TO_LOCATION_ID = 182711.

2) The po shipment has the different ship to location.

For example:

PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID = 182713.

3) Populate AP_INVOICE_LINES_INTERFACE with the PO number, PO line number, PO shipment number.

4) Import the invoice,

5) We have found AP_INVOICE_LINES_ALL.SHIP_TO_LOCATION_ID

is using AP_SUPPLIER_SITES_ALL and PO_HEADERS_ALL.SHIP_TO_LOCATION_ID = 182711,

not PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID = 182713.


Cause

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