Search Results ae_line_reference_internal




Overview
Explore in AI Chat

Overview

AR_AEL_SL_ADJ_V is a Receivables subledger accounting view owned by the APPS schema. It belongs to the family of "AEL" (Accounting Events Ledger) views that Oracle E-Business Suite provides for extract, reporting, and integration of subledger accounting data, most notably for the Subledger Accounting (SLA) model introduced in Release 12. This particular view presents the accounting and adjustment detail generated from Receivables adjustments — manual and automatic adjustments such as write-offs, credit memos applied as adjustments, and other receivables transactions recorded in AR_ADJUSTMENTS_ALL.

The view is designed to expose, in a single denormalized row set, both the transaction header attributes (adjustment number, transaction date, transaction class, transaction type) and the corresponding accounting distribution lines from AR_DISTRIBUTIONS_ALL. It therefore serves as a bridge between the operational adjustment record and its GL-facing accounting entries, carrying entered and accounted debit/credit amounts, currency conversion information, third-party (customer) identification, and GL transfer status. It is commonly used for reconciliation, audit reporting, and external data feeds that need adjusting-entry detail at line level.

Two columns are of particular interest to users searching for "ae_line_reference_internal": AE_LINE_REFERENCE and AE_LINE_REFERENCE_INTERNAL. The former is built as L5.MEANING||' '||ADJ.ADJUSTMENT_NUMBER, providing a human-readable reference combining the transaction class meaning and the adjustment number. The latter is derived by RPAD(ADJ.ADJUSTMENT_NUMBER, 20, ' '), producing a fixed-width, space-padded internal reference suitable for joining and sorting in downstream accounting processes.

Underlying Base Objects

Per the documented metadata, AR_AEL_SL_ADJ_V is defined over the following base objects:

The core join is between AR_ADJUSTMENTS_ALL and AR_DISTRIBUTIONS_ALL, with the remaining objects supplying descriptive lookups and party attributes.

Key Columns

Common Use Cases and Queries

This view is typically queried to reconcile adjustments with their accounting entries, to report adjusting activity by customer or period, and to feed external reconciliation systems. A representative query:

  • SELECT trx_number_displayed, trx_class_name, trx_type_name, accounting_date, accounted_dr, accounted_cr, third_party_name, gl_transfer_status_name, ae_line_reference_internal FROM ar_ael_sl_adj_v WHERE set_of_books_id = :ledger_id AND accounting_date BETWEEN :start_date AND :end_date ORDER BY accounting_date, trx_number_displayed;
  • To trace a specific line: SELECT * FROM ar_ael_sl_adj_v WHERE ae_line_reference_internal = RPAD(:adjustment_number, 20, ' ');
  • To reconcile GL-transferred versus unposted adjustments: SELECT gl_transfer_status, COUNT(*) FROM ar_ael_sl_adj_v GROUP BY gl_transfer_status;

Note that the view applies no ledger restriction itself; the SET_OF_BOOKS_ID column must be constrained explicitly.