BIV_B_AGE_H_SUM_MW.XDF Failing With ORA-54015 When Merge Patches 9179588, 9477107 (Doc ID 1273554.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Applications DBA - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Checked for relevance on 25-SEP-2013

Symptoms

On 12.1.3 version, Business Intelligence (OLTP), after upgrading the database to 11.2.0.2 from 10.2.0.4 and applying merge patches, 9179588, 9477107, 7461070 the patch fails in both biv_b_age_h_sum_mw.xdf with ora-54015 in patch 6678700 the failure did not occur when upgrade was previously performed with 11.2.0.1 database:

CREATE MATERIALIZED VIEW "APPS"."BIV_B_AGE_H_SUM_MV"

Start time for statement above is Wed Nov 03 14:28:00 CDT 2010
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


The issue can be reproduced with the following steps:

1. Upgrade the database to 11.2.0.2
2. Apply patches 9179588, 9477107, 7461070
3. Errors appear.



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