My Oracle Support Banner

Zone Level Price Change Updating RMS Item/loc Price Even Status Is "Delete" But SIM, POS Not Updated (Doc ID 2780847.1)

Last updated on JUNE 07, 2021

Applies to:

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


When a Zone level price change is created in Retail Price Management (RPM), it is updating ITEM_LOC and PRICE_HIST tables in RMS even for the item-loc combination with "Delete" status. This will cause issues when re-activating the item-loc combination leading to non syncing of prices between RMS/Xstore and SIM.

Steps to Recreate:

  1. Item / loc consumed in RPM from RMS in active status via NIL batch. Records processed in SIM item_price table via RIB.
  2. Here, all system RMS, RPM, SIM are in sync with 1500 price. Prices are updated in Xstore correctly via feed.
  3. Created an emergency PC (location level , location : 11002) for that item - RMS, RPM, SIM, POS updated.
  4. Now, update Item loc status as "delete" from RMS. SIM item_loc status updated as Deleted via RIB.
  5. Now, Execute batch in RPM. all records related to that item/loc is deleted from RPM_ITEM_LOC/ RFR, RPM_PRICE_CHANGE.
  6. Now, create a location level (11002) price change for this deleted item/loc in RPM - RPM UI restricts telling item/location doesn't exist (EXPECTED).
  7. Now, create a Zone level emergency price change for that item (where location 11002 also exists) - PC gets executed in RPM without any error prompt. Price get updated in RMS item_loc , price_hist even fior that deleted item/location (11002) combination.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.