How to Correct Organization ID mismatch in po_line_locations_all and po_distributions_all? (Doc ID 2258975.1)

Last updated on JULY 11, 2017

Applies to:

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

Goal

How to correct Organization ID mismatch in po_line_locations_all and po_distributions_all?

Example Scenario and Data:

PO = 20271209 (po_header_id = 743624, po_line_id =1282392)

Receiving Org = GM2 (4807)

Observe that the po_line_locations_all for the above PO has the ship_to_organization_id = 4807 (GM2)
but the po_distributions_all for the same has the destination_organization_id = 88 (CAN).
Due to this mismatch; mtl_supply also shows the to_organization_id = 88

 

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