Search Results fa_group_asset_rules




Overview
Explore in AI Chat

Overview

FA_GROUP_ASSET_RULES is a table in the OFA (Oracle Assets) product schema of Oracle E-Business Suite, owned by the FA schema. It defines the depreciation rules that govern how a group asset is depreciated within a particular asset book. Group assets allow multiple member assets to share a single depreciation ruleset and a consolidated cost basis, and this table is the authoritative record of the method, life, prorate conventions, and limits applied to the group. Critically, the object is described as a history table: rows are effective-dated, so changes to a group asset's depreciation setup over time are preserved rather than overwritten, enabling accurate retroactive and period-by-period recalculation. The table is present and valid in both EBS 12.1.1 and 12.2.2, with a documented physical schema of 36 columns in the 12.2.2 ETRM reference.

The supplied metadata classifies this object heuristically as a standalone Data Vault entity. This classification reflects the absence of mined foreign-key relationships in the reference material and should be treated as a modeling suggestion rather than a definitive architectural assertion. In Data Vault terms, the effective-dated, descriptive nature of the depreciation attributes suggests a satellite-like role anchored to a hub of group assets by the business key, while the physical Oracle implementation presents it as a single denormalized table keyed by its unique index.

Key Information Stored

The primary key is defined by the unique index FA_GROUP_ASSET_RULES_U1, composed of GROUP_ASSET_ID, BOOK_TYPE_CODE, and DATE_EFFECTIVE. These three columns constitute the composite business key: they identify which group asset the rule belongs to, the depreciation book in which it applies, and the date from which the rule version takes effect. DATE_INEFFECTIVE provides the closing boundary of each effective-dated version, allowing point-in-time reconstruction of the rule set.

The most operationally significant columns fall into several groups:

Common Use Cases and Queries

Typical use cases include verifying the active depreciation rules for a group asset in a given book, reconstructing historical rule versions for audit or reconciliation, and diagnosing depreciation calculation discrepancies. A common query pattern retrieves the effective row as of a chosen date:

  • SELECT * FROM fa_group_asset_rules WHERE group_asset_id = :p_group AND book_type_code = :p_book AND :p_as_of BETWEEN date_effective AND NVL(date_ineffective, SYSDATE);
  • Reporting the full change history for a group: SELECT group_asset_id, book_type_code, date_effective, date_ineffective, deprn_method_code, life_in_months FROM fa_group_asset_rules WHERE group_asset_id = :p_group ORDER BY date_effective;
  • Identifying groups using a specific method: SELECT group_asset_id, book_type_code FROM fa_group_asset_rules WHERE deprn_method_code = :p_method;

Related Objects

The table is anchored to group assets and books, and it interacts with the core depreciation engine rather than acting as a child of a typical master-detail hierarchy.