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

Last updated on SEPTEMBER 08, 2023

Applies to:

Symptoms

On Oracle Communications Billing and Revenue Management (BRM) version 7.5.0.14.0, when 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 fees
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

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