ERPstuff - Oracle EBS Community

Hi to all
I am going to create invoice and save it, then validate it, then perform accounting, and then Transfer to GL, after this it does not show the data in the table of Account Payable Like;
<b>AP_ACCOUNTING_EVENTS_ALL
AP_AE_HEADERS_ALL
AP_AE_LINES_ALL</b>
i cant resolve this problem
Please tell me the Problem why the data is not populated in these tables and how it is possible to populate data in these table

Can any body help me out of this problem

subledger accounting setup is set as standard accrual.

<b>Use following Query You can Get Accounting For Invoices</b>


SELECT xal.ae_header_id, xal.ae_line_num, xal.displayed_line_number,
xah.event_id, xah.completion_acct_seq_value,
NVL (xte.source_id_int_1, -99), xal.accounted_cr, xal.accounted_dr,
xal.accounting_date
FROM xla.xla_transaction_entities xte, xla_ae_headers xah, xla_ae_lines xal
WHERE xte.entity_id = xah.entity_id
AND xte.application_id = xah.application_id
AND xah.ae_header_id = xal.ae_header_id
AND xah.application_id = xal.application_id
AND NVL (xte.source_id_int_1, -99) = &invoice_id
AND xte.application_id = 200
AND xte.ledger_id = '2021'
AND xte.entity_code = 'AP_INVOICES'
AND xal.accounting_class_code = 'LIABILITY'

Thanks