My Oracle Support Banner

Unapplied Accounting Lines in XLA are Missing When Receipt Application,Write-Off, Unapplication, Reversal on Same Day (Doc ID 1340842.1)

Last updated on JUNE 28, 2023

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
Form: ARXRWMAI.FMB - Receipts


Not all accounting lines are shown in XLA when you account for a receipt that has been applied to an invoice in part,written off, unapplied and reversed on the same day.
System merge Unapplied Cash Entries


The issue can be reproduced at will with the following steps:
1. Create Receipt (say of 6000 dated 01Apr07)
2. Create Transaction (say of 5000 dated 01Apr07)
3. Apply to Transaction of 5000- Date 01May07
4. Write off Balance 1000- Date 01May07
5. Unapply the application and write-off- Date 01May07
6. Reverse the receipt Date 01May07

Note the existing entries in XLA :

Expect following entries
Expected Entries
Cash DR For receipt creation
Unapplied Cash CR

Unapplied Cash DR Application
Receivable CR
Write-off CR

Receivable DR Unapplication
Write-off DR
Unapplied Cash CR

Unapplied Cash DR Reversal
Cash CR

 There is no one to one mapping of UNAPP XLA entries in AR and SLA




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.