R12: AP: Primary Troubleshooting Guide (MTG) for Accounting Issues in Oracle Payables
(Doc ID 1375017.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle Payables - Version 12.0.0 and laterOracle Subledger Accounting - Version 12.0.0 and later
Information in this document applies to any platform.
Purpose
Oracle Payables (AP): Create Accounting Process > Generic Setup and Troubleshooting Resources > Note
This note is intended to walk you through a set of sequential steps that will facilitate troubleshooting Create Accounting issues in Releases 12.0 through 12.1.
Please see the following document for more information:
** New Diagnostic Analyzers :
- R12: AP: EBS Payables Create Accounting Analyzer (Doc Id 1665706.1)
- R12: Payables Trial Balance Analyzer - Diagnostic to Validate Data for APTB issues (Doc Id 1553507.1)
- R12: Period Close Analyzer - Diagnostic to Validate Data Before Period Close (Doc ID 1489381.1)
** New Accounting Info Centers - Check for useful and interesting updates :
Information Center: Oracle Payables Accounting R12 (Doc ID 1476284.2)
NEW !! To identify upgraded data issues please run Doc ID 1460241.1 - R12: Upgrade GDF Diagnostic to Validate Data Related to Invoices, Payments, Accounting and Suppliers
| How to Get the Most of This Document ? 1. Apply the recommended patches discussed in Section #7.1 ** New ** New Updated from Sep-2013 : Sep-2013 Recommended Patches for R12.1 These patches will prevent many known issues in your system. 2. Run carefully the steps to close the period described in Section #3. It will solve basic issues. 3. For remaining errors:
|
Troubleshooting Steps
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
| Purpose |
| Troubleshooting Steps |
| 1.1 Overview of Create Accounting Program |
| 1.2 Creating Accounting Entries in Payables |
| 1.3 Submitting the Create Accounting Program |
| 1.4 Creating Accounting Entries from Transaction Windows |
| 1.5 Adjusting Accounting Entries |
| 1.6 Viewing Accounting Entries |
| 1.7 Oracle Subledger Accounting Program Report |
| 1.8 The Create Accounting Program Parameters |
| 2.1 Overview of Transfer Journal Entries to GL Program |
| 2.2 Transfer Journal Entries to GL Program |
| 2.3 Transfer Journal Entries to GL Report |
| 2.4 Posting in Oracle General Ledger |
| 3.1 Invoices |
| 3.2 Payment Batches |
| 3.3 Future Dated Payments |
| 3.4 Transactions |
| 3.5 Transfer |
| 3.6 Closing |
| 3.7 Reconciliation |
| 3.8 Purchasing |
| 3.9 Assets |
| 3.10 Reconcile to GL |
| 4.1 Reconciling Payables Activity |
| 4.2 Reconciling Accounts Payable Trial Balance for a given period |
| 4.3 Reconciling Payables Activity to General Ledger |
| 5.1 Overview of the Subledger Accounting Program Report |
| 5.2 Use the Error Message to Resolve the Issue |
| 6.1 Period Close Exceptions Report |
| 6.2 Payables Posted Invoice Register |
| 6.3 Payables Posted Payment Register |
| 6.4 Unaccounted Transactions Report |
| 6.5 Accounts Payable Trial Balance Report |
| 7.1 Apply the Recommended patches |
| Strongly Recommended Patches for Accounting |
| Release 12.1 |
| Release 12.0 - Recommended patches |
| 7.2 Searching in 'My Oracle Support' |
| 7.3 Data Corruption issues - The Use of GDF |
| 7.4 Documents to Investigate and Resolve Errors |
| a. R12.0.6+ : XLA Setup Diagnostics |
| R12.0.6+ : Subledger Accounting (Subledger Accounting): XLA Setup Diagnostics Test Data Collection Test <Note 942252.1> |
| b. R12.0[3-4] : XLA Setup Diagnostics |
| R12.0.[3-4] : Subledger Accounting (Subledger Accounting): XLA Setup Diagnostics Test <Note 942262.1> |
| c. R12.0.6+ : Oracle Payables Invoice Data Data Collection Test (Aplist) |
| 12.0.6/12.1 Legacy: Oracle Payables (SQLAP): Invoice Data Data Collection Test <Note 732163.1> |
| d. R12.0.[3-4] : Oracle Payables Accounting Health Check Setup Test |
| R12.0.[3-4] : Oracle Payables (SQLAP): Accounting Health Check <Note 463727.1> |
| e. R12.0.6+ : Oracle Payables Trial Balance Diagnostics For An Invoice Activity Test |
| R12 Subledger Accounting (XLA): Trial Balance Diagnostics For An Invoice Activity Diagnostic Test <Note 829180.1> |
| f. Oracle Payables Trial Balance Diagnostics For An Invoice Details Test |
| R12.0.[3-4] : Oracle Payables (SQLAP): Trial Balance Diagnostics For An Invoice <Note 882682.1> |
| Accounting Methods Builder (AMB) Overview |
| Accounting Methods Builder Process |
| 9.1 Define custom sources |
| 9.2 Define journal line types |
| 9.3 Define journal entry descriptions |
| 9.4 Define mapping sets |
| 9.5 Define account derivation rules |
| 9.6 Define journal lines definitions |
| 9.7 Define application accounting definitions |
| 9.8 Define subledger accounting method |
| 9.9 Assign each subledger method to a ledger using the Accounting Setup Manager. |
| Modification History |
| References |