Questions On Promotion Matrix Table And Sync_gl_matrix Procedure After Upgrading To 7.3

(Doc ID 1231524.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 7.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Dec-2013***

Goal

  We need guidance from PMO for regarding the questions below:
1)We have observed that for some promotions, the promotion_matrix.until_date is set as equal to from_date instead of being the same as promotion_dates.until_date. Is this an error in the procedure run to populate promotion_matrix or intended?
2)Need Guidelines for population of promotion_matrix
3)We see that promotion_matrix includes _lud columns for all promotion levels. Do we need to ensure these are populated by any custom procedures that update other promotion levels?
4)We see that mdp_matrix includes _lud columns for all item and location levels. 5)Do we need to ensure these get populated if any custom procedures are updating level tables?
How do we manage the table promotion_matrix. How often should the sync_gl_matrix procedure be run, what are other options?


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