Results for “fa_ael_sl_v”

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

Overview

FA_AEL_SL_V is a subledger accounting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OFA (Oracle Assets) product. The view name indicates its function: "FA" for Assets, "AEL" for Accounting Events Lines, and "SL" for Subledger. It presents Assets adjustment activity in a format consumable by the Subledger Accounting (SLA) engine and by the Create Accounting process, mapping Oracle Assets transactions to the standard AEL (Accounting Event Line) column layout used across EBS subledger modules. In Oracle EBS 12.1.1 and 12.2.2 the view is registered as VALID and is referenced by accounting program logic that transfers asset adjustments to the General Ledger.

The view's principal purpose is to translate rows from Oracle Assets adjustment tables into balanced debit and credit amounts, expressed in both accounted and entered currencies, together with GL transfer status, accounting date, code combination, set of books, and descriptive comments. It is therefore a reporting and integration object rather than a transactional table, and it exposes data in a normalized subledger journal shape.

Underlying Base Objects

The documented referenced base objects for FA_AEL_SL_V are:

• FA_ADDITIONS (synonym)
• FA_ADJUSTMENTS (synonym)
• FA_ASSET_HISTORY (synonym)
• FA_BOOK_CONTROLS (synonym)
• FA_INQUIRY_TRX_GT (synonym)
• FA_LOOKUPS (synonym)
• FA_SYSTEM_CONTROLS (synonym)
• FA_TRANSACTION_HEADERS (synonym)
• GL_SETS_OF_BOOKS (view)

FA_TRANSACTION_HEADERS supplies the transaction header identifier, transaction name, and transaction date entered, and is joined to FA_ADJUSTMENTS through the adjustment records. FA_ADJUSTMENTS provides adjustment amount, adjustment type, debit/credit flag, JE header reference, and the code combination. FA_BOOK_CONTROLS and GL_SETS_OF_BOOKS supply the set of books and currency code, FA_LOOKUPS supplies lookup meanings for transaction type and GL transfer status, and FA_ASSET_HISTORY and FA_ADDITIONS provide asset context. FA_INQUIRY_TRX_GT is a global temporary table used during inquiry processing. The LEADING(TRX) hint in the view text indicates that the optimizer is steered to drive from the transaction headers, reflecting the transaction-centric nature of the query.

Key Columns

• ACCOUNTED_DR / ACCOUNTED_CR — Debit and credit amounts in the ledger currency, derived by applying the debit/credit flag to the adjustment amount, with reserve adjustments netted against any bonus adjustment amount.
• ENTERED_DR / ENTERED_CR — Equivalent debit and credit amounts in entered currency, following the same derivation logic.
• ACCOUNTING_DATE — Taken from FA_TRANSACTION_HEADERS.TRANSACTION_DATE_ENTERED.
• AE_LINE_REFERENCE — Concatenation of the transaction type meaning and the transaction header ID, forming a human-readable accounting event line reference.
• ACCT_LINE_TYPE / ACCT_LINE_TYPE_NAME — Both populated from ADJ.ADJUSTMENT_TYPE (e.g., 'RESERVE', 'COST', 'ADDITION').
• APPLICATION_ID — Constant 140, identifying Oracle Assets as the source application.
• CODE_COMBINATION_ID — The accounting flexfield combination for the adjustment.
• COMMENTS — The transaction name from FA_TRANSACTION_HEADERS.
• CURRENCY_CODE — From GL_SETS_OF_BOOKS; conversion date, rate, and type columns are supplied as NULL in this view.
• GL_TRANSFER_STATUS / GL_TRANSFER_STATUS_NAME — 'Y' or 'N' depending on whether JE_HEADER_ID is populated, with the corresponding lookup meaning.
• SET_OF_BOOKS_ID — Carried from FA_BOOK_CONTROLS.
• AEL_TABLE — Set to 'ADJ', identifying the subledger source table.

Common Use Cases and Queries

FA_AEL_SL_V is commonly queried to reconcile asset adjustments against the General Ledger, to review amounts pending transfer, and to trace adjustments back to their transaction headers. A typical query lists untransferred adjustments for a specific ledger:

• Verify adjustments that have not yet been transferred to GL (GL_TRANSFER_STATUS = 'N') by set of books.
• Reconcile accounted debit and credit totals against GL balances for an accounting period using ACCOUNTING_DATE.
• Report reserve and bonus adjustment activity by code combination and account line type.

Sample SQL:

SELECT accounting_date,
       ae_line_reference,
       acct_line_type_name,
       code_combination_id,
       accounted_dr,
       accounted_cr,
       gl_transfer_status_name,
       comments
FROM   apps.fa_ael_sl_v
WHERE  set_of_books_id = :p_sob_id
AND    accounting_date BETWEEN :p_start_date AND :p_end_date
ORDER BY accounting_date, ae_line_reference;

Because the view performs DECODE-heavy amount derivation and joins across asset, book control, and lookup tables, query performance is best served by restricting on SET_OF_BOOKS_ID and ACCOUNTING_DATE, and by avoiding functions on the accounting date column.