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.
---SLA entries not transferred to GL
SELECT h.ledger_id,
l.ae_header_id,
h.accounting_date,
h.period_name,
h.entity_id,
l.gl_sl_link_id,
l.gl_sl_link_table,
h.gl_transfer_status_code
FROM apps.xla_ae_lines l, apps.xla_ae_headers h
WHERE l.application_id = h.application_id
AND l.ae_header_id = h.ae_header_id
-- AND h.application_id = 222 <hardcode application id if required>
-- AND h.ledger_id = '1234'
AND l.gl_sl_link_id IS NOT NULL
--AND h.gl_transfer_status_code = 'S'
AND h.accounting_entry_status_code = 'F'
AND h.accounting_date BETWEEN TO_DATE ('01-MAY-2022', 'DD-MON-YYYY')
AND TO_DATE ('31-MAY-2022', 'DD-MON-YYYY')
AND NOT EXISTS
(SELECT 1
FROM apps.gl_import_references ir, apps.gl_je_headers gh
WHERE ir.gl_sl_link_id = l.gl_sl_link_id
AND ir.gl_sl_link_table = l.gl_sl_link_table
AND ir.je_header_id = gh.je_header_id
AND ir.je_batch_id = gh.je_batch_id
AND gh.ledger_id = h.ledger_id);
Related posts:
- PTD and YTD balances query in Oracle R12
- Query to find all Expense report entry delegations
- Query to find vacation rules in Oracle R12
- View accounting query in oracle apps R12
- Query to get AR invoice SLA and GL details
- Accounting entries not transferred to the General Ledger
- Query to find all APIs of Oracle Apps modules
- R12 AR cash receipt SLA and GL details query
- Oracle apps AR Applications and SLA details
- Oracle EBS query to get AP Invoice SLA Details
- Oracle EBS query to get AR Invoice SLA Details
- Oracle AR Remit to address query
- Oracle Apps iExpense credit card details query
- Query to get customer tax registration details in R12
- Purchase Requisition Vertex debug xml query in Oracle EBS
- Purchase Order Vertex debug xml query in Oracle EBS
- AP Invoice Vertex debug xml query in Oracle EBS
- AR Invoice Vertex debug xml query in Oracle EBS
- Query to find AP invoice workflow item key in oracle apps
- Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
- Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
- Query to find Sales Orders that are shipped but not invoiced
- Query to get Customer Bank Account Details
- Query to get description of GL Code Combination
- Query to find Purchase Order and Invoice Details
- Query to find AP Invoices matched with receipts
- Query to find Supplier Bank Details
- Query to find Credit Memos on an AP invoice
- Query to find the AP invoices that are applied to multiple Purchase Orders
- AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
- Query to find shipset and fulfilment set