How to Correct Organization ID mismatch in po_line_locations_all and po_distributions_all?
Last updated on JULY 11, 2017
Applies to:Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
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
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