Results for “jl_co_fa_ael_sl_v”

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

Overview

JL_CO_FA_AEL_SL_V is an APPS-owned database view in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment, classified under the JL – Latin America Localizations product family. The view functions as a subledger accounting (SLA) reporting interface for Colombian fixed asset adjustments, presenting journal-line-level data in a structure compatible with the Oracle Subledger Accounting and General Ledger Accounting Event Line (AEL) model. Its name follows the AEL dictionary convention, indicating that it exposes accounted and entered debit/credit amounts, currency attributes, accounting dates, and transfer status flags suitable for downstream GL reconciliation and localization-specific reporting.

The view is a critical component for organizations operating Colombian localization requirements, where asset adjustments — including reserve adjustments and bonus-related movements — must be transformed into balanced accounting entries and reconciled against their GL transfer state. Because it combines fixed asset transaction data with adjustment and SLA structures, it serves both reporting consumers and integration processes that move localization data between Fixed Assets and the General Ledger.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, JL_CO_FA_AEL_SL_V is defined over the following base objects, all accessed through APPS synonyms except where noted:

• FA_ADDITIONS, FA_ADJUSTMENTS, 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
• GL_SETS_OF_BOOKS (referenced as a view)

The view is anchored on FA_ADJUSTMENTS (aliased as ADJ in the view text) and FA_TRANSACTION_HEADERS (aliased as TRX), with FA_BOOK_CONTROLS and GL_SETS_OF_BOOKS supplying set of books and currency context. Lookup meanings (L1 for the line reference, L3 for GL transfer status) are resolved through FA_LOOKUPS. The XLA tables (XLA_AE_HEADERS, XLA_AE_LINES, XLA_DISTRIBUTION_LINKS) provide the SLA accounting infrastructure that ties the FA adjustment to its accounting representation. The inclusion of the FA_INQUIRY_TRX_GT global temporary table indicates the view supports inquiry-driven transaction interrogation. JL_CO_FA_ADJUSTMENTS holds the Colombian localization-specific adjustment logic that differentiates reserve adjustments from standard adjustments, which is central to the DECODE expressions in the view text.

Key Columns

The view exposes accounting event columns in both accounted and entered denominations:

• ACCOUNTED_DR / ACCOUNTED_CR / ENTERED_DR / ENTERED_CR — Derived from ADJ.DEBIT_CREDIT_FLAG, ADJ.ADJUSTMENT_AMOUNT, and, for RESERVE type adjustments, a netting against ADJ_BONUS.ADJUSTMENT_AMOUNT. The sign logic determines whether an amount lands in the debit or credit column, ensuring balanced entries.
• ACCOUNTING_DATE — Sourced from TRX.TRANSACTION_DATE_ENTERED, the accounting date of the underlying transaction.
• AEL_TABLE — Hard-coded to 'ADJ', identifying the originating subledger table.
• AE_LINE_REFERENCE — Constructed from the lookup meaning (L1.MEANING) concatenated with the numeric TRANSACTION_HEADER_ID, providing a human-readable journal line reference.
• ACCT_LINE_TYPE / ACCT_LINE_TYPE_NAME — Both populated from ADJ.ADJUSTMENT_TYPE, classifying the accounting line (e.g., RESERVE).
• APPLICATION_ID — Fixed at 140, the Oracle Fixed Assets application identifier.
• CODE_COMBINATION_ID — The GL account combination from the adjustment.
• COMMENTS — The transaction name from FA_TRANSACTION_HEADERS.
• CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_USER_CONVERSION_TYPE — Currency context; conversion fields are nulled, reflecting that localized adjustment entries often use the book currency directly.
• GL_TRANSFER_STATUS / GL_TRANSFER_STATUS_NAME — Derived as 'Y' when ADJ.JE_HEADER_ID is populated, otherwise 'N', with the descriptive meaning from L3.
• SET_OF_BOOKS_ID — Sourced from FA_BOOK_CONTROLS, establishing the ledger/book association.

Common Use Cases and Queries

The view is principally used to audit and reconcile Colombian fixed asset adjustments against their GL transfer state, and to support SLA-based reporting for localization compliance. A typical reconciliation query retrieves untransferred adjustment lines for a given set of books:

SELECT ae_line_reference, acct_line_type_name, accounting_date,
       accounted_dr, accounted_cr, currency_code, gl_transfer_status_name
  FROM apps.jl_co_fa_ael_sl_v
 WHERE set_of_books_id = :p_sob_id
   AND gl_transfer_status = 'N'
 ORDER BY accounting_date;

A second common scenario aggregates accounted amounts by line type to validate that reserve and bonus adjustments net to the expected book balances:

SELECT acct_line_type_name,
       SUM(NVL(accounted_dr,0)) AS total_dr,
       SUM(NVL(accounted_cr,0)) AS total_cr
  FROM apps.jl_co_fa_ael_sl_v
 WHERE accounting_date BETWEEN :p_from AND :p_to
 GROUP BY acct_line_type_name;

Integrators may tie the view's AE_LINE_REFERENCE to XLA_AE_LINES and XLA_DISTRIBUTION_LINKS to trace an adjustment from the FA transaction header (the FA_TRANSACTION_HEADERS unique key referenced by the user search fa_transaction_headers_u1) through to its distribution and GL journal. The AEL_TABLE='ADJ' marker and APPLICATION_ID=140 constant make the view suitable as a source for custom AEL-style extracts feeding GL interface or localization reporting tables.