Multiple Sub-Balance Buckets Created For Currency and Non-Currency Resource (Doc ID 884918.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 02-Aug-2011
*** Checked for relevance on 05-June-2013 ***

Symptoms

-- Problem Statement:

Multiple sub-balance bucket created for currency and non-currency resources. If the balance impact is zero a new sub-balance bucket is created.

How to reproduce:

1. Create a product with $0 balance impact on Monthly Cycle Forward.
2. Create a deal with this product.
3. Create an account with this deal.
4. Run billing for couple of months.

Observation:

Every month a new sub-balance bucket is getting created.

Expected:

No new sub-balance should be created.

Example:


robj /balance_group    

# number of field entries allocated 22, used 22
0 PIN_FLD_POID           POID [0] 0.0.0.1 /balance_group 868520732093 15
0 PIN_FLD_CREATED_T    TSTAMP [0] (1072969200) Thu Jan 01 10:00:00 2004
0 PIN_FLD_MOD_T        TSTAMP [0] (1080795600) Thu Apr 01 00:00:00 2004
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 868520731325 0
0 PIN_FLD_BATCH_CNTR      INT [0] 0
0 PIN_FLD_BILLINFO_OBJ   POID [0] 0.0.0.1 /billinfo 868520734397 0
0 PIN_FLD_EFFECTIVE_T  TSTAMP [0] (1072969200) Thu Jan 01 10:00:00 2004
0 PIN_FLD_NAME            STR [0] "bal_misc"
0 PIN_FLD_REALTIME_CNTR    INT [0] 8
0 PIN_FLD_BALANCES      ARRAY [840] allocated 20, used 7
1     PIN_FLD_CREDIT_PROFILE    INT [0] 3
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 7
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_NEXT_BAL     DECIMAL [0] 0
2         PIN_FLD_ROLLOVER_DATA    INT [0] 0
2         PIN_FLD_VALID_FROM   TSTAMP [0] (1072933200) Thu Jan 01 00:00:00 2004
2         PIN_FLD_VALID_TO     TSTAMP [0] (0) <null>
1     PIN_FLD_SUB_BALANCES  ARRAY [4] allocated 20, used 7
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_NEXT_BAL     DECIMAL [0] 0
2         PIN_FLD_ROLLOVER_DATA    INT [0] 0
2         PIN_FLD_VALID_FROM   TSTAMP [0] (1075611600) Sun Feb 01 00:00:00 2004
2         PIN_FLD_VALID_TO     TSTAMP [0] (0) <null>
1     PIN_FLD_SUB_BALANCES  ARRAY [6] allocated 20, used 7
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_NEXT_BAL     DECIMAL [0] 0
2         PIN_FLD_ROLLOVER_DATA    INT [0] 0
2         PIN_FLD_VALID_FROM   TSTAMP [0] (1078117200) Mon Mar 01 00:00:00 2004
2         PIN_FLD_VALID_TO     TSTAMP [0] (0) <null>
1     PIN_FLD_SUB_BALANCES  ARRAY [8] allocated 20, used 7
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_NEXT_BAL     DECIMAL [0] 0
2         PIN_FLD_ROLLOVER_DATA    INT [0] 0
2         PIN_FLD_VALID_FROM   TSTAMP [0] (1080795600) Thu Apr 01 00:00:00 2004
2         PIN_FLD_VALID_TO     TSTAMP [0] (0) <null>
0 PIN_FLD_BALANCES      ARRAY [100002] allocated 20, used 3
1     PIN_FLD_CREDIT_PROFILE    INT [0] 5
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
0 PIN_FLD_BALANCES      ARRAY [1000002] allocated 20, used 3
1     PIN_FLD_CREDIT_PROFILE    INT [0] 6
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
0 PIN_FLD_BALANCES      ARRAY [1000003] allocated 20, used 3
1     PIN_FLD_CREDIT_PROFILE    INT [0] 6
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
0 PIN_FLD_BALANCES      ARRAY [1000004] allocated 20, used 3
1     PIN_FLD_CREDIT_PROFILE    INT [0] 6
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
0 PIN_FLD_BALANCES      ARRAY [1000006] allocated 20, used 3
1     PIN_FLD_CREDIT_PROFILE    INT [0] 6
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
0 PIN_FLD_BALANCES      ARRAY [1000007] allocated 20, used 3
1     PIN_FLD_CREDIT_PROFILE    INT [0] 6
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
0 PIN_FLD_BALANCES      ARRAY [1000008] allocated 20, used 3
1     PIN_FLD_CREDIT_PROFILE    INT [0] 6
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
0 PIN_FLD_BALANCES      ARRAY [1000009] allocated 20, used 3
1     PIN_FLD_CREDIT_PROFILE    INT [0] 6
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
0 PIN_FLD_BALANCES      ARRAY [1000010] allocated 20, used 3
1     PIN_FLD_CREDIT_PROFILE    INT [0] 6
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
0 PIN_FLD_BALANCES      ARRAY [1000301] allocated 20, used 3
1     PIN_FLD_CREDIT_PROFILE    INT [0] 6
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 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