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 MAY 10, 2019
Applies to:Oracle Demand Signal Repository - Version 12.1.1 and later
Information in this document applies to any platform.
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
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