Warning/Error When Creating New Promotion Or When Using Duplicate Promotion (Doc ID 1963842.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 7.3.1.4 and later
Information in this document applies to any platform.

Symptoms

On : 7.3.1.4 version, PTP-Gen

When attempting to Duplicate promotion method or when creating new promotion,
the following error occurs.

ERROR
-----------------------
ORA-00001: unique constraint (DEMANTRA.PROMOTION_LEVELS_127_PK) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In worksheet, promotion level, right click
2. new promotion or Duplicate promotion method.
The issue does not exist all the time. Today the issue was there for more than 4 hours and suddenly started working fine. So this is highly inconsistent.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Customer is in the food business. So promotional activities are extremely critical for their operations. So this has got a very high impact. Raised this SR now as Sev 2 but a potential escalation to Sev1.

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