Incorrect Ship-to Location Populated in Requisition Interface When CTO is Created

(Doc ID 1056574.1)

Last updated on AUGUST 04, 2014

Applies to:

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

Symptoms

Wrong Ship to location is being passed to the Requisition when a back to back(B2B) order is entered in Order Management.
When B2B populates the requisition interface table, it fetches the locations associated to the shipping warehouse using the query:

SELECT location_id
FROM hr_locations_all
WHERE inventory_organization_id = i_org_id --shipping org
AND ship_to_site_flag = 'Y';

If the Query returns more than one location,  the application picks the first location.

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