My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.4.0]
Information in this document applies to any platform.


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.


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

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