Accounting entries not transferred to the General Ledger

•By admin

Accounting entries not transferred to the General Ledger
SLA entries not transferred to GL
Query to get subledger entries that are not transferred to General Ledger
Oracle apps XLA entries that are not transferred to GL
Oracle EBS R12 accounting entries not transferred to the general ledger
oracle r12 transfer journal entries to gl
accounting entries not transferred to the general ledger
how are subledger applications transferred into the ledger

Below query gives the SLA entries that are not transferred to General Ledger. This query gives data from all modules. You can hardcode specific application id to check only particular application. This query can be executed before closing GL period to check if any entry is pending to be transferred to GL. If it gives any output, you can run “Transfer Journal Entries to GL” concurrent program to transfer the pending entries to GL. Prerequisite for the below query is that the create accounting should have been performed.

SQL Querysql
1---SLA entries not transferred to GL
2
3SELECT h.ledger_id,
4       l.ae_header_id,
5       h.accounting_date,
6       h.period_name,
7       h.entity_id,
8       l.gl_sl_link_id,
9       l.gl_sl_link_table,
10       h.gl_transfer_status_code
11  FROM apps.xla_ae_lines l, apps.xla_ae_headers h
12 WHERE     l.application_id = h.application_id
13       AND l.ae_header_id = h.ae_header_id
14       -- AND h.application_id = 222 <hardcode application id if required>
15       -- AND h.ledger_id = '1234'
16       AND l.gl_sl_link_id IS NOT NULL
17       --AND h.gl_transfer_status_code = 'S'
18       AND h.accounting_entry_status_code = 'F'
19       AND h.accounting_date BETWEEN TO_DATE ('01-MAY-2022', 'DD-MON-YYYY')
20                                 AND TO_DATE ('31-MAY-2022', 'DD-MON-YYYY')
21       AND NOT EXISTS
22              (SELECT 1
23                 FROM apps.gl_import_references ir, apps.gl_je_headers gh
24                WHERE     ir.gl_sl_link_id = l.gl_sl_link_id
25                      AND ir.gl_sl_link_table = l.gl_sl_link_table
26                      AND ir.je_header_id = gh.je_header_id
27                      AND ir.je_batch_id = gh.je_batch_id
28                      AND gh.ledger_id = h.ledger_id);

Related posts: