RPM_ITEM_ZONE_PRICE (RIZP) Not Updated Correctly for Standard Retail (Doc ID 2173037.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Retail Merchandising System - Version 15.0 and later
Oracle Retail Price Management - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

RPM_ITEM_ZONE_PRICE (RIZP) is not updated correctly for Standard Retail.


Steps to Recreate:

  1. Create a style item through XItemDesc script.
  2. Add retail by zone location in XIZPDesc rec for style.
  3. Create a SKU through XItemDesc script for the above style.
  4. Add retail by zone location in XIZPDesc rec as $100 for SKU.
  5. Create another SKU through XItemDesc script.
  6. Add retail by zone location in XIZPDesc rec as $80 for SKU.
  7. Notice that the second SKU has an incorrect value for standard retail in RPM_ITEM_ZONE_PRICE table.

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