All Unlinked Combinations Are Not Removed From Mdp_matrix
Last updated on APRIL 28, 2014
Applies to:Oracle Demantra Demand Management - Version 22.214.171.124 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
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