Billing Performance Issues - Item Trigger Sql Tuning (Doc ID 1143184.1)

Last updated on AUGUST 06, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.1 to 7.0.0.0.1 [Release 7.0.0]
Information in this document applies to any platform.
Checked for relevance on 17-Jan-2012.
***Checked for relevance on 03-Dec-2013***
Checked for relevance on 06-Aug-2015.

Symptoms

We have subordinate accounts which will not be updated by billing as they are not due for billing; hence, they will have a last_bill_obj_id0 of 0. However, these child accounts will still be looked at by the item trigger when they should not be, as they have not billed.

This is causing the billing performance issue at the customer end. Having said that, the issue is still dependent on the data distribution at the customer.

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