Archiving And Purging Rows In BAL_GRP_BALS_T Which Have No Sub Balances in BAL_GRP_SUB_BALS_T
Last updated on MARCH 24, 2014
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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:
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?
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