9399877 Matrix Levels Do Not Display Correctly On Demantra 7.3 Worksheet (Doc ID 1104293.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version: 7.2.0.3 and later   [Release: 7.2 and later ]
Information in this document applies to any platform.

Symptoms

 
=== ODM Issue Clarification ===

On : 7.2.0.3 version, Production and Test
PROBLEM
--------
Matrix Levels do not display correctly:
1. While selecting matrix levels (Aggregation User Status, Forecast User Status or Forecast System Status) as aggregation levels or as filters on worksheet, only the first entry in the corresponding level table is displayed.
2. Secondly, the ID field for Forecast System Status and Forecast User Status is #table_name#_code instead of prediction_status and do_fore.

EXPECTED BEHAVIOR
-----------------------
Expect to be able to select as filters on worksheet, any entry in the corresponding aggregation level table
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Business Modeler
2. Right click on any of the matrix levels (Aggregation User Status, Forecast User Status or Forecast System Status).
3. Press Level Members, an ep_tools error is displayed
4. Open Demantra worksheet and select one of the aggregation levels as Forecast System Status
5. Only the first record in pred_status_level table is displayed, which happens to be "Good For Forecast".
 

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