Prorate On Cancellation Generating Difference Of 0,01 (Round Mode Down) (Doc ID 3030556.1)

Last updated on JUNE 23, 2024

Applies to:

Goal

The rounding mode is configured as down, but it is not working as expected, it is generating a difference of 0.01 in proration of cancellation scenarios.

Beid config:
Rouding method: Down
Precision: 2
Tolerance min: 0.01
Tolerance max: 0.05
Tolerance %: 4

Example:
Product value: $ 40,00
Event type: cycle_forward_arrear
Purchase: 01/01/2024
Cycle start: 01/01/2024
Cycle end: 01/02/2024
Days in billing cycle: 31
Cancellation: 16/01/2024
Days between cancellation and cycle end: 16
Scale: 16/31 = 0.5161290322580645
Refund: 40.00 * 0.5161290322580645 = 20,64516129032258 = 20.64 (rounding down)
Billed: 40.00 - 20,64 = 19.36

Expected result:
Refund: 40.00 * 0.5161290322580645 = 20,64516129032258
Billed: 40.00 - 20,64516129032258 = 19,35483870967742
Billed (rounding down) = 19,35

In this example, a bill was generated with 19.36, but the expected is 19.35.
 

Solution

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