Not Able to Cancel Component from Existing Promotion: ORA-32638: "Non Unique Addressing" Error (Doc ID 1352138.1)

Last updated on JANUARY 07, 2015

Applies to:

Oracle Retail Price Management - Version 13.1.3 and later
Information in this document applies to any platform.
Checked for relevance on 06-Aug-2013

Symptoms

Following error is received when canceling the active component of existing promotion.

ERROR:

PACKAGE_ERROR@1ORA-32638: Non unique addressing in MODEL dimensions@2RPM_ROLL_FORWARD_SQL.RPM_RF_CLEARANCE_CARRIER



Steps to Recreate:

1) Create Promotion event.
2) Create Promotion with start and end date as event, and add two components with this promotion.
3) Change the vdate.
4) Create another Promotion event.
5) Create another Promotion with start and end date as event, and add two components with this promotion.
      Note: Component must contain same above items and prices.
6) Try to cancel first component; error occurs.

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