Results for “adj_bonus”

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

Overview

APPS.JL_CO_FA_AEL_SL_V is a subledger accounting view in Oracle E-Business Suite that presents journal entry line detail for Oracle Assets (Fixed Assets) adjustments in the format expected by the AX (Accounting) extraction schema. Its name follows the standard subledger accounting lineage convention: JL (journal line), CO (the application identity used for Assets in XLA, application_id 140), FA (Fixed Assets), AEL (Accounting Event Line), and SL (Subledger Level), with the trailing V denoting a view. The view exposes one row per accounted adjustment line, deriving debit and credit amounts, accounting dates, and references from the underlying adjustment, transaction header, and accounting repository tables. It is designed to feed reporting and reconciliation processes rather than to store data, and it is registered as a documented object under the APPS schema in ETRM for both 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over a mixture of Assets operational tables, Subledger Accounting (XLA) repository tables, and general ledger lookups. The documented referenced base objects are FA_ADJUSTMENTS, FA_ADDITIONS, FA_ASSET_HISTORY, FA_BOOK_CONTROLS, FA_INQUIRY_TRX_GT, FA_LOOKUPS, FA_SYSTEM_CONTROLS, FA_TRANSACTION_HEADERS, JL_CO_FA_ADJUSTMENTS, XLA_AE_HEADERS, XLA_AE_LINES, XLA_DISTRIBUTION_LINKS, and GL_SETS_OF_BOOKS. FA_ADJUSTMENTS supplies the adjustment amount, adjustment type, debit/credit flag, and code combination; FA_TRANSACTION_HEADERS supplies the transaction header identifier, transaction name, and transaction date entered; the XLA tables provide the accounting event and journal header context used for the GL transfer status columns; and GL_SETS_OF_BOOKS supplies the set of books identifier and currency code. The join through the XLA distribution links correlates each adjustment line to its generated accounting entries.

Key Columns

• ACCOUNTED_DR / ACCOUNTED_CR — Accounted debit and credit amounts, computed from the adjustment amount, its debit/credit flag, and the sign of the net adjustment after any RESERVE offset.
• ENTERED_DR / ENTERED_CR — Entered (transaction currency) equivalents of the same amounts; for Assets these mirror the accounted figures because adjustments are entered in the ledger currency.
• ACCOUNTING_DATE — Taken from FA_TRANSACTION_HEADERS.transaction_date_entered.
• AEL_TABLE — Constant 'ADJ', signalling a fixed assets adjustment source.
• AE_LINE_REFERENCE — Concatenation of the lookup meaning and the numeric transaction_header_id, giving a human-readable reference.
• ACCT_LINE_TYPE / ACCT_LINE_TYPE_NAME — Populated from ADJ.adjustment_type.
• APPLICATION_ID — Constant 140, the Assets application identifier in XLA.
• CODE_COMBINATION_ID — The accounting flexfield combination for the adjustment.
• COMMENTS, CURRENCY_CODE, SET_OF_BOOKS_ID — Descriptive and ledger-identifying attributes sourced from the transaction header and set of books.
• GL_TRANSFER_STATUS / GL_TRANSFER_STATUS_NAME — Derived from whether je_header_id is null ('N' if not transferred, 'Y' if transferred), with the lookup meaning resolved for display.
• SOURCE_ID, SOURCE_TABLE, TRX_CLASS — Constants identifying the originating record (transaction_header_id, 'TH', 'TRANSACTION').

Common Use Cases and Queries

This view is typically consumed by reconciliation reports, XLA accounting extracts, and custom inquiries that need adjustment-level journal detail without querying the normalized XLA tables directly. A typical query selecting all adjustment lines for a ledger and date range appears as follows:

• SELECT accounting_date, ae_line_reference, acct_line_type, accounted_dr, accounted_cr, gl_transfer_status_name
• FROM apps.jl_co_fa_ael_sl_v
• WHERE set_of_books_id = :p_sob_id
• AND accounting_date BETWEEN :p_from AND :p_to
• ORDER BY accounting_date, ae_line_reference;

A second common pattern filters on transfer status to identify adjustments that have not yet been posted to the general ledger, or aggregates accounted debit and credit totals by adjustment type for a period-end reconciliation. Because the view joins operational Assets tables with XLA tables, it is best used read-only, with binds on set_of_books_id and accounting_date for performance. Note that the user search term "fa_transaction_headers_u1" corresponds to the unique index on FA_TRANSACTION_HEADERS, the primary source table beneath this view; querying the index directly is unnecessary when the view already exposes transaction_header_id as SOURCE_ID.