ZRG4046S Script Creates Inconsistent Financial Transactions With Rounding (Doc ID 2009226.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle Health Insurance Policy Administration - Version 10.14.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 10.14.2.3 version, Usage (Policy)

After executing batch script ZRG4046S, the following error occurs;


ERROR
-----------------------
"Financial transaction 6657: amount does not match (the total of) the transaction details."


This is a financial transaction for "UTSK" = Uitschrijfkosten = cancellation penalties
select * from fvs#financial_transactions_ fft
where id = 6657
-> type = UTSK, net_amount = 1268.99

It has 2 detail records:
select sum(amount) from fvs#fin_transaction_lines_ ffl
where ffl.fft_id=6657
-> 1268.98
Rounding difference!!!


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Financial transactions having this error cannot be processed.
It cannot be predicted how many of these rounding errors will occur.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms