Demantra - Series Configuration Error (Doc ID 2175119.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 7.3.1.5 version, BusModeler

Demantra - Series Configuration Error

Scenario:
1) Created custom general level (with population)
2) Created series on GL_MATRIX table, proportion to itself. {server expression - Sum(nvl(gl_matrix.column,0)) }
3) Updating this series from front end is throwing

Collaborator log reveals error originating from incorrect aliasing of population table (T_POPU_).

Metalink note # 1535772.1 talks about similar issue and an associated bug.

Configuration details are provided in uploaded document: - 'Level n Series Configuration.docx'

 

ERROR
-----------------------
ODPM-10303 error stating system inconsistencies.


STEPS TO REPRODUCE
------------------------------------
1) Created custom general level (with population)
2) Created series on GL_MATRIX table, proportion to itself. {server expression - Sum(nvl(gl_matrix.column,0)) }
3) Updating this series from front end

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update the new series

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