Billing Performance Degraded After the Upgrade to BRM 12.0 PS6 (Doc ID 2998283.1)

Last updated on FEBRUARY 19, 2024

Applies to:

Symptoms

After migrating from Billing and Revenue Manager 12.0 PatchSet 3 (BRM 12.0 PS3) to BRM 12.0 PS6, one has seen a billing performance issue while billing accounts with large number of purchases ( ~ 15K).
E.G: An account with 14K purchases takes around 4 hours to bill in PS3 environment, whereas the same account took around 9 hours after the upgrade to PS6.

Changes

 1.) During product rating op_bill_get_limit was being called which read the whole balance group and processed it, there was no need to process all sub balances which caused performance hit, now modified it to read necessary sub-balances only and process it. Its a performance fix available in latest patchsets. (PS7 and above)

2.) When a product has multiple rate_plans then product will be rated in calc_only mode to identify the appropriate rate_plan then the actual rating happens with appropriate rate_plan. Now avoided discounts processing in calc_only mode as product rating is enough to identify the rate_plan.

3.) When billing is run cycle_forward will be called first with defer mode and then with normal mode. During defer mode product was being rated in calc_only mode even though the product was not eligible to be rated. The product was skipped from rating after calc_only rating. Now moved the condition check to before calc_only rating which avoid the calc_only rating if the product is not eligible to be rated at all.

4.) Optimised get_purchased_offerrings() call to return the results quickly. Identified the bottleneck areas in get_purchased_offerrings() and fixed it.

5.) Reduced couple of unnecessary get_purchased_offerrings() call which added to the performance improvement.

Cause

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