FIN3006F - Payment Batches with Incorrect Amount and Missing References. (Doc ID 1988597.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle Health Insurance Disbursements and Collections - Version 10.14.1.4 and later
Information in this document applies to any platform.

Symptoms

On : 10.14.1.4 version, Usage

ACTUAL BEHAVIOR
---------------
In the financial system parameters we have setup amounts that are paid starting at 1 euro.
We have configured the amount of one Euro as the minimum amount of a payment batch.
However , the users can see multiple payment batches that have an amount >1 and they have no payments linked to the payment batch.
There are also payment batches with an amount
There are several payment batches with amount >1 For which no payments are linked.
Also, payment batches


EXPECTED BEHAVIOR
-----------------------
Amounts between 0 and 1 euro are rounded to 0 and closed.
Amounts over a euro always have one or more payments with reference and debtor

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
select bot.id
, bot.bdl_nr_toegang
, bot.bedrag_totaal
, bot.datum_betaal_advies ontstaan
from fsa_betaal_opdrachten bot
left join fsa_betaal_akties bae
on bot.id = bae.bot_id
where bae.kenmerk is null
order by bot.bdl_nr_toegang, bot.id, bot.bedrag_totaal

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
These payment batches are confusing for business. They don't need to see the amounts under one euro.
For the amounts above a euro that have no payments, it's not clear what should be done with them

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