My Oracle Support Banner

Refresh Population Incorrectly Updates PROMOTION_MATRIX (Doc ID 1614224.1)

Last updated on JANUARY 28, 2020

Applies to:

Oracle Demantra Predictive Trade Planning - Version 7.3.1 to 7.3.1.4 [Release 7.3.0]
Information in this document applies to any platform.

Symptoms

7.3.1.3 in Production and Test

PROBLEM
-------------
Refresh Population incorrectly updates PROMOTION_MATRIX

The issue occurs when Refresh Population is run on an in-process promotion
(date range of promotion spans history and future) and an item or site needs
to be removed from the promotion. Refresh Population correctly removes the
future rows for the item or site from PROMOTION_DATA and leaves the
historical rows. This is correct since Refresh Population should not change
historical data. The problem is that Refresh Population also removes rows
for the item or site from PROMOTION_MATRIX. That is incorrect. Refresh
Population should not remove a combination from PROMOTION_MATRIX if it still
exists in PROMOTION_DATA. This is causing an out-of-sync condition between
PROMOTION_DATA and PROMOTION_MATRIX at XXX Products.

STEPS
--------
Run Refresh Population

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.