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

 Issue# 28:

While applying main upgrade merged patch

 

ATTENTION: All workers either have failed or are waiting:

 

                   FAILED: file wfdspifx.sql on worker  7.

 

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/fnd/12.0.0/patch/115/sql/wfdspifx.sql '

Connected.

 

PL/SQL procedure successfully completed.

 

DECLARE

*

ERROR at line 1:

ORA-29496: Parameter [TASK_NAME] is null or its value length exceeds the

maximum limit [128]

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE_INTERNAL", line 69

ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE_INTERNAL", line 80

ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE_INTERNAL", line 185

ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 98

ORA-06512: at line 90

 

 

Solution:

Wfdspifx.sql Fails With ORA-29496 During 12.2 Upgrade (Doc ID 1610924.1)

 

SQL> SELECT value

FROM v$parameter

WHERE name = 'job_queue_processes';  2    3 

 

VALUE

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

2

 

SQL>

 

 

sqlplus "/ as sysdba"

 

SQL> BEGIN

DBMS_SQLTUNE.SET_AUTO_TUNING_TASK_PARAMETER(parameter => 'TIME_LIMIT', value => '7200');

END;

/

  2    3    4 

PL/SQL procedure successfully completed.

 

SQL>

 

-          Restart the failed worker, but it failed again

 

Applied another workaround as per wfdspifx.sql Performance Problem While EBS 12.2 Upgrade (Doc ID 2007306.1)

[apdpro@r12upgdb ~]$ ident $FND_TOP/patch/115/sql/wfdspifx.sql

/oracle/12.2/DPRO/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/wfdspifx.sql:

     $Header: wfdspifx.sql 120.3.12020000.4 2015/04/27 08:51:17 nsanika ship $

[apdpro@r12upgdb ~]$

[apdpro@r12upgdb ~]$ mv $FND_TOP/patch/115/sql/wfdspifx.sql $FND_TOP/patch/115/sql/wfdspifx.sql_org

[apdpro@r12upgdb ~]$ cp -p /oracle/12.2/DPRO/fs1/EBSapps/appl/admin/DPRO/log/20655260/fnd/patch/115/sql/wfdspifx.sql $FND_TOP/patch/115/sql/

[apdpro@r12upgdb ~]$

[apdpro@r12upgdb ~]$ ident $FND_TOP/patch/115/sql/wfdspifx.sql

/oracle/12.2/DPRO/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/wfdspifx.sql:

     $Header: wfdspifx.sql 120.3.12020000.3 2014/10/22 09:36:20 skandepu ship $

[apdpro@r12upgdb ~]$

 

-          The file version is now downgraded!

-          Restart the failed worker again