Prorate Scale Not Calculated Correctly (Doc ID 1393470.1)

Last updated on APRIL 18, 2024

Applies to:

Symptoms

A product with cycle_forward_monthly event to charge prorated amount $0.75 is created. Purchased this product 9 days before billing date. It is expected that BRM calculates the prorate amounts as below:

prorate scale = days_to_prorate / days_in_month = 9 / 30 = 0.3
prorated amount = prorate_scale * amount = 0.3 * $0.75 = $0.225
amount after rounding = $0.23

But, the results are as below:

prorate scale (from /event) = 0.299999999999999
prorated amount = 0.299999999999999 * $0.75 = $0.22499999999999925
amount after rounding = $0.22

The difference is 0.01, and this is causing bill comparison differences.

Steps to Reproduce

1.  Configure a product with cycle_forward_monthly event to charge $0.75
2.  Set the prorate flag and prorate_first and prorate_last to "prorate"
3.  Purchase the product for an account 9 days before billing date
4.  Check the MRC(monthly recurring charge) event for the amount
5.  Expected Prorated Amount = $0.23, where as actual amount was $0.22

Changes

Cause

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