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 2.5.0.4.0 and later
Information 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


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