Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 23:

 

While running AD 12.2 merged patch 10117518_CUP7

ATTENTION: All workers either have failed or are waiting:

 

           FAILED: file adctxpkg.sql on worker  1.

 

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

 

Worker log:

sqlplus -s APPS/***** @/oracle/12.2/DPRO/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/oracle/12.2/DPRO/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adctxpkg.sql &systempwd CTXSYS &un_apps'

Connected.

         

PL/SQL procedure successfully completed.

         

Connected.

       

PL/SQL procedure successfully completed.

            

declare

*

ERROR at line 1:

ORA-01403: no data found

ORA-06512: at "SYSTEM.AD_DDL", line 2150

ORA-06512: at line 215

   

 

 

Solution:

SQL> select install_group_num from apps.fnd_oracle_userid where oracle_username ='APPS';

 

INSTALL_GROUP_NUM

-----------------

                                0

 

SQL> update fnd_oracle_userid set install_group_num=1 where oracle_username = 'APPS';

 

1 row updated.

 

SQL> commit;

 

Commit complete.

 

SQL>