Ext/Pub R12 The Differences between the AP Trial Balance in R12 and 11i

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Ext/Pub R12 The Differences between the AP Trial Balance in R12 and 11i

Symptoms:

What are the main differences between the R12 and 11i AP Trial Balance?

Solution:

Though the technical aspect of the 11i and R12 Trial Balance report has changed, the core functionality remains the same. This document provides some technical information regarding the differences in both versions.

11i Trial Balance

The 11i AP Trial balance report (APXTRBAL.rdf) uses AP_TRIAL_BALANCE which is populated using data from AP_LIABILITY_BALANCES.

AP_LIABILITY_BALANCES is based on data in AP_AE_HEADERS_ALL and AP_AE_LINES_ALL.

To reconcile the Accounts Payable (AP) activity for the month of April, the application does the following calculation:

Accounts Payable Trial Balance as of March 31
+ Posted Invoice Register for the period between April 1 and April 30
- Posted Payment Register for the period between April 1 and April 30
= Accounts Payable Trial Balance as of April 30

Reference Note 106744.1 Troubleshooting Guide for 11i AP Trial Balance
Reference Note 106740.1 FAQ for 11i AP Trial Balance

R12 Trial Balance

The R12 upgrade migrates all the AP_LIABILITY_BALANCES data into XLA_TRIAL_BALANCES. It also does the following::

• creates "report definitions" for each ledger AP uses
• creates "report definition details" where it associates Liability CCIDs used in 11i (in each ledger, with the corresponding report definition).
• Other benefits are documented in Metalink Note 604739.1

The R12 AP Trial Balance is available in four formats:

• Group by Account Detail
• Group by Account Summary
• Group by 3rd Party Detail
• Group by 3rd Party Summary

The R12 AP Trial Balance (APTB) is built over the Subledger Accounting (SLA) feature of Open Account Balances Listing; therefore, the AP Invoice and Payment details information is stored in the SLA tables and not the GL tables in R12. Details of the Open Account Balances Listing report can be found in Chapter 9 of the Subledger Accounting Implementation Guide Note 394692.1.

Other Tables Used:

• XLA_TB_DEFINITIONS_B
• XLA_TB_DEFINITIONS_TL
• XLA_TB_DEFN_DETAILS
• XLA_TB_DEF_SEG_RANGES
• XLA_TB_USER_TRANS_VIEWS

The R12 AP Trial Balance (titled the Open Account AP Balances Listing) was remodelled and is now available as a one-off patch via Patch 7320079. Access Note 604739.1 to read about the benefits of the new remodelled AP Trial Balance and for the implementation instructions.

Other Resources to Help Understand the Information on the R12 Trial Balance

Review Note 605707.1 SLA: Troubleshooting the AP to GL Reconciliation if you are observing different results in the 11i AP Trial Balance versus R12 AP Trial Balance

Review Note 553484.1 Troubleshooting Accounts Payable Trial Balance (Open Account AP Balance Listing) issues in R12 to help you further troubleshoot your APTB issues

Review Note 604739.1 R12 SLA- New R12 Payables Trial Balance -- aka Open Account AP Balances Listing for the benefits of the new R12 AP Trial Balance and implementation instructions after applying Patch 7320079

References:

Note.743390.1 Ext/Pub R12 The Differences between the AP Trial Balance in R12 and 11i

Get Oracle Certifications for all Exams
Free Online Exams.com