My Oracle Support Banner

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


On : version, Usage

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

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

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

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


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

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