Results for “fa_books_v”

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

Overview

FA_BOOKS_V is a seeded Oracle E-Business Suite view owned by the APPS schema within the OFA - Assets (Oracle Assets / Fixed Assets) product. Its documented purpose is to select active financial information for an asset in a given book. In Oracle Assets, depreciation and financial attributes are not stored on a single monolithic asset record; instead an asset may exist simultaneously across multiple depreciation books (for example a corporate book and a tax book), each with its own cost, method, life, and status. FA_BOOKS_V presents that per-book, per-asset financial picture in a normalized, read-only form.

Because the view joins the core asset-book table to book controls and depreciation method definitions, it exposes not only the stored financial values but also configuration-driven attributes such as whether revaluation is permitted and which rate and depreciation basis rules apply. This makes it a convenient reporting and integration layer: rather than re-implementing the underlying joins, developers, report writers (BI Publisher, Oracle Reports, Discoverer), and interface programs can query a single object that reflects the active financial state of an asset within a book. Its status is VALID and it is present in the APPS schema for the 12.1.1 and 12.2.2 release levels.

Underlying Base Objects

Per the ETRM view metadata, FA_BOOKS_V is defined over three referenced base objects, all referenced through APPS synonyms:

• FA_BOOKS — the primary source; the alias BK in the view text supplies the bulk of financial columns (cost, dates, method, life, counters, and the global attribute flexfield).
• FA_BOOK_CONTROLS — alias BC; used to derive the ALLOW_REVAL_FLAG column via a DECODE on ALLOW_REVAL_FLAG ('YES' becomes 'Y', otherwise 'N').
• FA_METHODS — alias MTH; supplies RATE_SOURCE_RULE and DEPRN_BASIS_RULE for the asset's depreciation method.

The view also returns BK.ROWID as ROW_ID, giving each row a row identifier consistent with the underlying fa_books record. Conceptually it is a projection of FA_BOOKS enriched by book-level and method-level configuration, so it inherits FA_BOOKS one-row-per-asset-per-book granularity. The view text continues beyond the excerpt (for example BK.ORIGINAL..., indicating further columns are defined in the full definition).

Key Columns

• BOOK_TYPE_CODE / ASSET_ID / ROW_ID — identify the asset and the depreciation book; form the natural key for lookups.
• COST, ORIGINAL_COST, ADJUSTED_COST, UNREVALUED_COST, SALVAGE_VALUE, PERCENT_SALVAGE_VALUE — the cost and salvage basis values used in depreciation.
• DEPRN_METHOD_CODE, BASIC_RATE, ADJUSTED_RATE, LIFE_IN_MONTHS, RATE_ADJUSTMENT_FACTOR, ALLOWED_DEPRN_LIMIT, ALLOWED_DEPRN_LIMIT_AMOUNT, BONUS_RULE, CEILING_NAME, RECOVERABLE_COST, ADJUSTED_RECOVERABLE_COST — depreciation and tax rule attributes.
• DATE_PLACED_IN_SERVICE, DATE_EFFECTIVE, DEPRN_START_DATE, DATE_INEFFECTIVE, CONVERSION_DATE, PRORATE_CONVENTION_CODE, PRORATE_DATE — dates governing when the asset is active and how depreciation prorates.
• CAPITALIZE_FLAG, DEPRECIATE_FLAG, IDLED_FLAG, RETIREMENT_PENDING_FLAG, ADJUSTMENT_REQUIRED_STATUS, COST_CHANGE_FLAG — status and lifecycle flags.
• PERIOD_COUNTER_CAPITALIZED, PERIOD_COUNTER_FULLY_RESERVED, PERIOD_COUNTER_FULLY_RETIRED, PERIOD_COUNTER_LIFE_COMPLETE — period counters marking depreciation milestones.
• ALLOW_REVAL_FLAG, REVAL_CEILING, REVAL_AMORTIZATION_BASIS — revaluation eligibility and basis, with ALLOW_REVAL_FLAG derived from book controls.
• RATE_SOURCE_RULE, DEPRN_BASIS_RULE — sourced from FA_METHODS.
• GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1-20 — descriptive flexfield storage.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns populated by the application.

Common Use Cases and Queries

Typical uses include asset register reporting, reconciliation between corporate and tax books, depreciation-method analysis, and integration extracts that require per-book financial attributes. The sample below lists active book detail for an asset.

• Asset-to-book financial extract: SELECT asset_id, book_type_code, cost, adjusted_cost, deprn_method_code, life_in_months FROM fa_books_v WHERE asset_id = :asset_id;
• Book-level cost and salvage reconciliation: SELECT book_type_code, SUM(cost), SUM(salvage_value) FROM fa_books_v GROUP BY book_type_code;
• Method and rule analysis: SELECT deprn_method_code, rate_source_rule, deprn_basis_rule, COUNT(*) FROM fa_books_v GROUP BY deprn_method_code, rate_source_rule, deprn_basis_rule;
• Revaluation eligibility check: SELECT asset_id, book_type_code, allow_reval_flag, reval_ceiling FROM fa_books_v WHERE allow_reval_flag = 'Y';
• Idled and pending-retirement monitoring: SELECT asset_id, book_type_code FROM fa_books_v WHERE idled_flag = 'Y' OR retirement_pending_flag = 'Y';

Because the view is defined over the FA synonym layer, queries should generally be schema-qualified as APPS.FA_BOOKS_V when executed outside the APPS context.