Autoreconciliation of Receipts and Payments Created in Period (n+1) Can Be Reconciled With Receipts and Payments Created in Period (n) (Doc ID 1525417.1)

Last updated on APRIL 27, 2023

Applies to:

Symptoms

 Auto Reconciliation is behaving differently to Manual Reconciliation.
 There is a bug in the auto reconciliation program allowing reconciliation GL dates to be older than transaction GL dates.

 It is observed that the Bank Statement GL Date in the Statement Header is always updated to whatever date the User enters as the GL Date Parameter in
 the Autoreconciliation Request.
 
 Manual reconciliation is not allowing reconciliation of any transaction, Receipt or Payment, with reconciliation GL_DATE earlier than the  transaction GL_DATE:

 The user is shown messages such as:
 
 i.  The clearing/reconciliation GL date cannot be earlier than the unclearing/unreconciliation GL date of this receipt.
 
 ii. The cleared date cannot be earlier than the original GL date of the receipt.
 
 or
 
 iii. The Clearing/Reconciliation GL Date cannot be earlier than the Clearing/Unreconciliation GL Date of this Payment
 
 
 Historically the reason given for this was that the Accounting had to be performed in Chronological Order.

 It is not desirable to be able to Reconcile and account in August Period, then Unreconcile and account in September Period and then re-reconcile and account in August Period

 To be able to do this would have a serious impact on the GL Reconciliation Report ( CEXRECRE.rdf )
 Lets say some Trx was Reconciled and Accounted in Month (n).
 It was found to be wrong on the first day of the next month and unreconciled and accounted in Month (n+1)
 Then Autoreconciliation was run with the GL Date Parameter being the Last Day of Month (n) and accounted in Month (n).

 This means the Payment Hits GL Cash Account Twice in Month (n) and only in the following month is the GL Cash Account Balance corrected.
 
 The Auto Reconciliation Program is allowing to reconcile any  transaction(receipt/payment) with reconciliation GL_DATE earlier than the unreconciliation date (assuming the period is open)
 
 EXPECTED BEHAVIOR
 -----------------------
 In CE, Auto Reconciliation should be in sync with manual Reconciliation and not allow to reconcile any transaction(receipt/payment) with reconciliation
 GL_DATE earlier than the unreconciliation or transaction GL_DATE
 
 STEPS
 -----------------------
 The issue can be reproduced at will with the following steps, both for RECEIPTS and PAYMENTS:

 Payments Test Case
 1.Create a Bank Account and Create a Payment from that Account
 
 2.Create a Bank Statement to which the Payment Can be Reconciled
 Ensure the Statement Header GL Date is in an Open Period
 
 3.Manually Reconcile the Line
 Notice the GL Date is Defaulted from the Statement Header
 
 4.Manually Unreconcile the Line
 (Unless the User Changes it, the sysdate is defaulted here.
 The GL Date on the statement header remains unchanged, despite this being
 the latest GL Date used for Reconciliation or Unreconciliation)
 
 5.Attempt to Manually Reconcile the Line
 Receive Error message
 The Clearing/Reconciliation GL Date cannot be earlier than the
 Clearing/Unreconciliation GL Date of this Payment
 
 6.Submit Autoreconciliation
 The Sysdate is offered as the Default GL Date, however it can be updated to
 any date in an Open AP and AR Period, which could be the same as the
 Statement Header GL Date, or even one before that and before the Payment
 Date.

 
 Autoreconciliation is completed and
 Payment GL Date = 13-AUG-2012
 Payment Clearing GL Date = 31-AUG-2012
 Payment Unclearing GL Date = 05-OCT-2012
 Payment Clearing GL Date = 31-AUG-2012
 
 Receipts Test Case
 1. Go to Cash management--> Bank statements -->Bank statements and
 Reconciliation  query for any account number and date (GL period should be open)
 2. Click on review button 
 3. Click on reconcile button.
 4. Now take any one of the transactions and try to un-reconcile and reconcile
 manually with GL date earlier than the receipt/transaction GL date.
 5. Two errors
   i. The clearing/reconciliation GL date cannot be earlier than the
 unclearing/unreconcilation GL date of this receipt.
   ii. The cleared date cannot be earlier than the original GL date of the
  receipt.
 6. Run the auto reconciliation program for that unreconcilied
 transaction with the GL date prior to the bank statement date
 7. Now query and notice the receipt is reconciled.
 NOTE: While doing manual reconciliation system is giving the error messages
 and it is not allowing us to reconcile. But auto reconciliation program
 reconciled that particular transaction without giving any error message.
 

Cause

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