Results for “ar_ael_gl_rec_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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

• JE_HEADER_ID, JE_LINE_NUM – identify the corresponding GL journal entry and line.
• APPLICATION_ID – application identifier (222 for Receivables).
• SET_OF_BOOKS_ID, ORG_ID – ledger and operating unit context.
• TRX_CLASS, TRX_CLASS_NAME, TRX_TYPE_N, TRX_TYPE_NAME – transaction class/type and their meanings.
• TRX_NUMBER_DISPLAYED, TRX_NUMBER_C – the receipt number, displayed and canonical.
• TRX_DATE, ACCOUNTING_DATE – receipt date and GL accounting date.
• CODE_COMBINATION_ID – the accounting flexfield combination for the distribution.
• ENTERED_DR / ENTERED_CR and ACCOUNTED_DR / ACCOUNTED_CR – entered versus accounted debit and credit amounts.
• CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE – currency and conversion attributes.
• THIRD_PARTY_ID, THIRD_PARTY_NUMBER, THIRD_PARTY_NAME – customer identification.
• GL_TRANSFER_STATUS, GL_TRANSFER_STATUS_NAME – whether the entry posted/transferred to GL.
• AE_LINE_REFERENCE, SOURCE_TABLE, SOURCE_ID, AEL_ID, AEL_TABLE – lineage back to the originating distribution.

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.