R12: AR Reconciliation Report Shows Difference For Over Application Through Lockbox

(Doc ID 889003.1)

Last updated on JUNE 29, 2017

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




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