My Oracle Support Banner

R12 Enhancement Autoreconciliation of Journal Line is enhanced to include Journal Line Amount (Doc ID 1604385.1)

Last updated on OCTOBER 05, 2017

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2.2 [Release 12 to 12.2]
Information in this document applies to any platform.

Details

The Auto-Reconciliation program has been enhanced to include the amount in the matching criteria for bank statement lines (CE_STATEMENT_LINES.AMOUNT) to journal entry lines (GL_JE_LINES.ENTERED_DR or  ENTERED_CR).

Enahncement:
<Bug: 5265916> - AUTORECONCILIATION: NEED PROVIDE ADDITIONAL MATCHING CRITERIA FOR JE'S 

Revised Matching Criteria for General Ledger Journals
The Cash Management AutoReconciliation program matches General Ledger journal transactions if the transactions meet the following criteria:
• The journal line is posted.
• The journal line Accounting Flexfield matches the bank account's Cash Accounting Flexfield.
• The journal line Description matches the statement line Transaction Number.
• The Journal Line Amount (GL_JE_LINES.ENTERED_DR or ENTERED_CR) matches bank statement lines Amount (CE_STATEMENT_LINES.AMOUNT)

Earlier the autoreconciliation logic did not include the bank statement line amount and journal entry line amount in the matching criteria. If the journal line description was same for two journal lines, the system considers them duplicate and autoreconciliation showed an exception: 'Duplicate Journal Entries'

Actions

Development has implemented this feature in below Enhancement for R12.0, R12.1 AND R12.2:

Enhancement <Bug:5265916> - AUTORECONCILIATION: NEED PROVIDE ADDITIONAL MATCHING CRITERIA FOR JE'S


Description

Old Behavior: The Auto-Reconciliation program does not currently include the bank statement line amount and journal entry line amount in the criteria for matching a journal line.
New Behavior: The Auto-Reconciliation program has been enhanced to include the amount in the matching criteria for bank statement lines (CE_STATEMENT_LINES.AMOUNT) to journal entry lines (GL_JE_LINES.ENTERED_DR or  ENTERED_CR).

12.0      patch/115/sql/ceabrmab.pls   120.56.12000000.68
12.1      patch/115/sql/ceabrmab.pls   120.62.12010000.60
12.2      patch/115/sql/ceabrmab.pls   120.96.12020000.26

Below patches provide this feature:

12.0 -> <Patch 19045160:R12.CE.A>
12.1 -> <Patch 5265916:R12.CE.B>
12.2 -> Included in 12.2.4 RUP

Contacts

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
Details
Actions
Contacts
References

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