u6678700.drv: FAILED: file biv_b_age_h_sum_mv.xdf

Action plan to avoid biv_b_age_h_sum_mv.xdf issue

Issue:

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

Reference:

-Error - ORA-54015 : biv_b_age_h_sum_mv.xdf Failes with Duplicate Column Expression was Specified [ID 1322144.1]
-Patch 10163753: APPSST11202: BIV_B_AGE_H_SUM_MV FAILS DURING INDEX CREATION

Solution:

Perform below steps on admin and form node

In the case the Upgrade itself could not be stopped, copy the file biv_b_age_h_sum_mv.xdf from Patch 10163753 into the filesystem Directory (after you have backed up the original file)

cp $BIV_TOP/patch/115/xdf/biv_b_age_h_sum_mv.xdf $BIV_TOP/patch/115/xdf/biv_b_age_h_sum_mv.xdf.org                

then

cp [PATCH_DIR]/biv_b_age_h_sum_mv.xdf $BIV_TOP/patch/115/xdf

Restart the failed Worker using the adctrl utility in a second Shell session and continue.