RPM_ITEM_ZONE_PRICE (RIZP) Not Updated Correctly for Standard Retail
(Doc ID 2173037.1)
Last updated on NOVEMBER 02, 2020
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.
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.
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