Search Results trx_type_n




Overview
Explore in AI Chat

Overview

APPS.AR_AEL_GL_REC_ALL_V is a reporting view in Oracle EBS Receivables (AR) that presents the full population of accounting event lines destined for the General Ledger, regardless of their current GL transfer status. In Release 12.1.1 and 12.2.2, the Subledger Accounting architecture records accounting entries in the XLA tables and subsequently transfers them to GL via the Create Accounting and Transfer to GL processes. This view consolidates those entries into a single reporting structure in which each row carries a GL transfer status indicator, exposed through the columns GL_TRANSFER_STATUS and GL_TRANSFER_STATUS_NAME, together with subledger accounting identifiers such as AEL_ID, AEL_TABLE, and AE_LINE_REFERENCE.

Unlike the transferred-only variants of the AR accounting views, the "_ALL_V" suffix indicates that the view does not restrict rows to entries that have already been posted to GL. This makes it the appropriate source for reconciliation reporting, where users must compare Receivables subledger balances with GL balances, and for diagnostics on entries that remain untransferred or in error. Because the view includes the GL transfer status for every line, it is the canonical object referenced when a user searches on "gl_transfer_status" in the context of AR-to-GL reconciliation.

Underlying Base Objects

The view is defined over the following documented objects and packages:

The view is effectively a UNION-style aggregate in which accrual and cash-basis lines are combined, with GL transfer status derived from the underlying XLA event data.

Key Columns

Common Use Cases and Queries

Typical scenarios include reconciling AR subledger activity to GL, identifying untransferred or error-status lines, and auditing conversion rates applied to foreign-currency transactions.

Sample query listing untransferred lines:

  • SELECT trx_number_displayed, trx_class_name, accounting_date, accounted_dr, accounted_cr, gl_transfer_status_name, ae_line_reference FROM apps.ar_ael_gl_rec_all_v WHERE gl_transfer_status_name <> 'Transferred' ORDER BY accounting_date;

Sample query reconciling AR activity to GL for a period:

  • SELECT set_of_books_id, gl_transfer_status_name, COUNT(*) line_count, SUM(accounted_dr) total_dr, SUM(accounted_cr) total_cr FROM apps.ar_ael_gl_rec_all_v WHERE accounting_date BETWEEN :from_date AND :to_date GROUP BY set_of_books_id, gl_transfer_status_name;

These queries rely on the view's distinguishing feature — the preservation of every AR accounting line with its GL transfer status — making AR_AEL_GL_REC_ALL_V indispensable for period-end reconciliation and transfer diagnostics.