My Oracle Support Banner

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 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Apr-2014***


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


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

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