Unexpected Free Resources Behaviour After Product Cancellation (Doc ID 888998.1)

Last updated on JULY 02, 2012

Applies to:

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

Symptoms

Problem Statement

The user purchased a rating product on 1st of the Month (March 2009), which include free resources. The sub-balance bucket shows current month bucket with full quantity, and next month bucket also with the full quantity.

Then, the product is canceled in the middle of the billing cycle (15th March 2009).

In BRM 7.3.1, the unexpected behaviour is as below:
The current month (1 March - 1 April) bucket is reset to 0.
The next month (1 April - 1 May) bucket remains as it is (valid_to is also not impacted)

 

nap(11476)> robj - $DB /balance_group 3440700
# number of field entries allocated 20, used 14
0 PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 3440700 7
0 PIN_FLD_CREATED_T TSTAMP [0] (1235845854) Sun Mar 01 00:00:54 2009
0 PIN_FLD_MOD_T TSTAMP [0] (1237055418) Sun Mar 15 00:00:18 2009
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 3443164 0
0 PIN_FLD_BATCH_CNTR INT [0] 0
0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 3441628 0
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1235845853) Sun Mar 01 00:00:53 2009
0 PIN_FLD_NAME STR [0] "Balance Group<Account>"
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_REALTIME_CNTR INT [0] 6
0 PIN_FLD_BALANCES ARRAY [840] allocated 20, used 4
1 PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1 PIN_FLD_CREDIT_PROFILE INT [0] 0
1 PIN_FLD_NEXT_BAL DECIMAL [0] 0
1 PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
0 PIN_FLD_BALANCES ARRAY [1000095] allocated 20, used 7
1 PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
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 [2] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] "0.0.0.1 /rate 3245511"
2 PIN_FLD_CURRENT_BAL DECIMAL [0] 0 <<<<<------ current bucket not updated
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 3439039 1
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1235845891) Sun Mar 01 00:01:31 2009
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1238524200) Wed Apr 01 00:00:00 2009
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] "0.0.0.1 /rate 3245511"
2 PIN_FLD_CURRENT_BAL DECIMAL [0] 0
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PI N_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 3439039 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 0
2 PIN_FLD_VALID_FROM TSTAMP [0] (1235845891) Sun Mar 01 00:01:31 2009
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
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] "0.0.0.1 /rate 3245511"
2 PIN_FLD_CURRENT_BAL DECIMAL [0] -104857600
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 3439039 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_VALID_FROM TSTAMP [0] (1238524200) Wed Apr 01 00:00:00 2009
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_VALID_TO TSTAMP [0] (1241116200) Fri May 01 00:00:00 2009
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0

Business Impact

Late usage for the current month will be charged.
Usage for the next month is still have valid bucket to be used.

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