Invalid Sub_bal Records Created As Part Of Rerating. (Doc ID 782663.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 to 7.2.1.0.0 [Release 7.2.1]
Information in this document applies to any platform.
Checked for relevance on 24-Oct-2012.

Symptoms

Pipeline created invalid SUB_BAL records as part of rerating.

Steps To Reproduce:

  1. Create an account with standard GSM plan on Dec 12 00:00:44 2008
  2. Purchase the GSM telephony deal once again which creates one more sub-bal bucket on Dec 12 00:02:13 2008
  3. Do Some usage (e.g. 300 secs) with start date as Dec 12 00:10:00 2008
  4. Cancel deal #2 (which we purchased on step 2) say on Dec 13 00:14:30 2008, so sub_bal validity is updated accordingly.
  5. Do batch rerating ( Extract events for the account, and use backout/rerating Pipeline to rerate the events)
robj - 0.0.0.1 /balance_group 2733248
# number of field entries allocated 20, used 13
0 PIN_FLD_POID           POID [0] 0.0.0.1 /balance_group 2733248 12
0 PIN_FLD_CREATED_T    TSTAMP [0] (1229068844) Fri Dec 12 00:00:44 2008
0 PIN_FLD_MOD_T        TSTAMP [0] (1229156071) Sat Dec 13 00:14:31 2008
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 2735424 0
0 PIN_FLD_BATCH_CNTR      INT [0] 0
0 PIN_FLD_BILLINFO_OBJ   POID [0] 0.0.0.1 /billinfo 2733888 0
0 PIN_FLD_EFFECTIVE_T  TSTAMP [0] (1229068844) Fri Dec 12 00:00:44 2008
0 PIN_FLD_NAME            STR [0] "Balance Group<Account>"
0 PIN_FLD_REALTIME_CNTR    INT [0] 4
0 PIN_FLD_BALANCES      ARRAY [978] allocated 20, used 4
1     PIN_FLD_CREDIT_PROFILE    INT [0] 0
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 7
2         PIN_FLD_CONTRIBUTOR_STR    STR [0] ""
2         PIN_FLD_CURRENT_BAL  DECIMAL [0] 92.274
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] (1229068844) Fri Dec 12 00:00:44 2008
2         PIN_FLD_VALID_TO     TSTAMP [0] (0) <null>
0 PIN_FLD_BALANCES      ARRAY [1000095] allocated 20, used 6
1     PIN_FLD_CREDIT_PROFILE    INT [0] 2
1     PIN_FLD_NEXT_BAL     DECIMAL [0] 0
1     PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
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] -117.1
2         PIN_FLD_DELAYED_BAL  DECIMAL [0] 0
2         PIN_FLD_NEXT_BAL     DECIMAL [0] 0
2         PIN_FLD_ROLLOVER_DATA    INT [0] 1073807360
2         PIN_FLD_VALID_FROM   TSTAMP [0] (1229068933) Fri Dec 12 00:02:13 2008
2         PIN_FLD_VALID_TO     TSTAMP [0] (1229156070) Sat Dec 13 00:14:30 2008
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] -3117
2         PIN_FLD_DELAYED_BAL  DECIMAL [0] 0
2         PIN_FLD_NEXT_BAL     DECIMAL [0] 0
2         PIN_FLD_ROLLOVER_DATA    INT [0] 1073807360
2         PIN_FLD_VALID_FROM   TSTAMP [0] (1229068844) Fri Dec 12 00:00:44 2008
2         PIN_FLD_VALID_TO     TSTAMP [0] (1231747200) Mon Jan 12 00:00:00 2009
1     PIN_FLD_SUB_BALANCES  ARRAY [0] 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] (2117491200) Thu Feb 05 16:00:00 2037
2         PIN_FLD_VALID_TO     TSTAMP [0] (2117491200) Thu Feb 05 16:00:00 2037
nap(1067)>

After batch rerating, here, for free resource [1000095] there is a zero balance bucket with invalid dates (i.e. contains year 2037) being created and also amount for this resource is not correct.

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