Performance Degradation When Discounting A Balance Group With Many Sub-Balances

(Doc ID 558526.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
Information in this document applies to any platform.
***Checked for relevance on 20-May-2010***


Symptoms

Pipeline performance degrades when using FCT_Discount and FCT_ApplyBalance, consuming free usage from exactly one of a set of mutually exclusive sub-balances (i.e., no two sub-balances cover the same validity period).

For example, 4 SMS messages are rated which creates 4 sub-balances.

With fewer sub-balances, rating performs well. As the number of sub-balances in the balance group increases, the processing time increases linearly leading to performance lag.

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