All Unlinked Combinations Are Not Removed From Mdp_matrix

(Doc ID 1407945.1)

Last updated on APRIL 28, 2014

Applies to:

Oracle Demantra Demand Management - Version 7.3.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Apr-2014***

Goal


Customer states that they are trying to clean the mdp_matrix table for the combinations removed from the sales_data table.  They have removed 1 month history from the sales_data table.  They have then set the

Mdp_AddDeleteUnlinkedMdp_Matrix = 'TRUE' (Default value is FALSE).

Then they run the ep_load.  When combinations from sales_data table are removed, it is expected that all those unlinked combinations should be removed from mdp_matrix as well after ep_load.  After ep_load, though a majority of them are removed, there are still small portions left.

Steps to Reproduce
1. Set Mdp_AddDeleteUnlinkedMdp_Matrix = 'TRUE'
2. Remove 1 month history from sales_data table
3. Run ep_load_main


Solution

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