My Oracle Support Banner

Logic in BAL_GRP_T_MAPPING_TABLE_T.SQL Script Sets REALTIME_CNTR To 0 During BRM Upgrade From 6.5 To 7.3 (Doc ID 786734.1)

Last updated on MARCH 05, 2019

Applies to:

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


During BRM upgrade from 6.5 to 7.3, the logic in the BAL_GRP_T_MAPPING_TABLE_T.SQL script sets REALTIME_CNTR to 0. REALTIME_CNTR should be set to the max rec_id of the corresponding sub-balances.

The source of the problem is that the REALTIME_CNTR is not aligned with the maximum rec_id of the sub-balances. If REALTIME_CNTR is left set to 0, it is possible that existing sub-balances are overwritten. For example, if a resouce's sub-balance has index 2 before the upgrade. During the upgrade the REALTIME_CNTR is set to 0.  So after the upgrade during billing when a new sub-balance is created, it will have index 2 (rec_id = REALTIME_CNTR+2) which will overwrite the existing sub-balance with index 2.





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

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