Multiple Currency BAL_GRP_SUB_BALS_T Records For An Account (Doc ID 1073358.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.1 to 7.3.1.0.1 [Release 7.3.1]
Information in this document applies to any platform.
**Checked for relevance on 25th Feb 2012**
***Checked for relevance on 28-Jul-2014***


Symptoms

After upgrade of the system from 6.2SP1 to 7.3.1, many accounts get multiple currency sub balance records after they are billed.  In older version many custom reports were designed around account_balances_t table which has of course been replaced with the balance_group object. The old  relation was one to one for the currency resource and now with multiple entries the reports shows multiple records. The problem only shows up after billing for migrated accounts.

The product in Pricing Plan doesn't have G(rantor) flag.

Sample /balance_group object:

0 PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 961965504 8
0 PIN_FLD_CREATED_T TSTAMP [0] (959054400) Tue May 23 00:00:00 2000
0 PIN_FLD_MOD_T TSTAMP [0] (1265149765) Tue Feb 02 17:29:25 2010
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 142334 1527
0 PIN_FLD_BATCH_CNTR INT [0] 0
0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 961490055 0
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1262412516) Sat Jan 02 01:08:36 2010
0 PIN_FLD_NAME STR [0] "default"
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_REALTIME_CNTR INT [0] 6
0 PIN_FLD_BALANCES ARRAY [124] allocated 20, used 8
1    PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1    PIN_FLD_CREDIT_PROFILE INT [0] 6
1    PIN_FLD_NEXT_BAL DECIMAL [0] 0
1    PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1    PIN_FLD_SUB_BALANCES ARRAY [0] allocated 20, used 10
2       PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2       PIN_FLD_CURRENT_BAL DECIMAL [0] 0
2       PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2       PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.0 0 0
2       PIN_FLD_NEXT_BAL DECIMAL [0] 0
2       PIN_FLD_ROLLOVER_DATA INT [0] 0
2       PIN_FLD_VALID_FROM TSTAMP [0] (959054400) Tue May 23 00:00:00 2000
2       PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2       PIN_FLD_VALID_TO TSTAMP [0] (0)
2       PIN_FLD_VALID_TO_DETAILS INT [0] 0
1    PIN_FLD_SUB_BALANCES ARRAY [2] allocated 20, used 10
2       PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2       PIN_FLD_CURRENT_BAL DECIMAL [0] 0
2       PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2       PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 964038653 0
2       PIN_FLD_NEXT_BAL DECIMAL [0] 0
2       PIN_FLD_ROLLOVER_DATA INT [0] 0
2       PIN_FLD_VALID_FROM TSTAMP [0] (1265000400) Mon Feb 01 00:00:00 2010
2       PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2       PIN_FLD_VALID_TO TSTAMP [0] (0)
2       PIN_FLD_VALID_TO_DETAILS INT [0] 0
1    PIN_FLD_SUB_BALANCES ARRAY [4] allocated 20, used 10
2       PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2       PIN_FLD_CURRENT_BAL DECIMAL [0] 0
2       PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2       PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 963829418 0
2       PIN_FLD_NEXT_BAL DECIMAL [0] 0
2       PIN_FLD_ROLLOVER_DATA INT [0] 0
2       PIN_FLD_VALID_FROM TSTAMP [0] (1265000400) Mon Feb 01 00:00:00 2010
2       PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2       PIN_FLD_VALID_TO TSTAMP [0] (0)
2       PIN_FLD_VALID_TO_DETAILS INT [0] 0
1    PIN_FLD_SUB_BALANCES ARRAY [6] allocated 20, used 10
2       PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2       PIN_FLD_CURRENT_BAL DECIMAL [0] 0
2       PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2       PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 964037278 0
2       PIN_FLD_NEXT_BAL DECIMAL [0] 0
2       PIN_FLD_ROLLOVER_DATA INT [0] 0
2       PIN_FLD_VALID_FROM TSTAMP [0] (1265000400) Mon Feb 01 00:00:00 2010
2       PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2       PIN_FLD_VALID_TO TSTAMP [0] (0)
2       PIN_FLD_VALID_TO_DETAILS INT [0] 0
0 PIN_FLD_BALANCES ARRAY [1000001] allocated 20, used 5
1    PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1    PIN_FLD_CREDIT_PROFILE INT [0] 13
1    PIN_FLD_NEXT_BAL DECIMAL [0] 0
1    PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1    PIN_FLD_SUB_BALANCES ARRAY [2] allocated 20, used 10
2       PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2       PIN_FLD_CURRENT_BAL DECIMAL [0] -5
2       PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2       PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.0 0 0
2       PIN_FLD_NEXT_BAL DECIMAL [0] 0
2       PIN_FLD_ROLLOVER_DATA INT [0] 0
2       PIN_FLD_VALID_FROM TSTAMP [0] (959054400) Tue May 23 00:00:00 2000
2       PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2       PIN_FLD_VALID_TO TSTAMP [0] (0)
2       PIN_FLD_VALID_TO_DETAILS INT [0] 0
0 PIN_FLD_BALANCES ARRAY [2000002] allocated 20, used 5
1    PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1    PIN_FLD_CREDIT_PROFILE INT [0] 9
1    PIN_FLD_NEXT_BAL DECIMAL [0] 0
1    PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1    PIN_FLD_SUB_BALANCES ARRAY [2] allocated 20, used 10
2       PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2       PIN_FLD_CURRENT_BAL DECIMAL [0] 3
2       PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2       PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.0 0 0
2       PIN_FLD_NEXT_BAL DECIMAL [0] 0
2       PIN_FLD_ROLLOVER_DATA INT [0] 0
2       PIN_FLD_VALID_FROM TSTAMP [0] (959054400) Tue May 23 00:00:00 2000
2       PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2       PIN_FLD_VALID_TO TSTAMP [0] (0)
2       PIN_FLD_VALID_TO_DETAILS INT [0]




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