My Oracle Support Banner

ItemLoc_Fnd Importer Job Not Filtering Non StockHolding Store Locations (Doc ID 2867278.1)

Last updated on MAY 04, 2022

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

 When the Item Location imported job runs during the BDI ItemLoc_Fnd_SubProcessFlow_From_RMS_To_SIM process flow, the SIOCS database is populated with the records for non stock holding stores as well in the tables below:

select store_id from store_item where store_id not in (select id from store)  group by store_id;
select store_id from item_price where store_id not in (select id from store) group by store_id;

EXPECTED BEHAVIOR
-----------------------
Expect that these records are not populated in the SIOCS DB from the ITEM_LOC_IN table.

Steps to Reproduce:

Prerequisites: MFCS has the stores 1982, 8903, 8901, 8902 as non-stock holding locations (example).

1. Initiate the ItemLoc_Fnd process flow to start data seeding from MFCS to SIOCS
2. After the process completes, query the following tables:

select store_id from store_item where store_id not in (select id from store)  group by store_id;
select store_id from item_price where store_id not in (select id from store) group by store_id;

Data is available for stores 1982, 8903, 8901, 8902.

Changes

 

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!


In this Document
Symptoms
Changes
Cause
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.