Fees Not Charged During Billing When Service Is Changed One Day Before Billing Cycle (Doc ID 2215021.1)

Last updated on JANUARY 09, 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

On : 7.5.0.14.0 version, Core Billing

In case of purchasing products and discounts one day before billing cycle, BRM does not charge fees on billing day.

Sequential discounting: enabled
Delayed billing: enabled, set to 1 day

Scenario to replicate:
On 2017-01-08:
1. Create a new account (bill day of month set to 6)
2. Create a new service S1 effective_t set to 2017-01-08
3. Purchase a new proratable product P1 on service S1 with cycle monthly fee 97.56. Start_t set to 2017-01-08, end_t set to 0
4. Purchase a new proratable discount D1 (-100%) on product P1. Start_t set to 2017-01-08, end_t set to 2019-01-08
5. Purchase a new proratable product P2 on service S1 with cycle monthly fee 48.70. Start_t set to 2017-01-08, end_t set to 2019-01-08

* BRM correctly charges prorated fees:
P1: 94,31 2017-01-08 2017-02-06
D1: -94,31 2017-01-08 2017-02-06
P2: 47,08 2017-01-08 2017-02-06

6. Execute billing, 1st phase on 2017-02-06 and 2nd phase on 2017-02-07

On 2017-03-05
7. Close service S1, product P1 and P2 and discount D1

* BRM correctly refunds prorated fees
P1: -3,25 2017-03-05 2017-03-06
D1: 3,25 2017-03-05 2017-03-06
P2: -1,62 2017-03-05 2017-03-06

8. Create a new service S2 effective_t set to 2017-03-05
9. Purchase a new proratable product P3 on service S2 with cycle monthly fee 41.57. Start_t set to 2017-03-05, end_t set to 0
10. Purchase a new proratable discount D2 (-100%) on product P3. Start_t set to 2018-03-05, end_t set to 2018-03-05
11. Purchase a new proratable product P4 on service S2 with cycle monthly fee 32.32. Start_t set to 2017-03-05, end_t set to 2018-03-05

* BRM correctly charges prorated fees:
P3: 1,39 2017-03-05 2017-03-06
D2 -1,39 2017-03-05 2017-03-06
P4: 1,08 2017-03-05 2017-03-06

12. Execute 1st billing phase on 2017-03-06
* BRM does not charge any fees - NOT OK.

13. Execute 2nd billing phase on 2017-03-07
* BRM calculates tax based only on fees charged on 2017-03-05

14. Execute pin_cycle_fees with -regular_cycle_fees parameter on 2017.03.08

* BRM incorrectly charges prorated feesl
* Fees should have been charged during 1st billing phase on 2017-03-06
P3: 41,57 2017-03-06 2017-04-06
D2: -40,18 2017-03-06 2017-04-06 -- NOT OK, P3 should have been discounted -100%
P4: 32,32 2017-03-06 2017-04-06

How to resolve this issue?

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