Search Results fa_books_groups




Overview
Explore in AI Chat

Overview

FA_BOOKS_GROUPS is a table in the Oracle Assets (OFA) module of Oracle E-Business Suite, owned by the FA schema. As documented in the ETRM metadata for releases 12.1.1 and 12.2.2, it contains financial (cost) information for a group asset within a particular depreciation book and functions as a historical table, preserving the time-phased cost and valuation attributes that a group asset carries across accounting periods. Group assets in Oracle Assets aggregate the financial behavior of multiple member assets, and FA_BOOKS_GROUPS serves as the authoritative record of the group's cost basis, salvage, recoverable value, and retirement position for each book in which it is defined.

From a Data Vault modeling perspective, the FK structure mined for this table yields a classification of standalone. In practice the object behaves as a satellite attached to the FA_GROUP_ASSETS hub, keyed by GROUP_ASSET_ID and BOOK_TYPE_CODE, with effective dating provided by DATE_EFFECTIVE and PERIOD_COUNTER. This interpretation is offered as a heuristic suggestion rather than a documented constraint.

Key Information Stored

The table is documented with 55 columns in the 12.2.2 schema. The most operationally significant include:

Common Use Cases and Queries

Typical usage includes group asset cost reconciliation, effective-dated cost history reporting, and retirement/ITC impact analysis. A representative query retrieves the current effective cost row for a group asset:

  • SELECT group_asset_id, book_type_code, cost, adjusted_cost, salvage_value FROM fa.fa_books_groups WHERE group_asset_id = :id AND book_type_code = :book AND date_ineffective IS NULL;
  • Joining to FA_GROUP_ASSETS to report group names alongside their book-level costs.
  • Auditing historical cost changes by comparing rows ordered by DATE_EFFECTIVE and PERIOD_COUNTER.
  • Identifying groups with RETIREMENT_PENDING_FLAG set for retirement processing.

Related Objects

  • FA_GROUP_ASSETS – referenced via GROUP_ASSET_ID; the parent group asset definition.
  • FA_ITC_RATES – referenced via ITC_AMOUNT_ID; supplies investment tax credit rate information.
  • FA_RETIREMENTS – referenced via RETIREMENT_ID; holds retirement transaction detail.
  • FA_BOOKS – the asset-level counterpart providing book cost information for individual assets.
  • FA_BOOK_CONTROLS – defines the books referenced by BOOK_TYPE_CODE.
  • FA_DEPRN_SUMMARY – provides depreciation balances for the group across periods.