My Oracle Support Banner

R12: AR Reconciliation Report Shows Difference For Over Application Through Lockbox (Doc ID 889003.1)

Last updated on JANUARY 05, 2021

Applies to:

Oracle Receivables - Version 12.0.1 to 12.1.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
AR Reconciliation Report


AR reconciliation is showing differences the issue can be reproduced with the following steps:

Below is the scenario to replicate the issue:

Setup: Allow Overapplication = Yes

Step1 : Create a transaction with below details
amount = $100
transaction date = 01-Jun-09
GL Date = 01-JUN-09

Step2 : Make an Adjustment type "Invoice", GL Date = 02-Jun-09 which will do adjust for entire invoice amount $100

Now if record is queried in account details form the GL Date Closed will be 02-Jun-09.

Step3 : Run Lockbox for this transaction for amount of $100 (GL Date for receipt 18-Jun-09) which will make invoice over applied and when you query once again in account details screen the details will be:

GL date Closed in the form is blank
Status = open

Query the record from database GL Date Closed = 02-Jun-09
Status = 'OP'
Actual Date Closed = 02-Jun-09




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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