ORA-12015: cannot create a fast refresh materialized view fro m a complex query error when installing Patch
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.
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
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