Deleted Status Not Updated in RK_PRICE_CHANGE Table When Promotion Component Details Are Modified in RPM

(Doc ID 1918531.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 13.2.6 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.


In Oracle Retail Store Inventory Management (SIM) 13.2.x, when a price change or promotion is modified and then re-approved in Retail Price Management (RPM), the status in the RK_PRICE_CHANGE table remains as '9-Deleted'.

Steps to Reproduce:

  1. Create a price change in RPM and approve it.
  2. Maintain the promotion in RPM and change the status to 'Worksheet'.  This will send a RegPrcChgDel message to SIM that will change the status in RK_PRICE_CHANGE to 9-Deleted. 
  3. Maintain the promotion in RPM and make some changes, then re-approve. This will send a RegPrcChgCre message that modifies the price in RK_PRICE_CHANGE with the modification performed in this step, but the status will remain as 9 Deleted.


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