ZRG4046S Script Creates Inconsistent Financial Transactions With Rounding
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.
On : 10.14.2.3 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
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