How do I troubleshoot a problem with the Open Account Balances Listing when no data is printed on the report on Open Account Balances Listing Report

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: How do I troubleshoot a problem with the Open Account Balances Listing when no data is printed on the report on Open Account Balances Listing Report

Symptoms:

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

Solution:

(a) Run the Account Analysis Report and Journal Entries Report. If no data is included on those reports, then review Ques 10.

(b) Determine the definition code you are using for your application. Note: The same definition code cannot be used by more than one application—i.e., Payables and Receivables.

(c) Provide the output of the following queries for your <APPN> definition code:
i. select * from xla_tb_definitions_vl where definition_code = [code that you created for your product];
In the above example, if you are troubleshooting the report for Receivables, then you would specify the definition code you created for your Receivables Open Account Balances Listing report.

ii. select * from xla_tb_defn_details where definition_code = [code that you created for your product];

iii. select count(*) from xla_trial_balances where definition_code = [code that you created for your product];

iv. select * from xla_tb_defn_je_sources where definition_code = [code that you created for your product];

v. select * from xla_acct_class_assgns where program_code like 'OPEN_ACCT%';

vi. select count(1) from xla_trial_balances where application_id = [AppID];
See Ques 4 for the list of valid AppID.
For Financials Accounting Hub customers, follow the directions in Ques 3

References:

Note.880546.1 Ext/Pub R12 SLA FAQ on Open Account Balances Listing Report

Get Oracle Certifications for all Exams
Free Online Exams.com