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

 Issue# 29:

While applying main upgrade merged patch

 

ATTENTION: All workers either have failed or are waiting:

 

                   FAILED: file apwuprl1.sql on worker  7.

                   FAILED: file apwuprl1.sql on worker 22.

 

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/ap/12.0.0/patch/115/sql/apwuprl1.sql &un_ap 23 40'

Connected.

 

PL/SQL procedure successfully completed.

 

debug: Adding NOT NULL constraint to AP_EXPENSE_REPORT_LINES_ALL.REPORT_LINE_ID

column

DECLARE

*

ERROR at line 1:

ORA-20001: APP-SQLAP-10000: ORA-14411: The DDL cannot be run concurrently with

other DDLs occurred in

ExpenseReportLineIDNotNull

with parameters (&PARAMETERS)

while performing the following operation:

Adding NOT NULL constraint to AP_EXPENSE_REPORT_LINES_ALL.REPORT_LINE_ID column

ORA-06512: at "APPS.APP_EXCEPTION", line 72

ORA-06512: at line 40

ORA-06512: at line 45

 

 

Solution:

-          Restart the workers one-by-one