payables Trial Blance report completed normal but without any data

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: payables Trial Blance report completed normal but without any data

Symptoms:

ON 12.0.6 on production.
When runing the Payables Trial Balance Report , found no output .

Solution:

Use note NOTE.553484.1 Troubleshooting Accounts Payable Trial Balance

1) Apply the Remodel 4 patches (and prerequisite ).
2) Rebuild the data .

Rebuild the data for TB , then provide the Query output :

1. Navigate: Payables Responsibility > Setup> Accounting Setups > Subledger Accounting Setups > Open Account Balances Listing Definitions
2. Query up your Report Definition: select Defined By = Accounting Flexfield or Segment (whichever applies in your case), click“Go”
3. Click on Update icon in the "Actions" column – the definition's update page opens.
4. "Touch" the definition by simply clicking "Apply" button (without making any change).
This should start the “Open Account Balances Data Manager” concurrent processes and a (at least one) worker process “TB Worker…”.Wait for them to complete and verify if the TB data was rebuilt:

select xtb.definition_code
, xeh.ledger_id
, decode( xeh.upg_batch_id, null, 'No', 'Yes' ) upgraded_from_11i
, min( xtb.creation_date ) min_creation_date
, count( * ) events_count
from xla_trial_balances xtb
, xla_ae_headers xeh
where xtb.ae_header_id = xeh.ae_header_id(+)
/* and xtb.definition_code = '&TB_definition_code' */
group by
xtb.definition_code
, xeh.ledger_id
, decode( xeh.upg_batch_id, null, 'No', 'Yes' )
order by
xtb.definition_code, xeh.ledger_id;

Confirm if the TB report still empty .

3) Since "there is no query out put to provide" , i do believe that your setting for TB is not correct , most of the customer are mixing the R11 and R12 Tb but they are different in settings .Please review the following :



Please notice that the setup for R12 report is different than R11 :

1) Note.880546.1 Ext/Pub R12 SLA FAQ on Open Account Balances Listing Report:
2) Note.743390.1 Ext/Pub R12 The Differences between the AP Trial Balance in R12 and 11i:
3) If new install of R12, Navigate to:

Payables Responsibility > Setup > Accounting Setups> Open Account Balances Listing Definitions

Review the Oracle Subledger Accounting Implementation Guide section on "Creating Open Account Balances Listing Definitions" for instructions on how to setup a new report definition.

Please review the above notes and guide and revert back to support with your answers and comments.

References:

NOTE.553484.1 Troubleshooting Accounts Payable Trial Balance

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

Note.743390.1 Ext/Pub R12 The Differences between the AP Trial Balance in R12 and 11i
< !--[if !supportLineBreakNewLine]-->
< !--[endif]-->

Get Oracle Certifications for all Exams
Free Online Exams.com