My Oracle Support Banner

Reports Issue: Unapplied Receipt Register Shows a Receipt as Unapplied Even Though It Is Fully Applied (Doc ID 223822.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


The following scenarios cause a fully applied receipt to still appear on the Unapplied Receipt Register.

Case 1
After the receipt has been created and applied, the amount of the receipt is reduced.
1. Create transaction for 3,81 eur, exchange rate 0,0639 and complete the transaction.
2. Create receipt for amount 127,49 eur, exchange rate 0,0639
3. Apply the receipt to transaction from step 1.
4. Modify the receipt amount into 3,81 and save.

In AR_RECEIVABLE_APPLICATIONS_ALL All, for UNAPP-records,  the sum of Acctd Amt Applied From = -.01

This receipt will occur on the Unapplied Receipts Register.

Case 2
The receipt has been applied to several invoices including a credit memo or negative invoice.

inv1 226.87 DEM = 116 EUR
inv2 226.87 DEM = 116 EUR
inv3 226.87 DEM = 116 EUR
inv4 226.87 DEM = 116 EUR
inv5 226.87 DEM = 116 EUR
cm  -226.87 DEM = - 116 EUR

The receipt is entered with an amount of 907.48, all 6 transactions are applied to the receipt.
During receipt application rounding entries are created to get the receipt closed completely for one of the invoices.

If now the credit memo and exactly this invoice are unapplied from the receipt the receipt still remains closed but will show the 0.01 cent on report unapplied receipt register report. Also ar_payment_schedules_all.acctd_amount_due_remaining shows -0.01 cent as open even the amount_due_remaining is 0.00.

This corruption is not very common as it is not typical to enter the data exactly in this way.


To view full details, 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 a vibrant support community of peers and Oracle experts.