Search Results asset_category_flex_structure




Overview
Explore in AI Chat

Overview

APPS.FA_AEL_GL_V is a reporting view in the Oracle E-Business Suite Fixed Assets module that consolidates the accounting events generated by asset transactions into a single, query-friendly structure suitable for General Ledger reconciliation, subledger reporting, and integration with downstream systems. The view is owned by the APPS schema and is registered in FND Design Data as OFA.FA_AEL_GL_V, with a reported status of VALID. Its primary role is to expose the accounting event lines produced by the Fixed Assets Accounting Events (AEL) model, enriched with descriptive names for code-based columns and denormalized asset, book, and transaction context.

Because it resolves values such as the accounting line type, transaction class, and GL transfer status into their human-readable names, FA_AEL_GL_V is particularly useful where a reporting layer must present meaningful labels without repeatedly joining to the FA_LOOKUPS and FA_LOOKUPS_TL tables. It also carries both the entered and accounted debit/credit amounts, allowing report writers to reconcile transaction currency with functional currency balances.

Underlying Base Objects

The view is defined over a set of Fixed Assets base objects and descriptive tables. The documented referenced objects are:

  • FA_ADDITIONS (SYNONYM) — asset master rows providing asset number, description, and key flexfield references.
  • FA_ADJUSTMENTS (SYNONYM) — adjustment transaction lines that generate accounting events.
  • FA_ASSET_HISTORY (SYNONYM) — historical asset transaction activity.
  • FA_BOOK_CONTROLS (SYNONYM) — book-level control information used to derive set of books context.
  • FA_LOOKUPS (SYNONYM) and FA_LOOKUPS_TL (SYNONYM) — lookup codes and their translated descriptions, used to resolve documented *_NAME columns.
  • FA_MC_ADJUSTMENTS (SYNONYM) and FA_MC_BOOK_CONTROLS (SYNONYM) — the multi-currency counterparts to the adjustments and book controls, supporting reporting across reporting sets of books.
  • FA_SYSTEM_CONTROLS (SYNONYM) — system-level Fixed Assets configuration.
  • FA_TRANSACTION_HEADERS (SYNONYM) — transaction header records that group transaction lines.
  • GL_SETS_OF_BOOKS (VIEW) — the General Ledger set of books view, supplying the accounting set of books context.

The view therefore sits on top of the Fixed Assets transaction and asset model, bridging it to the General Ledger set of books definition. It does not store data itself; all values are derived at query time from these base objects.

Key Columns

The view exposes a wide set of columns that can be grouped functionally. The asset-related columns include ASSET_ID, ASSET_NUMBER, ASSET_DESCRIPTION, ASSET_BOOK_TYPE_CODE, ASSET_CATEGORY_ID, ASSET_CATEGORY_FLEX_STRUCTURE, ASSET_KEY_FLEX_STRUCTURE, and ASSET_KEY_CCID. Notably, ASSET_CATEGORY_FLEX_STRUCTURE and ASSET_KEY_FLEX_STRUCTURE identify the flexfield structures governing the asset category and asset key flexfields, which is directly relevant to queries that must interpret category or key flexfield segments.

Accounting columns include ACCOUNTED_DR, ACCOUNTED_CR, ENTERED_DR, ENTERED_CR, CODE_COMBINATION_ID, ACCOUNTING_DATE, ACCT_LINE_TYPE, and ACCT_LINE_TYPE_NAME. Currency columns include CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, and CURRENCY_USER_CONVERSION_TYPE. Transfer and source columns include GL_TRANSFER_STATUS, GL_TRANSFER_STATUS_NAME, AEL_TABLE, SOURCE_TABLE, SOURCE_ID, AE_LINE_REFERENCE, TRX_CLASS, TRX_CLASS_NAME, TRX_HDR_ID, TRX_HDR_TABLE, TRX_NUMBER_DISPLAYED, TRX_NUMBER_N, TRX_TYPE_C, TRX_TYPE_NAME, TRX_DATE, JE_HEADER_ID, and JE_LINE_NUM. Audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN are also present.

Common Use Cases and Queries

Typical use cases include GL reconciliation of Fixed Assets activity, subledger accounting event reporting, identification of events not yet transferred to GL, and category flexfield structure analysis.

A representative query that filters on the category flexfield structure is:

  • SELECT asset_number, asset_description, asset_category_id, asset_category_flex_structure, accounted_dr, accounted_cre, accounting_date, gl_transfer_status_name FROM apps.fa_ael_gl_v WHERE set_of_books_id = :p_sob AND asset_category_flex_structure = :p_cat_structure;

To identify GL transfers still pending:

  • SELECT trx_number_displayed, trx_class_name, gl_transfer_status_name, entered_dr, entered_cr FROM apps.fa_ael_gl_v WHERE gl_transfer_status_name <> 'Transferred';

Because the view resolves lookup names and exposes both entered and accounted amounts, it reduces the number of joins required in custom reports and is well suited to ad hoc analysis against the Fixed Assets accounting events.