Search Results fa_super_group_rules_u1

Overview

The FA_SUPER_GROUP_RULES table is a core data object within the Oracle E-Business Suite Fixed Assets (OFA) module. It serves as the master repository for defining and storing the specific depreciation rules that govern asset groups which are members of a super group. A super group is a logical collection of asset groups, allowing for consolidated depreciation processing and reporting. This table's primary role is to establish the authoritative link between a super group, an asset book, and the precise set of depreciation rules that become effective on a given date, thereby enabling centralized and standardized depreciation calculations across multiple related asset groups.

Key Information Stored

The table's structure is defined by its composite primary key, which dictates the critical business information it holds. The key columns are SUPER_GROUP_ID, BOOK_TYPE_CODE, and DATE_EFFECTIVE. SUPER_GROUP_ID identifies the specific super group to which the rule applies. BOOK_TYPE_CODE specifies the asset book (e.g., Corporate, Tax) for which the rule is valid. DATE_EFFECTIVE is the date from which the associated depreciation rule becomes active, supporting the maintenance of a historical record of rule changes. While the provided metadata does not list non-key columns, based on its described purpose, the table would also store rule identifiers or parameters that define the depreciation method, life, convention, and other calculation controls applicable to member asset groups.

Common Use Cases and Queries

This table is central to depreciation processing for super groups. A primary use case is the batch depreciation run, where the system queries this table to determine the correct rules for all assets within the super group's member asset groups for a given period and book. Common reporting needs include auditing the active depreciation rules for a super group or tracking changes to those rules over time. A typical query pattern involves joining to the FA_BOOK_CONTROLS table on BOOK_TYPE_CODE and filtering by SUPER_GROUP_ID and a specific date to find the effective rule.

SELECT fsgr.*
FROM fa_super_group_rules fsgr
WHERE fsgr.super_group_id = :p_super_group_id
  AND fsgr.book_type_code = :p_book_type_code
  AND :p_date BETWEEN fsgr.date_effective
      AND NVL(fsgr.date_ineffective, SYSDATE);

Related Objects

The FA_SUPER_GROUP_RULES table maintains a direct relationship with the FA_SUPER_GROUPS table via the SUPER_GROUP_ID column, which is part of its primary key. The documented primary key constraint, FA_SUPER_GROUP_RULES_U1, enforces uniqueness on the combination of (SUPER_GROUP_ID, BOOK_TYPE_CODE, DATE_EFFECTIVE). This table is a foundational reference for depreciation engines and reporting views within Fixed Assets. It is logically referenced by objects that process asset group depreciation, and it would be joined to asset transaction tables (like FA_DEPRN_DETAIL) through intermediary relationships involving the member asset groups and their individual assets.