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 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, ENV - Environment
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
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