Change Of Rounding Precision For Proration Between BRM 7.3.1 And 7.5 PS13 (Doc ID 2075515.1)

Last updated on JUNE 04, 2024

Applies to:

Goal

Issue:

*  After an upgrade from 731 to 75PS13, it was observed that there is a change of rounding precision during calculation of pro-ration (scale)
*  In particular, it was noticed that there is a change in the length of the value stored in PERCENT field of EVENT_BAL_IMPACTS_T table.

Scenario:

The following test was performed on 731 and 75PS13:
*  Cycle Forward Product with scaled amount = 48.99$
*  Period for pro-ration: Feb 24, 2015 (earned_start_t) to Mar 01, 2015 (earned_end_t)
*  pin_beid values for resource amount were not be changed between the two versions and are the standard one provided out of box

The pro-rated event created during product purchase has the following values:
    In 7.3.1:
          event_bal_impacts_t.amount = 8.16
          event_bal_impacts_t.percent = 0.166666666666666 (15 decimal digits)

    In 7.5 SP13:
          event_bal_impacts_t.amount = 8.17
          event_bal_impacts_t.percent = 0.1666666666667 (13 decimal digits)

Question:

Is there a change from max 15 digits to max 13 digits between the two releases?

Solution

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