How Is SIMPLE_PROMO_RETAIL in RPM_FUTURE_RETAIL Table Calculated When We Have Overlapping Promotions?
Last updated on AUGUST 17, 2016
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.
- 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
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