Free Resource On The Advance Billing Period(Next Month) Is Reset To 0, When We Cancel Bundle (Doc ID 1311576.1)

Last updated on OCTOBER 10, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms


For Bundle (Free Resources) Product, when we cancel a product with WHEN_T = next month (for example : 21th next month)
The bundle will be reset to 0 (for duration 01st-next month to 21th-next month)

This behavior is not the same as in BRM 7.3.1, while in BRM  7.3.1, the bundle is not reset to 0, after product cancellation.

The bundle will remain as 0, and only after Billing process in the next month, the bundle will be reset to the original amount.

The business impact :
Usages between 1st next month, and Billing process next month, will not be discounted, while in BRM 7.3.1 is discounted properly.



Steps to replicate

1) Create an account on Aug 10

2) ran set_prod_info with cycle_end_t set to September 22nd

Sample Flist

CM input flist: opcode PCM_OP_SUBSCRIPTION_SET_PRODINFO, opflags=0x0
# number of field entries allocated 20, used 4
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 5484752 14
0 PIN_FLD_PRODUCTS ARRAY [0] allocated 20, used 5
1 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 5486286 1
1 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 5485520 1
1 PIN_FLD_PURCHASE_END_T TSTAMP [0] (1285093907) Wed Sep 22 00:01:47 2010
1 PIN_FLD_CYCLE_END_T TSTAMP [0] (1285093907) Wed Sep 22 00:01:47 2010
1 PIN_FLD_USAGE_END_T TSTAMP [0] (1285093907) Wed Sep 22 00:01:47 2010
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/ip 5488080 0
0 PIN_FLD_PROGRAM_NAME STR [0] "test"



read bal_group

 

nap(25841)> robj - 0.0.0.1 /balance_group 5488336
 # number of field entries allocated 20, used 14
 0 PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 5488336 7
 0 PIN_FLD_CREATED_T TSTAMP [0] (1281378702) Tue Aug 10 00:01:42 2010
 0 PIN_FLD_MOD_T TSTAMP [0] (1281381300) Tue Aug 10 00:45:00 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 5484752 0
 0 PIN_FLD_BATCH_CNTR INT [0] 0
 0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 5487824 0
 0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1281378700) Tue Aug 10 00:01:40 2010
 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] 4
 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 6
 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] ""
 2 PIN_FLD_CURRENT_BAL DECIMAL [0] -50
 2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
 2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 5485520 1
 2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
 2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
 2 PIN_FLD_VALID_FROM TSTAMP [0] (1281378600) Tue Aug 10 00:00:00  2010
 2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
 2 PIN_FLD_VALID_TO TSTAMP [0] (1283279400) Wed Sep 01 00:00:00  2010
 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 -------->in 7.3.1 it was -50
 2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
 2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 5485520  1
 2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
 2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
 2 PIN_FLD_VALID_FROM TSTAMP [0] (1283279400) Wed Sep 01 00:00:00  2010
 2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0  2 PIN_FLD_VALID_TO TSTAMP [0] (1285093800) Wed Sep 22 00:00:00  2010
 2 PIN_FLD_VALID_TO_DETAILS INT [0] 0



 in 7.3.1 the second sub bal was not zero

 3) run pin_cycle_fee October 1st

 4) Ran billing on October 3rd

 Balance Group


 nap(26375)> robj - 0.0.0.1 /balance_group 5488336
 # number of field entries allocated 20, used 14
 0 PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 5488336 8
 0 PIN_FLD_CREATED_T TSTAMP [0] (1281378702) Tue Aug 10 00:01:42 2010
 0 PIN_FLD_MOD_T TSTAMP [0] (1283452360) Fri Sep 03 00:02:40 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 5484752 0
 0 PIN_FLD_BATCH_CNTR INT [0] 0
 0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 5487824 0
 0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1281378700) Tue Aug 10 00:01:40 2010
 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] 4
 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 6
 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
  2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
 2 PIN_FLD_CURRENT_BAL DECIMAL [0] -50
 2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
 2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 5485520  1
 2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
 2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
 2 PIN_FLD_VALID_FROM TSTAMP [0] (1281378600) Tue Aug 10 00:00:00 2010
 2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
 2 PIN_FLD_VALID_TO TSTAMP [0] (1283279400) Wed Sep 01 00:00:00 2010
 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] -50
 2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
 2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 5485520 3
 2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
 2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
 2 PIN_FLD_VALID_FROM TSTAMP [0] (1283279400) Wed Sep 01 00:00:00 2010
 2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
 2 PIN_FLD_VALID_TO TSTAMP [0] (1285093800) Wed Sep 22 00:00:00 2010
 2 PIN_FLD_VALID_TO_DETAILS INT [0] 0




Here after billing the sub bal is changing

 The impact here is between 1st Oct to 3rd Oct ,free resources are not getting discounted because of this

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