MSC_DEMANTRA_F Is Not Being Populated
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***
In Advanced Planning Command Center 12.1.3 version, 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.
Expect to be able to use the Consensus Forecast information in APCC.
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.
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