No Data In APCC Fact Tables MSC_DEMANTRA_F and MSC_DEMANTRA_ODS_F (Doc ID 2065354.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

We ran the concurrent program Refresh APCC Materialized views and also ran Publish APCC-DM Measures workflow which completed without errors. But when we validate the data in msc_demantra_f and msc_demantra_ods_f, both tables do not have any data. How do we get data in these tables?
 

Solution

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