New Perfomance Flag Option to Skip Balance Group Lock during Invoicing (Doc ID 2166893.1)

Last updated on APRIL 03, 2023

Applies to:

Goal

During invoicing,  the balance groups are locked for the particular bill for which invoice is generated because duplicate invoices are generated when multiple pin_inv_accts applications are running. There may be other inconsistencies in picking up events due to not locking when other operations are updating the bill, and any backdating operations depending on when the invoicing is run.

When invoicing is run along with rating or other applications, due to the balance group locking in invoicing the other process like rating is getting DEAD_LOCK causing delay in rating.

In order to skip locking balance groups during regular invoicing, a new bitmap performance flag is introduced INV_PERF_FEAT_SKIP_BALGRP_LOCK 0x00010000
Default is 0 - means locking during invoicing. When set to 1, it will skip locking during invoicing.

During corrective invoicing and trial billing, still lock balance groups irrespective of whether the performance bit INV_PERF_FEAT_SKIP_BALGRP_LOCK is set or not.

To set not locking with this new flag, change the entry in CM pin.conf as below:

1. cm/pin.conf entry

#========================================================================
# inv_perf_features
#
# This entry is required to retain the balance_impact array in an event
#
# Default Value is 0x00000010
#========================================================================
- fm_inv inv_perf_features 0x00000010

change the value to the following

- fm_inv inv_perf_features 0x00010010

2. Restart CM

3. Run invoicing

Solution

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