My Oracle Support Banner

Store Locator Function does not Work Correctly for Stores Without Transfer Zones (Doc ID 2253087.1)

Last updated on MAY 27, 2020

Applies to:

Oracle Retail Store Inventory Management - Version 13.2.8 and later
Information in this document applies to any platform.


On Oracle Retail Store Inventory Management (SIM), Stock Locator functionality is not showing other stores inventory details if the store is missing transfer zone value in PA_STR_RTL table( i.e. PA_STR_RTL.ID_TFS_ZONE is NULL).

Steps to Reproduce:

1. Make sure that the item that will be used in testing is located in stores with PA_STR_RTL.ID_TFS_ZONE as NULL.
2. On the Item Lookup screen search for that item.
3. Press Stock Locator.
4. Note that SIM does not show the results from other stores.


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.