This discussion is archived
2 Replies Latest reply: Aug 28, 2012 12:53 PM by Hussein Sawwan-Oracle RSS

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

user11969717 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points