My Oracle Support Banner

MSC_DEMANTRA_F Is Not Being Populated (Doc ID 1391139.1)

Last updated on JULY 01, 2019

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In Advanced Planning Command Center, Reports and Dashboards


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.



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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.