My Oracle Support Banner

ECE Transaction Locks are not Cleared Even After TransactionLockCleanupInterval (Doc ID 2960481.1)

Last updated on OCTOBER 02, 2023

Applies to:

Oracle Communications BRM - Elastic Charging Engine - Version and later
Information in this document applies to any platform.


 In an active-active setup, the following parameters have been enabled post commit feature on Billing and Revenue Manager (BRM) & Elastic Charging Engine (ECE).

 Randomly the locks are not cleared, which leads to any other operation on the account is not allowed.

The following error can be seen on CustomerUpdater log:

SELECT COUNT(*) num_categories FROM ece_site_category_t) sc) c WHERE c.site_category = and c.rn=1)
java.sql.SQLSyntaxErrorException: ORA-918: column ambiguously defined

    at oracle.jdbc.driver.T4CTTIoer11.processError(
    at oracle.jdbc.driver.T4CTTIoer11.processError(
    at oracle.jdbc.driver.T4C8Oall.processError(
    at oracle.jdbc.driver.T4CTTIfun.receive(
    at oracle.jdbc.driver.T4CTTIfun.doRPC(
    at oracle.jdbc.driver.T4C8Oall.doOALL(


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

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