[Ora-00060: Deadlock Detected] Errors When Running Allocations From Oracle Performance Analyzer (PA) 4.5 (Doc ID 277970.1)

Last updated on JANUARY 07, 2013

Applies to:

Oracle Profitability Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Profitability Manager - Version: 4.5
Oracle Performance Analyzer - Version: 4.5
This problem can occur on any platform.

Checked for relevance on 06-Dec-2012.

Symptoms

An error ORA-00060: deadlock is detected while waiting for resource while running a single Allocation ID.
From the ofspa.XXXXX error log file a similar error is received:

OCI Function: [4] - oexec(), oexn()
SQL Function: [5] - UPDATE
Oracle Error: ORA-00060: deadlock detected while waiting for resource

Driver Function: drv_oci::Execute()

SQL Statement: update FEM_CHECKING set identity_code_chg = :identity_code_chg,
PAA_STRATEGIC_PLANNING_EXP = DECODE(identity_code_chg,1711,PAA_STRATEGIC_PLANNING_EXP,0)+DECODE
(ISO_CURRENCY_CD,'-1', 1, 'AED', 1/1.021075, 'ATS', 1/0.332668, 'AUD', 1/2.68875, 'BEF',
1/0.113476, 'BHD', 1/9.947477, 'CAD', 1/2.754517, 'CHF', 1/2.992817, 'DEM', 1/2.340532, 'DKK',
1/0.615289, 'EGP', 1/0.606747, 'ESP', 1/0.027512, 'EUR', 1/4.577625, 'FRF', 1/0.698168, 'GBP',
1/6.886125, 'GLK', 1/47649.36375, 'IDR', 1/0.000405, 'INR', 1/0.08249, 'IQD', 1/0.002572, 'IRG',
1, 'IRR', 1/0.000437, 'ITA', 1/0.002364, 'JOD', 1/5.29661, 'JPY', 1/0.034366, 'KES', 1/0.047337,
'KGC', 1/350.362875, 'KRW', 1/0.002853, 'KWD', 1/12.724805, 'LBP', 1/0.002477, 'MAD', 1/0.417149,
'MRO', 1/0.018689, 'MYR', 1/0.986972, 'NLG', 1/2.077217, 'OMR', 1/9.741525, 'OZ1', 1/47.649375,
'OZ2', 1/238.246875, 'OZ3', 1/4764.936375, 'OZ4', 1/476.49375, 'OZ5', 1/952.987125, 'OZ7',
1/119.12325, 'OZ8', 1/2382.468375, 'PKR', 1/0.065617, 'QAR', 1/1.030163, 'RFS', 1/18.75825, 'RSS',
1/8.566875, 'SAG', 1/350.362875, 'SCP', 1, 'SEK', 1/0.503248, 'SEN', 1/0.006989, 'SGD',
1/2.209522, 'SLV', 1/928.2735, 'SP1', 1/2779.10175, 'SP2', 1/5558.203125, 'SYP', 1/0.072576,
'TRL', 1/0.000004, 'TZS', 1/0.005629, 'USD', 1/3.75, 'XAG', 1/25.125, 'XAH', 1/741.09375, 'XAU',
1/1482.1875, 'XPT', 1/3221.25, 'YER', 1/0.020358, 'ZAR', 1/0.577803, 1) *
:PAA_STRATEGIC_PLANNING_EXP where FEM_CHECKING.IDENTITY_CODE = :IDENTITY_CODE and
FEM_CHECKING.ID_NUMBER = :ID_NUMBER
Error: (20005) Internal Error.
See table OFSA_MESSAGE_LOG for more details. Job Number: 13539
Error: (20006) Internal Error Continued.
See table OFSA_MESSAGE_LOG for more details. Job Number: 13539
Error: (20006) Internal Error Continued.
See table OFSA_MESSAGE_LOG for more details. Job Number: 13539
Error: (20006) Internal Error Continued.
See table OFSA_MESSAGE_LOG for more details. Job Number: 13539
Error: (20006) Internal Error Continued.
See table OFSA_MESSAGE_LOG for more details. Job Number: 13539
Error: (20006) Internal Error Continued.
See table OFSA_MESSAGE_LOG for more details. Job Number: 13539
Error(Oracle Financial Services Application error) (203055) Error
Bound Parameters:
:identity_code_chg = 1711
:PAA_STRATEGIC_PLANNING_EXP = 0.211613287725912
:IDENTITY_CODE = 2004053110
:ID_NUMBER = 101190000010006080043149 SQL statement.
Error: (20005) Internal Error.

Changes

Upgraded from RDBMS 8.1.7.4 to 9.2.0.5
Upgraded from OFSA 4.5.36 to 4.5.39

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms