Archiving And Purging Rows In BAL_GRP_BALS_T Which Have No Sub Balances in BAL_GRP_SUB_BALS_T (Doc ID 1635467.1)

Last updated on MARCH 24, 2014

Applies to:

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

Goal

The user is planning to Archive and Purge rows in BAL_GRP_BALS_T which have no sub balances in BAL_GRP_SUB_BALS_T (only for non-currency resources: rec_id > 1000).

The Documents states the following with respect to purging of BAL_GRP_BALS_T:

Customer should not be purging from bal_grp_bals_t, only from the bal_grp_sub_bals_t. It is OK to purge those SUB_BALANCES that have expired because they are no longer needed. However, the BALANCES are for resources that were configured in pricing, and deleting them will break the data integrity of the system.
For example, if an account is using a price plan that contains both Euro and FreeMinutes, the system expects to find the BALANCES for both in the /balance_group. The BALANCES are only created when the balance group is created as per the pricing information, and will not attempt to re-create it whenever it finds it is not there.

Is it recommended to purging from bal_grp_bals_t and what is the probable issue which might arise because of the Data NON-integrity caused by purging the Balances?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms