BDOM Change In Delay Period (Doc ID 1358161.1)

Last updated on APRIL 19, 2013

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
HP-UX Itanium

Symptoms

When changing BDOM (Billing Day Of Month) of account in delay period, unexpected behavior is
happening. Please find the scenario described below.

After the change of BDOM, cycle_forward_monthly events and balances are continuously generated in the original BDOM not in new a BDOM.

For example change  BDOM from 8th to 27th of the month, and in the next months this events
are generated on 8th of corresponding month, not on 27th.
After the change, valid from in bal_grp_sub_bals_t has the value of original BDOM and valid_to has the value of new BDOM. This seems to be repeating for all months after the change.

Because of this, account cannot use its bucket for the entire month (but for example in scenario bellow, balances have validity only for 8th of month till 27th of month).

Steps to re-produce :
1) 08.02.2011 - Create hierarchy with bdom 8 and subscribe products.
In purchased_product_cycle_fees_t there are products with charged_from_t and cycle_fee_start_t equal 08.02.2011 charged_to_t and cycle_fee_end_t equal 08.03.2011

In event_t , cycle_forward_monthly events are created with earned_start_t
equal 08.02.2011 earned_end_t equal 08.03.2011

In bal_grp_sub_bals_t there are balances with valid_from equal 08.02.2011
valid_to equal 08.03.2011

In billinfo_t:
last_bill_t equals 08.02.2011
next_bill_t equals 08.03.2011
future_bill_t equals 08.04.2011

2. 08.03.2011 - Change of BDOM (from 8 to 27) in delay period
In purchased_product_cycle_fees_t there are products with
charged_from_t and cycle_fee_start_t equal 08.03.2011 charged_to_t
 and cycle_fee_end_t equal 08.04.2011

In event_t, cycle_forward_monthly events are created with earned_start_t
equal 08.03.2011 earned_end_t equal 08.04.2011

In bal_grp_sub_bals_t there are balances with
valid_from equal 08.03.2011
valid_to equal 08.04.2011

In billinfo_t:
last_bill_t equals 08.02.2011
next_bill_t equals 08.03.2011
future_bill_t equals 27.03.2011

As the account was still in delayed period when the change of BDOM was done, the balances are granted for the whole original period.

3. 10.03.2011 - accounts are billed; pin_cycle_forward is executed
Change in billinfo_t
last_bill_t equals 08.03.2011
next_bill_t equals 27.03.2011
future_bill_t equals 27.04.2011

4. 27.03.2011 - opening billing ; pin_cycle_forward is executed
No change in above mentioned tables

5. 29.03.2011 - accounts are billed ; pin_cycle_forward is executed
No cycle forward event are generated. No balances added.
Change in billinfo_t
last_bill_t equals 27.03.2011
next_bill_t equals 27.04.2011
future_bill_t equals 27.05.2011

6. 08.04.2011 - running billing and pin_cycle_forward as this is run everyday in production
After billing no changes are observed.
But after pin_cycle_forward there are changed:
In purchased_product_cycle_fees_t there are products with charged_from_t and cycle_fee_start_t equal 08.04.2011 charged_to_t and cycle_fee_end_t equal 08.05.2011

In event_t, cycle_forward_monthly events are created with earned_start_t equal 08.04.2011
and earned_end_t equal 08.05.2011

In bal_grp_sub_bals_t there are balances with
valid_from equal 08.04.2011
valid_to equal 27.04.2011

7. 10.04.2011 - running billing and pin_cycle_forward as this is run everyday in production.
No change observed.

8. 27.04.2011 - running billing and pin_cycle_forward
No change observed. No events and balances generated.

9. 29.04.2011 - running billing and pin_cycle_forward
No change in bal_grp_sub_bals_t. No cycle_forward_monthly events created.

In billinfo_t:
last_bill_t equals 27.04.2011
next_bill_t equals 27.05.2011
future_bill_t equals 27.06.2011

10. 08.05.2011 - running billing and pin_cycle_forward as this is runned
everyday in production
No change after billing.
After running pin_cycle_forward :
In purchased_product_cycle_fees_t there are products with
charged_from_t and cycle_fee_start_t equal 08.05.2011
charged_to_t and cycle_fee_end_t equal 08.06.2011

Cycle_forward_monthly events are generated with:
earned_start_t equal 08.05.2011
earned_end_t equal 08.06.2011

New balances added in bal_grp_sub_bals_t:
valid_from equal 08.05.2011
valid_to equal 27.05.2011

11. 10.05.2011 - billing and pin_cycle_forward
No change observed.

12. 29.05.2011 billing and pin_cycle_forward
In billinfo_t:
last_bill_t equals 27.05.2011
next_bill_t equals 27.06.2011
future_bill_t equals 27.07.2011

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