SUBSET ENGINE Fails With Exception - ORA-00904: "MDP_MATRIX"."POPULATION": invalid identifier (Doc ID 2195747.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.5.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5.1 version, Engine

When attempting to run demantra engine in subset mode,
the following error occurs.

ERROR
-----------------------
02:32:48:457 DYN_INSERT_UNITS_BRANCH_ID Procedure Started for branch
02:32:48:470 ERROR ---------------------------------------------------------------
02:32:48:571 ERROR DB_OracleCommand::Execute threw an exception. Error: 904 ORA-00904: "MDP_MATRIX"."POPULATION": invalid identifier
ORA-06512: at "DEMANTRA.DYN_INSERT_UNITS_BRANCH_ID", line 357
ORA-06512: at line 1

02:32:48:672 ERROR SQL :BEGIN dyn_insert_units_branch_id(:1); END;
02:32:48:773 ERROR ---------------------------------------------------------------
02:32:48:874 WARNING DYN_INSERT_UNITS_BRANCH_ID procedure failed for branch: 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Business Modeler.
2. Navigate to Parameters > System Parameters > Engine > New > Create a Subset Forecast.
3. Run engine for this new engine profile.
4. It fails.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run engine in Subset mode. This is causing delay in engine run as it is not allowing to filter the combinations to be consider by engine.

Cause

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