My Oracle Support Banner

'STOCK_COUNT_ADHOC_CONFIG' Table Data Not Pre-populated For Stores via Dataseeding process (Doc ID 2457992.1)

Last updated on MARCH 18, 2020

Applies to:

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

Symptoms

In Retail Store Inventory Management (RSIM) , 'STOCK_COUNT_ADHOC_CONFIG' table is not seeded with any records during data seeding.

Expected Result
During data seeding for existing stores, this table needs to be populated for each store with 2 records for every distinct DEPARTMENT_ID and CLASS_ID where CLASS_ID is not null on item_hierarchy.
Each STORE_ID and distinct DEPARTMENT_ID and CLASS_ID should contain a Quantity_Variance = 0 , Percent_Variance = 0 and two records should be created ; one record with TOPIC = 0, the second record with topic = 1

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