Error - ORA-54015 : biv_b_age_h_sum_mv.xdf Failes with Duplicate Column Expression was Specified (Doc ID 1322144.1)

Last updated on MAY 07, 2014

Applies to:

Oracle Applications DBA - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Service Intelligence - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 22-Oct-2013***

Symptoms

Problem Statement:
When attempting to upgrade Oracle Application version 11.5.10.2 to 12.1.1 using upgrade driver u6678700.drv ( Issue is specific to Database Version 11.2.0.2 only), the following error occurs.

Error:
CREATE MATERIALIZED VIEW "APPS"."BIV_B_AGE_H_SUM_MV"

Exception occured ORA-54015: Duplicate column expression was specified
ORA-06512: at "APPS.AD_MV", line 131
ORA-06512: at "APPS.AD_MV", line 289
ORA-06512: at line 1

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

Steps to Reproduce :
The issue can be reproduced at will with the following steps:
1. Upgrade database version to 11.2.0.2.
2. Apply R12.1.1 Upgrade driver Patch (<Patch 6678700>) on Oracle Application Version 11.5.10.2/ Database Version 11.2.0.2

Changes

Database version has been upgraded to 11.2.0.2 before applying Oracle Application upgrade driver R12.1.1 patch.

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