Results for “fa_deprn_web_v”

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

Overview

FA_DEPRN_WEB_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Oracle Assets (OFA) module. Its documented purpose is to present depreciation information for an asset within a given depreciation book, consolidating cost, period, and accounting distribution data into a single denormalized result set. The view is designed primarily for inquiry and reporting purposes, including the Oracle Assets web-based depreciation and asset inquiry pages, where an asset's depreciation amounts, revaluation amortization, and their associated accounting flexfield combinations must be surfaced together.

Because the view flattens data drawn from several Assets base tables and Oracle General Ledger objects, it enables report authors and integration developers to retrieve depreciation detail without manually joining FA_ADDITIONS, FA_DEPRN_DETAIL, FA_DEPRN_PERIODS, and the KFV accounting views. Its use of CONCATENATED_SEGMENTS from the key flexfield views makes it especially relevant to users searching for GL_CODE_COMBINATIONS_KFV, since the view already denormalizes the accounting flexfield into a single readable string.

Underlying Base Objects

The ETRM metadata documents the following referenced objects: FA_ADDITIONS, FA_ADJUSTMENTS, FA_BOOK_CONTROLS, FA_CATEGORIES_B_KFV, FA_DEPRN_DETAIL, FA_DEPRN_PERIODS, FA_DISTRIBUTION_HISTORY, FND_CURRENCY, GL_CODE_COMBINATIONS_KFV, and GL_SETS_OF_BOOKS. With the exception of FA_CATEGORIES_B_KFV, GL_CODE_COMBINATIONS_KFV, GL_SETS_OF_BOOKS (views) and FND_CURRENCY (package), these are accessed through synonyms.

FA_ADDITIONS supplies the asset identity, number, and description. FA_DEPRN_DETAIL and FA_ADJUSTMENTS provide the depreciation and adjustment amounts that are aggregated. FA_DEPRN_PERIODS supplies the period name and counter, while FA_BOOK_CONTROLS and GL_SETS_OF_BOOKS link each book to its set of books and functional currency. FA_DISTRIBUTION_HISTORY joins each depreciation row to its accounting distribution, and GL_CODE_COMBINATIONS_KFV resolves the CODE_COMBINATION_ID into a concatenated account string. FA_CATEGORIES_B_KFV supplies the concatenated asset category key flexfield. FND_CURRENCY.SAFE_GET_FORMAT_MASK applies the correct currency format mask to the summed amounts.

Key Columns

• ASSET_ID / ASSET_NUMBER / DESCRIPTION — asset identifiers from FA_ADDITIONS.
• BOOK_TYPE_CODE — the depreciation book for the row.
• PERIOD_COUNTER / PERIOD_ENTERED — the depreciation period identifier and its display name.
• DEPRN_AMOUNT — the summed depreciation amount (or net adjustment expense), converted to a formatted character value.
• REVAL_AMORTIZATION — the summed revaluation amortization amount.
• CATEGORY — the concatenated asset category flexfield (from FA_CATEGORIES_B_KFV).
• ACCOUNTING_CONCATENATED — the concatenated accounting flexfield string derived from GL_CODE_COMBINATIONS_KFV, exposing the GL code combination for each distribution.

Common Use Cases and Queries

Typical applications include asset depreciation inquiry reports, reconciliation of depreciation to GL account combinations, and interfaces that extract book-level depreciation with its accounting distribution. Because the view exposes ACCOUNTING_CONCATENATED, it is frequently used for reporting on depreciation by GL account without a separate join to GL_CODE_COMBINATIONS_KFV.

A representative query retrieves depreciation for a specific book and period:

• SELECT asset_number, book_type_code, period_entered, deprn_amount, accounting_concatenated FROM fa_deprn_web_v WHERE book_type_code = :book AND period_counter = :period ORDER BY asset_number;
• SELECT accounting_concatenated, SUM(TO_NUMBER(deprn_amount)) FROM fa_deprn_web_v WHERE book_type_code = :book GROUP BY accounting_concatenated;

When filtering, note that DEPRN_AMOUNT and REVAL_AMORTIZATION are returned as formatted character strings, so numeric aggregation requires an explicit TO_NUMBER conversion. Because the view text is a UNION of depreciation detail and adjustment expense rows, consumers should account for the possibility of multiple rows per asset, book, and period when building reports or interfaces.