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 NOVEMBER 14, 2017

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
Checked for relevance on 15-Nov-2017


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

  • 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.


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