How to Diagnose an ORA-00060 Deadlock Detected Error for an OFSA Process

(Doc ID 458199.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5

Goal

How can you determine what is triggering an "ORA-00060: deadlock detected while waiting for resource" error during an Oracle Financial Services Applications (OFSA) 4.5 process?  OFSA 4.5 processes include Allocation IDs, Risk Manager Process IDs, and Transfer Pricing Process IDs.

Solution

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