My Oracle Support Banner

How Is SIMPLE_PROMO_RETAIL in RPM_FUTURE_RETAIL Table Calculated When We Have Overlapping Promotions? (Doc ID 1535941.1)

Last updated on AUGUST 17, 2020

Applies to:

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


Why SIMPLE_PROMO_RETAIL in RPM_FUTURE_RETAIL table, is not as per expected when we have overlapping promotions?

Below is an example:

1. Create a promotion with 2 components for 1 item/Location as below (Item retail is 12$):
  COMP1: Starts 21-Feb and ends 27-Feb with 10% off.
  COMP2: Starts 23-Feb and ends 24-Feb with 2 $ off.
2. Create a new promotion for same item/location with below component:
  COMP21: Starts 22-Feb and ends 25-Feb with 20% off.

Expected behavior:

- If the promo change type 1st is set to amount off in system options.
Apply amount off first to be 12-2=10 then apply percentage off to be 10*10%=9 then 9*20%=7.2

- If promo change type 1st is set to percentage off in system options.
Apply percentage off first to be 12*10%=10.8 then 10.8*20%=8.64 then amount 2 off to be 6.64

Actual Behavior now:

a. Apply 10 % off on 12 $ = 10.8
b. Apply 2$ off on 10.8 $ = 8.8
c. Apply 20% off on 8.8 $ = 7.04


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.