My Oracle Support Banner

BILLING Batch Performance Issues (Doc ID 2533439.1)

Last updated on FEBRUARY 11, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Goal

BILLING batch is taking too long post upgrading to version 2.6.0.1 from 2.3.0.2.

The analysis found that the Post-Processing (Billing) algorithm (C1-GENBSEGPA) plugged on Contract Type is taking a long time to finish its execution. There is a customization in the implementation for Periodic Fee and One-Off Fee (a.k.a Counter Based Products) requirements. Price Assignment Type of ‘Post Processing’ is used for such products. There are approximately 150 such products in the standard price list which is attached to each account in the system. However, counters will be defined for approximately 8-10 products for a given account. Now when bills are generated, the post processing algorithm triggers the processing for all150 products for each account being billed irrespective of whether counter is defined for the product or not for the given account. For restricting post processing algorithm to trigger the processing only for those products for which counter values are defined for a given account, Oracle consulting customized COBOL Program - CIPBSPAX and delivered it. This fixed the performance issue with bill generation for counter based products. Post upgrading to version 2.6.0.1, we stopped using the customized COBOL program and switched to base provided Post-Processing (Billng) algorithm - C1-GENBSEGPA. This algorithm triggers the processing for all products with ‘Post Processing’ price assisgnments irrespective of whether counter is defined for the product or not. 

Prior to Upgrade (on using custom COBOL algorithm with performance tuning changes), BILLING batch was taking 1.5 hours to finish its execution. Post upgrade (on using base provided C1-GENBSEGPA algorithm), BILLING batch is taking 9 hours to finish its execution for the same set of data. Besides, as pointed by Product team we are in process of running the 3 billing batches (C1-PNDBL, C1-BLGEN, C1-BLPPR) for the same data-setup.

Solution

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
Goal
Solution
References


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