R12 SLA: FAQ on Open Account Balances Listing Report
(Doc ID 880546.1)
Last updated on SEPTEMBER 10, 2020
Applies to:
Oracle Payables - Version 12.0.6 to 12.1.0 [Release 12.0 to 12.1]Oracle Assets
Oracle Receivables - Version 12.0.6 to 12.1 [Release 12.0 to 12.1]
Oracle Payroll - Version 12.0.6 to 12.1 [Release 12.0]
Oracle Cost Management - Version 12.0.4 to 12.1 [Release 12 to 12.1]
Information in this document applies to any platform.
Oracle Assets - Version: 12.0.6 to 12.1.1
Oracle Receivables - Version: 12.0.6 to 12.1
Oracle Payroll - Version: 12.0.6 to 12.1
Oracle Cost Management - Version: 12.0.4 to 12.1
Oracle Financial Accounting Hub - Version: 12.0.6 to 12.1.1
Information in this document applies to any platform.
Concurrent Program and Report:
Applies to all EBS products, except AP. Also applies to Financials Accounting Hub: XLATBRPT.xml and XLARBRPT.pkb
AP no longer uses the Open Account Balances Listing or the Open AP Account Balances Listing.
See <
Table: SLA Trial Balance table -- xla_trial_balance
Purpose
The Open Account Balances Listing identifies General Ledger accounts with outstanding balances and it displays the subledger transactions that contribute to that balance. Users can create their own layout and publish their reports using Oracle XML Publisher.
Note: This document is not meant to replace the detailed information in the Subledger Accounting Implementation Guide, which can be found on My Oracle Support.
R12.0 Version – Chapter 9
R12.1 Version – Chapter 10
Questions and Answers
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 |
| Questions and Answers |
| 1. How do I determine if my setup is correct for the Open Account Balances Listing? |
| 2. When I register the program code, is it mandatory that I use the given format in Step 1? |
| 3. How do I determine the AppID if I am using Financials Accounting Hub? |
| 4. What are the AppIDs for some of the E-Business Suite products: |
| 5. How do I decide if I should use the Open Account Balances Listing or the Account Analysis Report and Journal Entries? |
| 6. What table is the information on the Open Account Balances Listing report based? |
| 7. How is the information in the SLA Trial Balance table populated? |
| 8. How do I troubleshoot a problem with the Open Account Balances Listing when no data is printed on the report? |
| 9. How do I determine if the problem I am encountering is related to translation? |
| 10. The system will not allow me to specify a program code with an AppID greater than 3-characters. |
| 11. Are there any specific patches that I should consider to correct the problem I have with the Open Account Balances Listing? |
| References |