Simple_promo_retail Gets Updated on RPM_FUTURE_RETAIL for Excluded Item when Price Guide Is Applied

(Doc ID 2256423.1)

Last updated on APRIL 19, 2017

Applies to:

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

Symptoms

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.

 

Changes

 

Cause

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