INVALIDPOPULATIONEXCEPTION ERROR IN REFRESH POPULATION WORKFLOW DEMANTRA 7.3 (Doc ID 988128.1)

Last updated on SEPTEMBER 08, 2016

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 08-Nov-2013***


Goal

Q1:
Receiving error - "ODPM-10192: Refresh Population Process Encountered 1 Errors" when running RefreshPopulation directly from Workflow.
The error appears to be related to combinations in the promotion that do not exist in mdp_matrix - the error is correct, but I don't know whether the logic is correct.

Q2:

I may be missing something here, but if I do the following sql, no combinations are returned:

select count(*) from promotion_data where (item_id,location_id) not in (select distinct item_id,location_id from mdp_matrix);



What script should I try to find out which promotions have got invalid filter populations that is causing this particular refresh population error ?

Q3:

I created a seperate workflow that just calls RefreshPopulation and ran that. Without a date defined in the REFRESH_FROM_DATE parameter in the step, nothing happened. If I put a date in the parameter - in this case the same as max_sales_date ( and we have promotions in the future to this date), then we saw changes to PROMOTION_DATA and PROMOTION_MATRIX on the promotions we were testing. Why does the step only work if you enter a date ( if we're running this weekly, how do we update that date automatically..?)

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