Search Results fa_ael_gl_v




Overview
Explore in AI Chat

Overview

FA_AEL_GL_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, defined within the OFA (Oracle Assets / Fixed Assets) product. It is one of the family of Assets Accounting Events Line (AEL) views that expose journal-style, subledger accounting lines from Fixed Assets in a consistent column layout required by Oracle Subledger Accounting (SLA), the GL Transfer process, and downstream reporting tools such as Oracle General Ledger, Oracle Purchasing-style AEL extracts, and Discoverer or BI Publisher reports. Its central role is to present adjustment activity that arises inside Oracle Assets in a form that maps directly onto the standard AEL column structure, allowing the Assets subledger to be reconciled to its General Ledger impact.

The view carries the literal AEL_TABLE = 'ADJ', marking its rows as originating from the Assets adjustments accounting stream. The leading token of the object name, FA_AEL_GL_V, follows the naming convention of Assets Accounting Events Line views (AEL), with the "GL" suffix indicating it is aligned to the General Ledger extract and transfer usage. Because the object is a view and not a table, it holds no data of its own; it is a projection derived from transaction and adjustment tables, always reflecting current, committed balances.

Underlying Base Objects

According to the ETRM 12.2.2 metadata, FA_AEL_GL_V is defined over the following referenced base objects, all accessed through APPS-owned synonyms:

  • FA_ADJUSTMENTS — the primary driver of the row set, supplying adjustment amounts, debit/credit flags, adjustment types, code combination identifiers, and JE header references.
  • FA_TRANSACTION_HEADERS — provides the transaction header, transaction type, transaction date entered, asset references, and book type for each line.
  • FA_ADDITIONS — supplies asset number and description attributes.
  • FA_BOOK_CONTROLS and FA_MC_BOOK_CONTROLS — provide set of books context, including multi-currency and reporting book configuration.
  • FA_ASSET_HISTORY — contributes historical asset state used for reporting context.
  • FA_LOOKUPS and FA_LOOKUPS_TL — resolve lookup codes into translated meanings, for example adjustment type and transaction type names.
  • FA_SYSTEM_CONTROLS — supplies system-level defaults and category context.
  • GL_SETS_OF_BOOKS — a GL view supplying the currency code associated with the set of books.

The join structure ties each adjustment to its transaction header by TRANSACTION_HEADER_ID, and then to the asset and book definitions, so that every reporting line is fully qualified by asset, book, and accounting period.

Key Columns

The view exposes names that conform to the AEL standard. The most significant columns are:

Common Use Cases and Queries

FA_AEL_GL_V is most frequently used to audit and reconcile Asset adjustments with their GL postings, to feed downstream reporting on accounting events, and to verify transfer status before period close. A typical reconciliation query selects the debit and credit amounts by book and period for adjustments awaiting transfer:

  • Query unreleased adjustments: SELECT trx_number_displayed, accounting_date, accounted_dr, accounted_cr, gl_transfer_status FROM fa_ael_gl_v WHERE gl_transfer_status = 'N' AND set_of_books_id = :p_sob AND accounting_date BETWEEN :p_from AND :p_to;
  • Summarize adjustment activity by GL account: SELECT code_combination_id, SUM(accounted_dr) dr, SUM(accounted_cr) cr FROM fa_ael_gl_v WHERE set_of_books_id = :p_sob GROUP BY code_combination_id;
  • Locate adjustments by asset: SELECT asset_number, asset_description, acct_line_type_name, accounted_dr, accounted_cr FROM fa_ael_gl_v WHERE asset_number = :p_asset;

Because the view is driven by FA_ADJUSTMENTS joined to FA_TRANSACTION_HEADERS, it is well suited to functional users and developers who require an AEL-shaped result set without directly navigating the underlying Assets transaction schema.