Promotion Ended for an Item, but Future Retail Still Indicates Item on Promotion

(Doc ID 2174177.1)

Last updated on AUGUST 22, 2016

Applies to:

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


When attempting to make a price change for an item after ending the item's promotion early, the following error occurs:

Steps to Reproduce:

  1. Put an item on promotion from vdate+1 to vdate+22 for $139.99.
  2. End the promo for the item via the RPM UI on vdate+5.
  3. Look for item in FUTURE_RETAIL.  Look at column 'on_simple_promo_ind' to see if it is '0' or '1'.
  4. Attempt a price change to $59.99 with effective date of vdate+6. The price change should have a conflict if FUTURE_RETAIL.on_simple_promo_ind = '1'.




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