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***
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?
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|