My Oracle Support Banner

Incorrect Ship-to Location Populated in Requisition Interface When CTO is Created (Doc ID 1056574.1)

Last updated on JULY 02, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.