Incorrect Calculation Of 'STATISTIC_AMOUNT' In CI_FT_GL Table When SQI Has 18 Decimal Precision
(Doc ID 2543695.1)
Last updated on FEBRUARY 10, 2020
Applies to:
Oracle Financial Services Revenue Management and Billing - Version 2.5.0.4.0 and laterInformation in this document applies to any platform.
Symptoms
On : 2.5.0.4.0 version, ENV - Environment
ACTUAL BEHAVIOR
---------------
Incorrect calculation of 'STATISTIC_AMOUNT' in CI_FT_GL table when SQI has 18 decimal precision.
We calculate 5% tax on transaction amounts for Tax implementation.
For amounts like 96.100 AED, the tax amounts is 4.805. Whereas, in CI_FT_GL table, this tax amount is stamped as '4.804999999999999716' in column STATISTIC_AMOUNT when VAT SQI precision is 18. It should be stamped as 4.805.
The base algorithm type used is : C1-RATECALC
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 |