My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2021

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

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
Goal
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.