My Oracle Support Banner

R12: AP: Master Troubleshooting Guide for the Accounts Payable Trial Balance report (Doc ID 1372288.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
Report:APXTRBAL.RDF - Accounts Payable Trial Balance


Purpose

This Note is intended to teach you about the processes involved in completing a Trial Balance report from within Oracle Payables, and to guide you through a set of sequential steps that will help to facilitate troubleshooting Trial Balance report issues in Release12.

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. What is an Accounts Payable Trial Balance report?
 Definitions
 
  2. How do I run an Accounts Payable Trial Balance report?
 Using the SRS window to submit reports
 a) Report Definitions
 b) Four templates available
 c) How to Have Text Output for a Trial Balance
 d) How to Have an R12 XML Report Output Formatted in Excel instead of PDF
 e) Can You Apply Journal Line Definitions Rules to Manual Journal Entries?
 
 Report Parameters
 What do the Summary and Detailed Trial Balance reports look like?
 
  3. TROUBLESHOOTING your Trial Balance report - Identifying What Went Wrong and Finding a Solution
 3.1  EBS Payable Trial Balance Analyzer
 3.2  Finding the error on the related Trial Balance Summary process log file:
 
  4. Additional Diagnostic Tools
 
 
  5. HOT TOPICS:
 a. Accounts Payables Trial Balance shows invoices with status FULLY PAID
 b. Getting error "XLA_SRS_SUBLEDGERS APP-FND-00798" when running the Trial Balance report
 c. The Trial Balance and GL don't match
 
  6. Recommended Solution Documents in My Oracle Support
 Trial Balance Reports
 Other Payables issues
 
  7. Logging a Service Request
 
 Standard Patching Process
 Patch Wizard
 Have more questions?
References

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