My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.0]
Information in this document applies to any platform.

Symptoms

After upgrade of the system from 6.2PS1 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 Grantor (G) 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]




Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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