Data Seeding Script Does Not Populate WAREHOUSE_ITEM Table in SIM (Doc ID 1931654.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

In Oracle Retail Store Inventory Management (SIM) 14.0.x, after the data seeding process is completed, the WAREHOUSE_ITEM table is not populated with data.

When data is picked from Retail Merchandising System (RMS), the script picks up only those items which are ranged to physical warehouses.  However, since RMS is running in multi-channel mode, items are only ranged to virtual warehouses; hence, the script creates a warehouse_item.dat file with 0 items.   This prevents users from performing operations involving the physical warehouse in SIM, such as returns.


Steps to Reproduce:

  1. Install SIM database.
  2. Run data Seeding scripts to populate the SIM database.
  3. Check WAREHOUSE_ITEM table and note that it is not populated, whereas in RMS items are ranged to virtual warehouses.

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