Discount Recalculated Incorrectly When Sequential_cycle_discounting Enabled (Doc ID 1444303.1)

Last updated on MARCH 08, 2023

Applies to:

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

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