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 laterInformation 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 |