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

 Issue# 32:

While running 12.2.6 patch

ATTENTION: All workers either have failed or are waiting:

 

                   FAILED: file OE_ORDERORG_GTT.sql on worker  1.

                   FAILED: file OE_SCHEDULE_LINES_TEMP.sql on worker  2.

 

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/ont/12.0.0/patch/115/sql/OE_ORDERORG_GTT.sql &un_ont'

Connected.

 

PL/SQL procedure successfully completed.

 

DECLARE

*

ERROR at line 1:

ORA-01403: no data found

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

ORA-06512: at line 33

 

 

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/ont/12.0.0/patch/115/sql/OE_SCHEDULE_LINES_TEMP.sql &un_ont'

Connected.

 

PL/SQL procedure successfully completed.

 

DECLARE

*

ERROR at line 1:

ORA-01403: no data found

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

ORA-06512: at line 33

 

Solution:

SQL> conn apps/apps

Connected.

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>