BRM: Slow Billing Performance Caused By PROC_DEFER_CYCLE_TAX_ACCT (Doc ID 1461839.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 28-Jan-2014***

Symptoms

It was detected that in the middle of the billing process, pin_bill_acct invokes the PROC_DEFER_CYCLE_TAX_ACCT database procedure which invokes the trigger named TRIG_CYCLE_DEFERRED_TAX. That trigger causes the load on the database and makes the billing process very slow (generating 30 bills per minutes and overload of the database processing).

When turning off the PROC_DEFER_CYCLE_TAX_ACCT procedure, the rate is of 300 bills per minutes and the level of processing of the database is lower at 30%.
It seems that this store procedure consumes all resources of the database becoming too slow in the process of billing.

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