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

Last updated on MAY 03, 2021

Applies to:

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

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