Price Changes Are in 'Executed' Status Although There Are No Future Retail Record in RPM_FUTURE_RETAIL. Why? (Doc ID 1569844.1)

Last updated on JUNE 14, 2016

Applies to:

Oracle Retail Price Management - Version 13.2.5 and later
Information in this document applies to any platform.
Checked for relevance on 14-June-2016

Goal

 Price changes are in executed status although there are no future retail records in RPM_FUTURE_RETAIL table.  Why?

Steps:
  • Create an item in Oracle Retail Merchandising System (RMS) and range it to locations (do not run newitemloc so that the item is in RMS but not in RPM).
  • Create a price change at zone level through the price injector (emergency price change).
  • The price change is in executed status although there are no records in RPM_FUTURE_RETAIL table.
  • Although the price change is in executed status, the price in RPM or RMS is not updated.

Solution

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