10 Replies Latest reply: Aug 27, 2012 1:57 AM by Hussein Sawwan-Oracle RSS

    During R12 upgrade adworker for patch u6678700.drv fails for afopp002.sql

    user11969717
      Hi Experts,


      During R12.1.1 upgrade from 11.5.10.2 adworker for patch u6678700.drv fails for afopp002.sql

      The exact error being faced is
      sqlplus -s APPS/***** @/u03/oracle/CRP1PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/afopp002.sql &un_fnd &pw_fnd
      Connected.
      declare
      *
      ERROR at line 1:
      ORA-20000: Oracle Error Mkr1= -24018 - ORA-24018: STOP_QUEUE on
      APPLSYS.FND_CP_GSM_OPP_AQ failed, outstanding transactions found
      ORA-06512: at line 15

      I even tried restarting the worker,bounced the database and even tried running u03/oracle/CRP1PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/afopp002.sql manually which hangs for indefinitely.

      Any suggestion.