My Oracle Support Banner

PCM_OP_BILL_SET_LIMIT_AND_CR Throws Error "Customer Is In Transaction" (Doc ID 2731757.1)

Last updated on DECEMBER 08, 2020

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.3.0 and later
Information in this document applies to any platform.

Symptoms

Transaction lock when PCM_OP_BAL_GET_ECE_BALANCES is called with PCM_OP_BILL_SET_LIMIT_AND_CR & PCM_OP_BILL_DEBIT.

The issue can be reproduced at will with the following steps:

Following opcodes are called to replicate the issue in a single transaction:

PCM_TRANS_OPEN_READWRITE
PCM_OP_BILL_SET_LIMIT_AND_CR
PCM_OP_BAL_GET_ECE_BALANCES - Current Bucket
PCM_OP_BILL_DEBIT – Current Bucket
PCM_OP_BILL_SET_LIMIT_AND_CR – Set credit floor Null
PCM_OP_BAL_GET_BALANCES – Future Bucket
PCM_OP_BILL_DEBIT – Future Bucket
PCM_OP_BILL_SET_LIMIT_AND_CR – Set credit floor Zero
PCM_OP_TRANS_COMMIT

The wrapper opcode for updating the credit floor of a resource ID and additionally credits/debits the data balance with delta for few non-currency resource.


- EXPECTED RESULT: Successfully opcode execution without any error or transaction lock.
- ACTUAL RESULT: CustomerInBrmTransactionLock - Customer transaction lock is observed in ECE (Elastic Charge Engine) cache.

Cause

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
Symptoms
Cause
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.