Rating Performance: ifw To Reject EDRs On Lock (Similar To Reject On Deadlock)

(Doc ID 1308850.1)

Last updated on MARCH 29, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 01-OCT-2013***
***Checked for relevance on 29-MAR-2016***

Symptoms

The current locking mechanism used by Discounting in the pipeline rating engine is based on locking the whole balance_group. The lock is maintained for a very short period in order to free the balance_group ASAP. If a balance_group has been locked by the transaction A, a transaction B can lock the same balance_group but, in this case, the transaction B must wait the rollback or commit of the transaction A before to rollback/commit itself.

This mechanism uses dependencies between concurrent transactions. In order to decrease the number of dependencies between concurrent transactions, the FCT_Discount should be able to ignore the EDRs with a balance_group already locked by another transaction and continue processing the EDR file (similar to IgnoreEDROnDeadlock).

 

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