Error While Attempting To Cancel A Duplicated Component For Complex Promotions While Allowing Multiple Active Customer Segment Promotions (Doc ID 1313136.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

RPM is allowing multiple active customer segment promotions and when attempting to cancel one of the duplicated components the following error occurs.

Error :

com.retek.platform.exception.RetekUnknownSystemException: @0PACKAGE_ERROR@1ORA-32638: Non unique addressing in MODEL dimensions@2RPM_ROLL_FORWARD_SQL.RPM_RF_CS_PROMO_UOM_CARRIER



Steps To Recreate:

1 . Create a promo event with start date equals to today
2 . Create a promo with start date equals to today with two components that are exactly as the below
--Start date equals to today, Component type is Multi Buy
--Both Components having the same Zone and Customer type
--Buy list : Quantity 3 (use the same item)
--Create a reward type = Fixed Price and apply reward to each buy list
--Approve both components
--Both components are in "Active status"
3 . Go to Promotion maintenance and select the first component. Select Action > Cancel and Update it.

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