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 JUNE 28, 2024
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:
- Invoices showing on the trial balance incorrectly
- Invoices or payments showing as unaccounted on the Period Close Exceptions report
- Invoices or payments appear partially accounted
- Drill down issues when drilling down to the transaction from GL the transaction does not match
Steps to reproduce:
- Log into Oracle applications using a Payables responsibility.
- Open the Invoice Workbench
(N) Invoices > Entry > Invoice - Create an invoice
- Click on the [Actions] button
- Check option "Validate"
- Click [OK]
- 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 |