PUPL Batch Getting Aborted Due To Dead Lock Issue
(Doc ID 2748690.1)
Last updated on FEBRUARY 09, 2021
Applies to:Oracle Financial Services Revenue Management and Billing - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.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?
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