My Oracle Support Banner

R12: AP/XLA: Troubleshooting Accounts Payable Trial Balance (Open Account AP Balance Listing) Issues (Doc ID 553484.1)

Last updated on FEBRUARY 27, 2024

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.


How to troubleshoot Accounts Payable Trial Balance (Open Account AP Balance Listing) issues in R12

Note: The following troubleshooting steps are both technical and functional. Please review the entire note and complete as many troubleshooting steps as possible. If further assistance is needed, please log an SR with support and upload the output from each step to the SR. And update the SR with any findings/comments from your research.


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
Troubleshooting Steps
 Apply the latest code for the Trial Balance
 Accounts Payable Trial Balance report name
 Complete Post-Install Steps for Trial Balance Remodel patch
 How to Rebuild the Open Account AP Balances Listing (Trial Balance) Data
 Clarify/Define the issue
 Type 1: Invoice incorrectly reported/missing from trial balance
 Type 2:  AP Trial Balance total does not reconcile with GL
 Type 3:  R12 Trial Balance does not reconcile with R11.5 Trial Balance after the upgrade.
 Get Relevant Data for the Problem Invoice
 Common Problems 
 Queries to Check for Known Issues
 Queries to compare XLA and GL data
 Getting Trial Balance File and Package Versions
 Additional Troubleshooting Files and Data Collection

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