Incorrect Rollover Amount After Change Bundle (Doc ID 2900050.1)

Last updated on NOVEMBER 23, 2022

Applies to:

Symptoms

Issue is that the rollover amount is incorrect after changing bundle in the below scenario.

Scenario:

1. Created account with grant of 5000MB
2. Triggered Sygy for consumption of 200MB and session is terminated (remaining amount 4800MB)
3. Changed bundle
4. New bundle grant is 4800MB (5000MB-200MB)
5. Move to billing date and perform billing, rollover bucket is created
6. Actual Result: The rollover bucket has 9600MB
7. Expected result: The rollover bucket should contain 4800MB (remaining allowance from previous bucket)

Steps:

1. In pricing design center (pdc):
   - create a charge offer with:
   - monthly cycle forward event, credit free seconds, 5242880000, validity 1 cycle, proration = charge FULL
   - rollover event, max rollover cycles = 1, max rollover per cycle = 5242880000, max cumulative rollover= 5242880000
   - Proration:
   When purchased mid-cycle Full Charge
   When cancelled mid-cycle Full Charge
   - create a bundle with above charge offer
   
   
2. 6 July: create account with some package (that contains any usage charge offer), purchase the above bundle
   
   
3. call PCM_OP_BILL_DEBIT to reduce balance.. to simulate usage
   
   0 PIN_FLD_POID POID [0] 0.0.0.1 /account 4291010
   0 PIN_FLD_PROGRAM_NAME STR [0] "test"
   0 PIN_FLD_DESCR STR [0] "Non Currency Resource testing"
   0 PIN_FLD_DEBIT ARRAY [1000095] allocated 20, used 1
   1 PIN_FLD_BAL_OPERAND DECIMAL [0] 209715200
    
4. check balance bucket:
   1000095
   06-JUL-22 12:30:00 - 01-AUG-22 12:30:00
   -5033164800
   
   
5. cancel bundle from billing care or use below flist
   
   PCM_OP_SUBSCRIPTION_CANCEL_DEAL input flist
   # number of field entries allocated 20, used 4
   0 PIN_FLD_POID POID [0] 0.0.0.1 /account 4290541 0
   0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/telephony 4289821 13
   0 PIN_FLD_PROGRAM_NAME STR [0] "Update credit floor"
   0 PIN_FLD_DEAL_INFO SUBSTRUCT [0] allocated 20, used 2
   1 PIN_FLD_DEAL_OBJ POID [0] 0.0.0.1 /deal 4286850 2
   1 PIN_FLD_PACKAGE_ID INT [0] 102
   
   
6. check balance bucket:
   1000095
   06-JUL-22 12:30:00 - 07-JUL-22 00:32:53
   -5033164800
   
   
7. purchase same bundle1 from billing care or use below flist
   
   PCM_OP_SUBSCRIPTION_PURCHASE_DEAL input flist
   # number of field entries allocated 20, used 4
   0 PIN_FLD_POID POID [0] 0.0.0.1 /account 4290541 0
   0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/telephony 4289821 13
   0 PIN_FLD_PROGRAM_NAME STR [0] "Update credit floor"
   0 PIN_FLD_DEAL_INFO SUBSTRUCT [0] allocated 20, used 1
   1 PIN_FLD_DEAL_OBJ POID [0] 0.0.0.1 /deal 4286850 4
   
   
8. call PCM_OP_BILL_DEBIT to reduce balance with below flist
   
   0 PIN_FLD_POID POID [0] 0.0.0.1 /account 4291010
   0 PIN_FLD_PROGRAM_NAME STR [0] "test"
   0 PIN_FLD_DESCR STR [0] "Non Currency Resource testing"
   0 PIN_FLD_DEBIT ARRAY [1000095] allocated 20, used 1
   1 PIN_FLD_BAL_OPERAND DECIMAL [0] 209715200
   
   
9. check balance bucket
   1000095
   06-JUL-22 12:30:00 - 07-JUL-22 00:32:53
   -5033164800
   
   1000095
   06-JUL-22 12:30:00 - 01-AUG-22 12:30:00
   -5033164800
   
   
10. 01 Aug: run pin_bill_accts
    
    
11. check rollover bucket created and see what is the balance, 10066329600 or 5033164800?
    
    select rec_id,rec_id2,valid_from,valid_to,current_bal,rollover_data,grantor_obj_id0 from bal_grp_sub_bals_t where obj_id0=4288546 order by rec_id;

    2 1000095 06-JUL-22 12:30:00 07-JUL-22 00:32:27 0 65537 4287585
    4 1000095 06-JUL-22 12:30:00 01-AUG-22 12:30:00 0 65537 4281995
    6 1000095 06-JUL-22 12:30:00 01-SEP-22 12:30:00 -10066329600 65537 4281995 -----------------> See this bucket
    8 1000095 01-AUG-22 12:30:00 01-SEP-22 12:30:00 -5242880000 1073807360 4281995 

12. see that the rollover bucket has a balance of 10066329600, expected is 5033164800

Cause

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