Search Results trx_hdr_table




Overview
Explore in AI Chat

Overview

The view APPS.JL_CO_FA_AEL_GL_V is a Latin America Localizations (JL) reporting object that exposes asset adjustment accounting entries in a format compatible with the Oracle Subledger Accounting (SLA) / Accounting Events Line (AEL) model. It is defined in the APPS schema with VALID status in both EBS 12.1.1 and 12.2.2. The view is designed to present Fixed Assets adjustment transactions as accounting lines carrying the standard AEL column set — ACCOUNTED_DR, ACCOUNTED_CR, ENTERED_DR, ENTERED_CR, ACCOUNTING_DATE, AE_LINE_REFERENCE, GL_TRANSFER_STATUS, SET_OF_BOOKS_ID, and related attributes — so that localizations in Colombia and other Latin American countries can report asset adjustments alongside GL-relevant accounting information.

The view assigns APPLICATION_ID = 140 (Fixed Assets) and sets AEL_TABLE = 'ADJ', TRX_CLASS = 'TRANSACTION', and TRX_HDR_TABLE = 'TH', anchoring the rows to the Fixed Assets adjustments source. Because the column TRX_TYPE_NAME is exposed, users searching on this term typically do so to obtain the human-readable transaction type for an adjustment line, sourced from FA_LOOKUPS.MEANING concatenated with the transaction header identifier.

Underlying Base Objects

The view is defined over the following documented objects (all as synonyms in the APPS schema, except GL_SETS_OF_BOOKS, which is a view):

  • JL_CO_FA_ADJUSTMENTS — aliased ADJ; primary source of adjustment amount, debit/credit flag, adjustment type, code combination, JE header, and audit columns.
  • FA_TRANSACTION_HEADERS — aliased TH; supplies transaction date, transaction name, transaction type code, asset ID, and book type code.
  • FA_ADJUSTMENTS — the underlying Fixed Assets adjustments table.
  • FA_ADDITIONS — aliased AD; provides asset number and description.
  • FA_BOOK_CONTROLS — aliased BC; supplies SET_OF_BOOKS_ID.
  • FA_LOOKUPS — aliased L1, L3; resolves lookup meanings for transaction type and GL transfer status.
  • FA_SYSTEM_CONTROLS — aliased SYS; provides the asset category flex structure.
  • FA_ASSET_HISTORY, GL_IMPORT_REFERENCES, and GL_SETS_OF_BOOKS — supporting joins for history, import reference links, and currency code derivation (via SOB.CURRENCY_CODE).

Key Columns

Common Use Cases and Queries

Typical usage includes reconciliation of asset adjustments to GL, review of unposted adjustment lines, and Latin America localization reporting that requires AEL-shaped output. A representative query filtering on the searched term follows:

SELECT trx_type_name,
       asset_number,
       trx_date,
       accounted_dr,
       accounted_credit,
       gl_transfer_status_name
FROM   apps.jl_co_fa_ael_gl_v
WHERE  trx_type_name LIKE '%ADJUST%'
AND    set_of_books_id = :p_sob_id;

Filtering on gl_transfer_status_name isolates adjustments not yet transferred to GL, while joining source_id to fa_transaction_headers supports drill-down. Because the view surfaces TRX_TYPE_NAME directly, it is frequently the fastest route to readable transaction-type descriptions for asset adjustments in Latin American ledgers.