My Oracle Support Banner

Understanding NewItemLocationBatch.sh in RPM Version 19 (Doc ID 2813210.1)

Last updated on OCTOBER 14, 2021

Applies to:

Oracle Retail Pricing - Version 19.0 and later
Information in this document applies to any platform.

Goal



Does NEWITEMLOCATIONBATCH.SH (NIL) insert data into RPM_FUTURE_RETAIL only and not RPM_ITEM_LOC?

When you create a three-level Item in Oracle® Retail Merchandising System (RMS), i.e., STYLE, SKU, and UPC, and range it to a store location, you notice only transaction-level item, i.e., SKU level, is directly is inserted into RPM_ITEM_LOC. Thus, an entry is made into the RPM_ITEM_LOC_WS table.

When you execute the NIL batch, it will populate the RPM_FUTURE_TABLE table.

Please let us know if this understanding is correct?

If this is correct, then for the data migration exercise where you seed data into the MOM, you should directly insert data into RPM_ITEM_LOC and RPM_ITEM_LOC_WS and run the NIL batch to populate RPM_FUTURE_RETAIL?
 

Solution

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