Cycle Forward Items From Account Level Product Are Not Getting Accumulated During Billing (Doc ID 2049309.1)

Last updated on JULY 27, 2017

Applies to:

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

Symptoms

Cycle forward items from account level product are not getting accumulated during billing. There are separate /items created for each of the cycle events of the products. This results in unnecessary creation of extra events although the bill amount is correct.

Reproduction Steps :
------------------------
1. Sep 10: Create account and purchased account level product1 and product2.
2. Sep 18: Run partial billing.
3. Sep 19: Run final billing.
4. Oct 18: Run partial billing. CF event's items is not accumulated:
select /*+ parallel(e,32) parallel(ebi,32) */ u2s(e.created_t), e.item_obj_id0, ebi.amount, ebi.product_obj_id0, e.item_obj_type, e.poid_type, e.poid_id0, e.service_obj_type, e.service_obj_id0,
ebi.BAL_GRP_OBJ_ID0 from event_t e, event_bal_impacts_t ebi

18/10/2016 00:00:35 634258125267 0.19 634258127971 /item/cycle_forward /event/billing/product/fee/cycle/cycle_forward_monthly 300686278129285587
18/10/2016 00:00:35 634258128339 1.3 634258126243 /item/cycle_forward /event/billing/product/fee/cycle/cycle_forward_monthly 300686278129284051
/item/cycle_forward 634258125267 and 634258125267 is not getting accuculated

5. Oct 19: Run final billing.
select /*+ parallel(e,32) parallel(ebi,32) */ u2s(e.created_t), e.item_obj_id0, ebi.amount, ebi.product_obj_id0, e.item_obj_type, e.poid_type, e.poid_id0, e.service_obj_type, e.service_obj_id0,
ebi.BAL_GRP_OBJ_ID0 from event_t e, event_bal_impacts_t ebi
where e.account_obj_id0 = 634257971558 and ebi.obj_id0 = e.poid_id0 order by e.account_obj_id0, e.created_t desc;

19/10/2016 00:00:12 634258128401 0.19 0 /item/cycle_tax /event/billing/cycle/tax 300703870315327761
19/10/2016 00:00:11 634258126865 13.11 0 /item/cycle_tax /event/billing/cycle/tax 300703870315327505
/item/cycle_tax 634258128401 and 634258126865 is also getting accumulated.

Configuration
-----------------
- fm_bill cycle_tax_interval billing
- fm_bill config_billing_delay 1
- fm_bill taxation_switch 3

select * from config_item_types_t where item_tag in ('cycle_forward','cycle_tax');
634257971365 1 cycle_forward /item/cycle_forward Cycle forward 0 2 cycle_forward
634257971365 5 cycle_tax /item/cycle_tax Cycle tax 0 2 cycle_tax

select * from config_item_tags_t where item_tag in ('cycle_forward','cycle_tax');
634257970196 3 cycle_forward /event/billing/product/fee/cycle/cycle_forward* /service/*
634257970196 16 cycle_forward /event/billing/product/fee/cycle/cycle_forward* /account
634257970196 17 cycle_tax /event/billing/cycle/tax /account

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