MSC_DEMANTRA_F Is Not Being Populated (Doc ID 1391139.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 04-JUN-2013***

Symptoms

In Advanced Planning Command Center 12.1.3 version, Reports and Dashboards

ACTUAL BEHAVIOR  
---------------
We need to use the fact "Forecasting.Consensus Forecast", but we cannot see any information in that field.  We checked the source table, MSC_DEMANTRA_F, and cannot see any information.  We have active plans from ASCP and DEMANTRA, but neither of them fills this fact.

We have data in MSC_DEMANTRA_ODS_F and have worked with facts of MSC_DEMANTRA_ODS_F with no problems.

The Export OBI Data runs well and we do not get any error messages when it runs.

EXPECTED BEHAVIOR
-----------------------
Expect to be able to use the Consensus Forecast information in APCC.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

(1)  In Oracle BI Answers on the Criteria Tab, select the "Plan" and "Forecasting (Consensus Forecast)" columns
(2)  Click on "Results" tab, No Results returned.

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