2 Replies Latest reply: Aug 28, 2012 2:53 PM by Hussein Sawwan-Oracle RSS

    FUNUPGACT.SQL hangs During Upgrade To R12.1.1(6678700)

    user11969717
      FUNUPGACT.SQ has been running for long time...Have tried restarting the workers,bounced the database
      still it hangs at:

      SQL> /
      Enter value for sid: 355
      old 1: select username, sql_text from v$sqlarea, v$session where hash_value = sql_hash_value and sid=&sid
      new 1: select username, sql_text from v$sqlarea, v$session where hash_value = sql_hash_value and sid=355

      USERNAME SQL_TEXT
      ------------------------------ --------------------------------------------------------------------------------
      APPS INSERT INTO FUN_BALANCE_OPTIONS VALUES (:B1 ,:B2 ,:B3 ,:B4 ,:B5 ,:B6 ,:B7 ,:B8 ,
      :B9 ,:B10 ,:B11 ,:B12 ,:B13 ,:B14 ,:B15 ,:B16 ,:B17 ,:B18 ,:B19 ,:B20 ,:B21 ,:B2
      2 ,:B23 ,:B24 ,:B25 ,:B26 ,:B27 ,:B28 ,:B29 ,:B30 ,:B31 ,:B32 )


      SQL>


      kill -9 26935378




      USERNAME SQL_TEXT
      ------------------------------ --------------------------------------------------------------------------------
      APPS select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, '
      N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIV
      E, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, S
      EGMENT6, SEGMENT7, SEGMENT8, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOW
      ED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS whe
      re CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 =
      :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMEN
      T5 = :FND_BIND6) and (SEGMENT6 = :FND_BIND7) and (SEGMENT7 = :FND_BIND8) and (SE
      GMENT8 = :FND_BIND9)




      applp@testerp $ adident Header /u03/oracle/CRP1PROD/apps/apps_st/appl/fun/12.0.0/patch/115/sql/funupgact.sql
      /u03/oracle/CRP1PROD/apps/apps_st/appl/fun/12.0.0/patch/115/sql/funupgact.sql:
      $Header funupgact.sql 120.13 2007/11/22 12:41:51 srampure ship $
      applp@testerp $


      Regards,
      Aman