Deleted Status Not Updated in RK_PRICE_CHANGE Table When Promotion Component Details Are Modified in RPM
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:
- Create a price change in RPM and approve it.
- 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.
- 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