My Oracle Support Banner

R12: AP/XLA: Generic Data Fix (GDF) for Invoice or Payment Transactions with Accounting Dates out of Sync with the Subledger Tables (Doc ID 874904.1)

Last updated on NOVEMBER 22, 2023

Applies to:

Oracle Payables - Version 12.2.9 to 12.2.9 [Release 12.2]
Oracle Payables - Version 12.2.11 to 12.2.11 [Release 12.2]
Oracle Payables - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]
Oracle Payables - Version 12.2.3 to 12.2.3 [Release 12.2]
Oracle Payables - Version 12.2.6 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Invoices or Payment Transactions have accounting dates that are out of sync with the accounting dates in the related subledger tables.

Out of sync accounting dates can cause:

Steps to reproduce:

  1. Log into Oracle applications using a Payables responsibility.
  2. Open the Invoice Workbench
    (N) Invoices > Entry > Invoice
  3. Create an invoice
  4. Click on the [Actions] button
  5. Check option "Validate"
  6. Click [OK]
  7. If the invoice is affected by this issue, then the accounting date in AP_INVOICE_DISTRIBUTIONS_ALL will not match the event date in XLA_EVENTS

Cause

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
Symptoms
Cause
Solution
 DATA-FIX
 CODE-FIX
References

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