My Oracle Support Banner

R12: AP: Primary Troubleshooting Guide (MTG) for Accounting Issues in Oracle Payables (Doc ID 1375017.1)

Last updated on JULY 23, 2021

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle 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.

 
**NEW**   The Feb 2015 RPC patches are available.   

Please see the following document for more information:

EBS: R12.1 Oracle Financials Recommended Patch Collection (RPC)  (Doc ID 954704.1),


**  New Diagnostic Analyzers :

 

 
  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:
  •  Rerun the Create Accounting process, review the errors and try to solve using the error message. See Section #5.
  •  Find the error message details then review Section #7.4 , try to find the document relevant to your issue and submit it.
  •  Use the diagnostics in Section #8 to investigate the invoice or payment.




     4. For data corruption errors run the GDF diagnostics described in Section #7.3
                  Review the GDF diagnostics report then run the GDF script suggested in this report.
                  It will solve the data corruption issues.



   5. Do you expect to see further details in this document that will help you to quickly solve errors ?
       Kindly enter your recommendations and comments in the "Rate this Document" window opened from the right corner.
       Thank you!

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. HOW DOES CREATE ACCOUNTING WORK?
 
 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. HOW DOES THE TRANSFER JOURNAL ENTRIES TO GL  WORK?
 
 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. WHAT ARE THE STEPS TO CLOSE THE PERIOD IN PAYABLES?
 
 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. HOW TO PROCESS THE PAYABLES RECONCILIATION?
 
 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. USING ORACLE SUBLEDGER ACCOUNTING PROGRAM REPORT TO CHECK EXCEPTIONS
 
 5.1 Overview of the Subledger Accounting Program Report
 5.2  Use the Error Message to Resolve the Issue
 
 
   6. USING THE ACCOUNTING REPORTS TO CHECK EXCEPTIONS
 
 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. RESOLVING ERRORS
 
 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
 
 
   8. USING DIAGNOSTICS TO CHECK SETUP AND DATA   
 
 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>
 
 
   9. SUBLEDGER ACCOUNTING SETUP IN PAYABLES
 
 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.
 
 
   10. THE PREDEFINED SETUP ELEMENTS FOR ORACLE SUBLEDGER ACCOUNTING
 
 
 
   11. Still Have Questions?
 
 Modification History
References

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