My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : 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

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