Problem :

Upgrade patch u6678700.drv fails executing jai_cond_ren_col.sql

Error :

sqlplus -s APPS/***** <Path to the $APPL_TOP>/ja/12.0.0/patch/115/sql/jai_cond_ren_col.sql &un_ja &un_fnd
DECLARE
*
ERROR at line 1:
ORA-00903: invalid table name
ORA-06512: at “SYSTEM.AD_DDL”, line 165
ORA-06512: at line 107

Solution :

Open a new Shell, source the APPS Environment and execute following script located under

$APPL_TOP/ja/12.0.0/patch/115/SQL
sqlplus apps/&lt;Password&gt; @jai_cond_ren_col.SQL ja fnd

Once the script runs successfully, use the hidden option 8 of the Utility ‘adctrl’ to skip the failed worker.

Tagged with →  
Share →
0 comments
Skip to toolbar