Pin_cmt - Bal_grp_bals_t Not Populated By Pin_cmt Tool In Case Of An Existing Balance. (Doc ID 1626354.1)

Last updated on FEBRUARY 26, 2014

Applies to:

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

Symptoms

bal_grp_bals_t is not populated by pin_cmt tool in case of an existing balance.

When migrating the balances/subbalances via the pin_cmt application, the tool does not create the bal_grp_bals_t object in case there is already some entry for the particular balance_group. This causes inconsistency between three tables: bal_grp_t -> bal_grp_bals_t -> bal_grp_sub_bals_t.

The infranet.cmt.deleteExistingBalances is set to false, so there is a scenario when some balances already exist under the particular balance_group.

Test Case
=========
1. Load the account via CMT tool (there are no balances/sub balances at this point)
2. Load balance, sub balance with resource_id = x (correspoding bal_grp_bals_t and bal_grp_sub_bals_t are created successfully)
3. Load balance, sub balance with resource_id = y (only the bal_grp_sub_bals_t is created - the bal_grp_bals_t dat file for sql loader is empty)

Cause

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