BRM: Slow Billing Performance Caused By PROC_DEFER_CYCLE_TAX_ACCT
Last updated on JUNE 18, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 28-Jan-2014***
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.
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