Search Results ar_ael_gl_rec_v




Overview
Explore in AI Chat

Overview

AR_AEL_GL_REC_V is an Oracle E-Business Suite Receivables (AR) view owned by the APPS schema. Its name reflects its purpose: it presents the Receivables accounting events generated by cash receipts ("REC") in the columnar format required by the Oracle Subledger Accounting / SLA and the General Ledger interface. In practice it is a component of the Account Analysis ("AEL") reporting family in Receivables, whose members surface subledger accounting entries for reconciliation, drill-down, and GL transfer review.

The view exposes one row per Receivables distribution line associated with a cash receipt accounting event. It carries the journal entry header/line identifiers, set of books and operating unit, transaction class and type, receipt number and date, accounting flexfield combination, entered and accounted debit/credit amounts, currency conversion attributes, third-party (customer) details, accounting date, and GL transfer status. This makes it suitable both for operational reporting and as a source for reconciling Receivables cash activity to the general ledger.

Underlying Base Objects

The view is defined over a wide set of Receivables, Cash Management, General Ledger, and Trading Community base objects. The principal tables are AR_CASH_RECEIPTS_ALL (the receipt header) and AR_DISTRIBUTIONS_ALL (the accounting distribution lines that form the core of the AEL data). Supporting AR objects include AR_CASH_RECEIPT_HISTORY_ALL, AR_MISC_CASH_DISTRIBUTIONS_ALL, AR_RECEIPT_METHODS, AR_RECEIVABLES_TRX_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, AR_DISTRIBUTION_SETS_ALL, AR_SYSTEM_PARAMETERS_ALL, and AR_VAT_TAX_ALL.

General Ledger objects supply journal and conversion information: GL_JE_HEADERS, GL_JE_LINES, GL_IMPORT_REFERENCES, and GL_DAILY_CONVERSION_TYPES. Cash Management contributes CE_BANK_ACCOUNTS and CE_BANK_ACCT_USES. Customer and party attributes come from HZ_CUST_ACCOUNTS, HZ_PARTIES, and HZ_CUST_SITE_USES_ALL. Document sequencing uses FND_DOCUMENT_SEQUENCES, while security and context are handled by FND_GLOBAL, FND_PROFILE, FND_ACCESS_CONTROL_UTIL, MO_GLOBAL, XTR_USER_ACCESS, and the ARPT_SQL_FUNC_UTIL package. The view joins these to resolve receipt headers, distribution amounts, journal references, and descriptive flexfield meanings into a single accounting-event row.

Key Columns

Common Use Cases and Queries

Typical usage includes reconciling Receivables cash distributions to GL, reviewing unposted receipts, and drilling from account analysis to source documents. A representative query lists unposted receipt accounting lines:

  • SELECT trx_number_displayed, trx_date, accounting_date, entered_dr, entered_cred, gl_transfer_status_name FROM ar_ael_gl_rec_v WHERE gl_transfer_status = 'N' ORDER BY trx_date;

A second common pattern aggregates accounted amounts by receipt for a given ledger and period:

  • SELECT trx_number_displayed, currency_code, SUM(accounted_dr) dr, SUM(accounted_cr) cr FROM ar_ael_gl_rec_v WHERE set_of_books_id = :p_sob AND accounting_date BETWEEN :p_from AND :p_to GROUP BY trx_number_displayed, currency_code;

Because the view embeds operating-unit and security predicates, callers must initialize the FND_GLOBAL/MO_GLOBAL context correctly to obtain complete results.