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


On : version, Usage (Policy)

After executing batch script ZRG4046S, the following error occurs;

"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!!!

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.


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