My Oracle Support Banner

Flat Discount Proration In Leap Years Gives More Discount Than Configured Value (Doc ID 2495668.1)

Last updated on MARCH 20, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


For a customer with annual subscription plan and also having an proratable annual flat discount, when changing the plan in the middle of the year, proration of flat discount is wrong as customer is receiving a bigger discount that configured value.

This is happening in leap years.

See the following in cm.pinlog :

It can be seen the following discount amounts for period 27.04.2019 - 27.04.2020: -76.13 and -4.88 . Total is 81.01

Problem is that sum of the two discounts is greater than value of discount for one year (81.01 vs 81 )



When prorating discount in leap year customer should not receive more than configured value of discount.


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

1. customer activated on 5-Mar-2019 with annual subscription plan and also having an proratable annual flat discount of 139.5 USD.

2. move pvt on 27-apr-2019

3. custom opcode is run which switches plan to annual subscription plan with proratable annual flat discount of 81 USD

81 USD flat discount is prorated as following: -76.13 USD for period 27-Apr-2019 to 5-Apr-2020

4. move pvt on 5-mar-2020

5. run pin_bill_accts

6. move pvt on 5-Apr-2020

7. pin_bill_accts is run. It creates a new discount event related to annual flat discount of 81 USD: -4.88 for period from 5-Apr-2020 to 27-Apr-2020



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

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