AP: Trial Balance Report does not return any data – EBS R12.1.3

Issue: The Accounts Payables Trial Balance Report does not return back any data. However invoices have been entered and are accounted to the General Ledger. The report completes, however no data is returned.

Solution:

Oracle Metalink: NOTE.553484.1

1. Navigate to the Payables Responsibility –> Setup –> Accounting Setups –> Subledger Accounting Setups –> Open Account Balances Listing Definitions
2. Query your Report Definition. Also select how it is defined by (either by Accoutning Flexfield or Segment)
3. Click on the Update icon[pencil] in the Actions column
4. Click on Apply (Nothing needs to be changed on this screen, just click Apply)

Here is the query to verify that the Trial Balance was rebuilt:

  SELECT xtb.definition_code,
         xah.ledger_id,
         DECODE (xah.upg_batch_id, NULL, 'No', 'Yes') "11i_upgrade",
         MIN (xtb.creation_date) min_creation_date,
         COUNT (*) events_count
    FROM xla_trial_balances xtb, xla_ae_headers xah
   WHERE xtb.ae_header_id = xah.ae_header_id(+)
GROUP BY xtb.definition_code,
         xah.ledger_id,
         DECODE (xah.upg_batch_id, NULL, 'No', 'Yes')
ORDER BY xtb.definition_code, xah.ledger_id;