ORA-02049 Timeout: Distributed Transaction Waiting For Lock In Package QP_Delayed_Requests_UTIL Pro (Doc ID 1495269.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Apr-2014***

Symptoms

When interfacing funds between Siebel and Oracle Trade Management, we are getting some successful funds and others which are failing with the message : ORA-02049: timeout: distributed transaction waiting for lock in Package QP_Delayed_Requests_UTIL Procedure Update_Pricing_Phase. We interfaced 55 funds at one time and 44 of the 55 were successful, but 11 of funds failed out with the timeout issue.

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