E1: 09: G/L Account Reconciliation (R09150) is Not Reconciling when the Invoice or Receipt has Two Different G/L Dates (Doc ID 2874674.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Symptoms

G/L Account Reconciliation (R09150) is not reconciling when the invoice or receipt has two different G/L dates.  As an example, the first invoice/receipt has 12/10/2021 and the second invoice/receipt has 12/12/2021 then run R09150 with dates (12/10/2021 – 12/13/2021) it will not reconcile.  If you run R09150 with one day (12/10/2021 – 12/10/2021) then the transactions from that date will be reconciled successfully.

Steps to duplicate

1. In (P03B11) Standard Invoice Entry, create two invoices with the same Company (1), same Document Number (12345) and a different Document Type (RI and RR) for the same period (December)
2. Post the RI and RR batches
3. In (P03B102) Receipt Entry, create two receipts for each of the invoices from step 1
4. Post the receipt batches
5. Run (R09130) Refresh Reconciliation File for the Company
6. Run R09150
7. Review report to see if these invoices were reconciled

Changes

Cause

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