Cannot Regenerate Materialized View BIV_B_AGE_H_SUM_MV (Doc ID 1333691.1)

Last updated on SEPTEMBER 11, 2014

Applies to:

Oracle Service Intelligence - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
checked for relevance on 02-SEP-2013

Symptoms

Error occurring when applying Patch 5404886: E-Business Intelligence Family Pack 11i.BIS_PF.G:

java.sql.SQLException: ORA-54015: Duplicate column expression was specified
ORA-06512: at "APPS.AD_MV", line 124
ORA-06512: at "APPS.AD_MV", line 258
ORA-06512: at line 1

Materialized View Name is BIV_B_AGE_H_SUM_MV
Materialized View does not exist in the target database

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