My Oracle Support Banner

Improving Invoicing and Billing Performance in BRM Production System (Doc ID 1598559.1)

Last updated on MAY 03, 2021

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Purpose

The user is currently facing a performance problem in BRM (7.4 PS12) invoicing process, here is the discussion for improving Invoicing and Billing performance in BRM production system.

In the architecture, BRM Billing & Invoicing process runs on Monthly basis and pin_inv_accts is called internally for generating invoices and it gets triggered when pin_bill_day gets triggered. Prelim (Trial) invoicing runs 4-5 times in a month, and most of the times trial invoicing runs between 20th of the month to 1st of the month. Actual Billing & invoicing mostly runs on 3rd of every month.

Performance issue - Currently, BRM system generates more than 11,000 invoices, but it takes more 8 hours for generating these many invoices. This is the case with prelim Invoicing and actual Invoicing.

Here are the pin.conf configuration:

      pin_inv/pin.conf and pin_billd/pin.conf are with the default values:

 

Questions and Answers

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
Purpose
Questions and Answers
 Please provide the best possible configuration parameters which will help in improving invoicing performance.
 From the AWR report, looks like all data is reading from PARTITION_LAST,  and nothing being inserted in PARTITION_LAST_PIN and PARTITION_LAST. How to move the old data to these partitions ?
 How to track BRM Invoicing performance and hanging issues?
 How to resolve the problematic queries from the AWR report ?
 How to tune the IFW Sync Queue which is presumably doing a lot of scanning?
References


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