Refresh Population Incorrectly Updates PROMOTION_MATRIX (Doc ID 1614224.1)

Last updated on JUNE 28, 2017

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 Rich Products.

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

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