Rollover Bucket of Previous Month Is Getting Ended When Deal Is Cancelled (Doc ID 2912726.1)

Last updated on DECEMBER 07, 2022

Applies to:

Symptoms

Scenario:

• customer has purchased 6GB ('domestic data') plan on current month
• consumed 2GB domestic data
• after billing, 4GB is rolled over to (say) 'customer data' as rollover bucket
• customer does an upgrade from 6GB to 30GB plan
• during this step, system is setting end date to the rollover bucket as well, while it is expected that the rollover bucket validity should not be truncated
• in patch set 3, it was working fine and the issue started from patch set 4

Steps to reproduce:

1. cm pin conf:
          - fm_bill apply_rollover 1
   
   
2. business parameter:
          rollover_transfer = 1
   
   
3. run "load_pin_notify -dv pin_notify" with below two enabled:
   9069 0 /event/billing/cycle/rollover/monthly
   9069 0 /event/billing/cycle/rollover_correction
   
   
4. 7 april: in Pricing Design Center, create a charge offer as follows, and create bundle and package:
   Monthly Cycle Forward, credit 'Free Seconds'=2000, valid from event occurrence to 1 accounting cycle, prorate based on usage
   Monthly Cycle Rollover, Purchase mid cycle proration: prorate rollover amount, Cancel mid cycle proration: prorate rollover amount, Rollover units of measure= Months, Maximum no: 10, Maximum rollover per cycle: 1200, Maximum cumulative rollover amount: 5000
   
   
5. 7 april: in Billing Care, create account and purchase above package, billing day of month (DOM)=1, bill cycle will be 7 April to 1 May
   
   
6. 1 may: pin_bill_day -verbose
   
   
7. check sub balances:
   
   select valid_from, valid_to, current_bal, rollover_data from bal_grp_sub_bals_t where obj_id0=(select poid_id0 from bal_grp_t where account_obj_id0= 2227023);
   07-APR-22 17:42:03 01-MAY-22 12:30:00 0 65537
   01-MAY-22 12:30:00 01-JUN-22 12:30:00 -2000 1073807360
   07-APR-22 17:42:03 01-JUN-22 12:30:00 -1585.6 1073807361
   
   see the rollover bucket at the bottom, it ends 1st june.
   
   
8. 16 may: cancel the charge offer with below opcode:
   
   PCM_OP_BILL_CANCEL_PRODUCT
   0 PIN_FLD_POID POID [0] 0.0.0.1 /account 2227023 0
   0 PIN_FLD_PRODUCTS ARRAY [0] allocated 20, used 3
   1 PIN_FLD_QUANTITY DECIMAL [0] 1
   1 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 2225615
   1 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 2224846 1
   0 PIN_FLD_PROGRAM_NAME STR [0] "TEST"
   0 PIN_FLD_END_T TSTAMP [0] (1652688198) Mon May 16 01:03:18 2022
   
   
9. check the sub balances:
   
   07-APR-22 17:42:03 01-MAY-22 12:30:00 0 65537
   01-MAY-22 12:30:00 16-MAY-22 13:33:18 -970.6 1073807360
   07-APR-22 17:42:03 16-MAY-22 13:33:18 -1585.6 1073807361
   
   see the last line, rollover bucket, the validity got truncated to 16 may, expected to stay 1 june.

Cause

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