Data is not showing in AP_ACCOUNTING_EVENTS_ALL

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
fayyaz.tak
Posts: 114
Joined: Fri Feb 29, 2008 12:35 am
Location: Pakistan

Data is not showing in AP_ACCOUNTING_EVENTS_ALL

Post by fayyaz.tak »

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.
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by ahmadbilal »

<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'
fayyaz.tak
Posts: 114
Joined: Fri Feb 29, 2008 12:35 am
Location: Pakistan

Post by fayyaz.tak »

Thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests