My Oracle Support Banner

Discount Recalculated Incorrectly When Sequential_cycle_discounting Enabled (Doc ID 1444303.1)

Last updated on MARCH 25, 2019

Applies to:

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

Symptoms

On : 7.2.1.0.0 version, Pipeline Manager

ACTUAL BEHAVIOR
---------------
At the time of Deal Cancel and Purchase (Of another Deal) the Shadow event is wrongly generated. Only one re-calculated event is generated and the Shadow event is not generated for the re-calculation event.

EXPECTED BEHAVIOR
-----------------------
The Shadow event should be generated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Business param sequential_cycle_discounting is enabled.

  1. 2011/10/14 00:02:04 (pvt), effective date (2011/10/14 00:00:00) - Create account.
  2. 2011/10/14 00:02:11 (pvt), effective date (2011/10/14 00:00:00) - Purchase P1 product (cycle forward).
  3. 2011/10/14 00:06:02 (pvt), effective date (2011/10/14 00:00:00) - Purchase P2 product (cycle forward).
  4. 2011/10/14 00:08:04 (pvt), effective date (2011/10/14 00:00:00) - Purchase D1 discount (applicable to P2).
  5. 2011/11/07 00:00:01 (pvt), effective date (2011/11/07 00:00:00) - Purchase D2 discount (applicable to P1 and P3).
  6. Change tariff:
    a. 2011/11/08 00:00:01 (pvt), effective date (2011/11/08 00:00:00) - cancel P1 product
    b. 2011/11/08 00:00:03 (pvt), effective date (2011/11/08 00:00:00) - purchase P3 product.

After each step we have the following balance impacts on currency resource:

2. Purchase P1 product:
34.55 (scale 1) - correct

3. Purchase P2 product:
12.61 (scale 1) - correct

4. Purchase D1 discount:
-2.52 which is 20% of 12.61 - correct

5. Purchase D2 discount (applicable to P1 and P3):
Recalculation of discounts takes place and we have:
D1: + 0.57 (shadow event) - this and next together - correct
D1: - 0.57 (recalculation)
D2: - 0.78 which is 7/31 * 34.55 - correct

6a. Cancel P1 product:
-6.91 - refund for P1
0.69 - refund for D2 (on P1)
0.49 - shadow event for D1 - this and next together - correct
-0.49 - recalculation of D1

6b. Purchase P3 product:
7.56 - fee for P3 (prorated) - correct
0.76 - discount D2 for P3 (10%) - correct
-0.49 - another Balance Impact granted, but no shadow event for them; as a result: customer gets too much discount in amount of: -0.49.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, additional Discounts is being applied to the accounts. Which is revenue Loss to the Customer

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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