ORA-12015: cannot create a fast refresh materialized view fro m a complex query error when installing Patch (Doc ID 1320766.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demand Signal Repository - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Observe the following error when we install <Patch 6679700>

FAILED: file DDR_R_BASE_DAY_DN_MV.xdf on worker 1.
FAILED: file DDR_BS_FRCST_VRSN_MV.xdf on worker 2.
FAILED: file DDR_R_BSNS_QTR_DN_MV.xdf on worker 3.
FAILED: file DDR_BS_INV_SKU_BU_DAY_MV.xdf on worker 4.


Start time for statement above is Tue Apr 26 13:39:25 PDT 2011
Exception occurred ORA-12015: cannot create a fast refresh materialized view fro
m a complex query
ORA-06512: at "APPS.AD_MV", line 131
ORA-06512: at "APPS.AD_MV", line 289
ORA-06512: at line 1

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