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

Last updated on SEPTEMBER 13, 2019

Applies to:

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).

Changes

Cause

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