My Oracle Support Banner

PUPL Batch Getting Aborted Due To Dead Lock Issue (Doc ID 2748690.1)

Last updated on DECEMBER 12, 2023

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.7.0.1.0 and later
Information in this document applies to any platform.

Goal

On : 2.7.0.1.0 version, BT - Batch

PUPL batch getting aborted due to a dead lock issue.

Below is the update statement which was contending for the same data sets which resulted in the lock:


UPDATE CI_TNDR_CTL SET TNDR_CTL_ST_FLG = :1 , BALANCED_USER_ID = :2 , BALANCED_DTTM = :3 WHERE TNDR_CTL_ST_FLG <> :4 AND TNDR_CTL_ID IN ( SELECT TNDRCTLST.TNDR_CTL_ID FROM CI_TNDR_CTL_ST TNDRCTLST WHERE TNDRCTLST.TND_CTL_STG_ST_FLG IN (:5 , :6 ) AND NOT EXISTS ( SELECT 'X' FROM CI_PAY_TNDR_ST TNDRST WHERE TNDRST.EXT_SOURCE_ID = TNDRCTLST.EXT_SOURCE_ID AND TNDRST.EXT_TRANSMIT_ID = TNDRCTLST.EXT_TRANSMIT_ID

How can this issue be resolved?
 

Solution

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.