Invalid Rounding of Applied Discounts
Last updated on DECEMBER 08, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 7.5.0]
Information in this document applies to any platform.
Invalid discount amounts are resulting in invalid invoices being created.
Steps to reproduce:
1. Create account (billing day of month = 1) and service
2. On 01.04.2014, purchase product P1, cycle forward fee is applied
3. On 01.04.2014, purchase discount D1, -100% discount is applied
4. On 18.04.2014, cancel discount D1 with end date = 25.04.2014 (in the future):
4.1. Discount D1 for period 18.04 - 01.05 is refunded
4.2. Discount D1 for period 18.04 - 25.04 is re-applied
4.3 Total sum of balance impacts is 19.52
5. On 18.04.2014, purchase discount D2 (another instance of D1), with start date = 25.04.2014 (in the future)
5.1 Discount D2 is applied for period 25.04 - 01.05 is applied, balance impact is: -19.51
Below is the detailed calculation of charges:
Refund : 18-1 = 13/30 * 97.56 = 42.275999 = 42.28
Reapply : 7/30 *97.56 = 22.764 = -22.76
Hence, net refund : 19.52
For purchase on 25.04 : 6/30 * 97.56 = 19.512
Note the discrepancy of 19.52 net refund, with respect to the purchase of 19.512.
Problem observed: sum of balance impacts for discounts is non-zero.
After performing these actions, client has one product valid for entire cycle (01.04 - 01.05), and two discounts, valid for entire cycle in two parts (01.04 - 25.04 and 25.04 - 01.05). Discount is expected to be -100%, but due to different treatment of discounts closed in future, there are two balance impacts. The sum of these two balance impacts is not equal to balance impact applied later for effectively the same period.
This only happens with sequential discounting enabled, and when modification time is in the future.
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