My Oracle Support Banner

Simple_promo_retail Gets Updated on RPM_FUTURE_RETAIL for Excluded Item when Price Guide Is Applied (Doc ID 2256423.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


When a simple promotion is created with price guide and a item is excluded.
The excluded item on a simple promo has the column Simple_promo_ind as 0 but the simple promo retail is updated with price guide value in RPM_FUTURE_RETAIL (RFR) table.

Steps to reproduce:

  1. Create a new price guide.
  2. Create merchandise level simple promo.
  3. Create exclusion for transaction level item. Approve the promotion.
  4. Verify the RFR record for the excluded item in the promotion.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.