Receipts Data Corruption Issue: A Receipt Shows An Unapplied Amount, But The Receipt Was Applied Completely (Doc ID 1921993.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Receipts Related

A receipt shows an unapplied amount, but the receipt was applied completely.

In this case, the receipt was created with amount = 37940
and was cleared with amount = 37940.99 and a .99 discount.

Cash was posted as 37940.99, while a Remittance was posted as 37940
The data corruption happened when there was an UNAPP for 37941 in ar_receivable_applications_all

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