My Oracle Support Banner

Rounding Issue Occurs When Find The Difference Between Two SQI’s (rounded Off With Two Decimals) (Doc ID 2651643.1)

Last updated on MARCH 26, 2020

Applies to:

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

Symptoms

On RMB v2.5.0.3.0, Rounding issue with two decimals position.

ACTUAL BEHAVIOR
------------------------------
Rounding issue occurs when we find the difference between two SQI’s (after rounded off with two decimals). Rounding occurs on the converted amount not on the rounded off amount.

1. Using an SQ rule to find the difference between two SQI and stored in another SQI.
2. We used three rate components to get all the SQI values. All the RC lines are coming with two decimals but the diffrence is not based on the rounded off the amount.
3. Decimals position is 2 for all three SQI’s.
4. Rate Currency decimal position is also 2.
5. Rate component precision value is 0.01.

SQI         Txn Currency   Txn Amount    USD to COP          Reverse Rate       USD                 Rounded off to 2 decimals
SNDPRN   COP                 85500           3364.55               0.000297217      25.41202          25.41
PAYPRN    CLP                 19010            791.245               0.001263831      24.02543          24.03
FXREV                                                                                                     1.386588            1.39

EXPECTED BEHAVIOR
-----------------------------------
Expectation is 1.38. Actual is 1.39 (1.386588)

Cause

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
Symptoms
Cause
Solution
References


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