Search Results fa_super_groups




Overview
Explore in AI Chat

Overview

The FA_SUPER_GROUPS table is a core data object within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It serves as the master repository for defining and storing super group definitions. A super group is a logical classification used to aggregate assets for specific reporting, depreciation, and processing purposes, such as group depreciation. The table's primary role is to maintain the descriptive and structural information for these super groups, acting as a parent reference for asset book assignments. Its integrity is critical for the accurate grouping and subsequent financial processing of fixed assets.

Key Information Stored

The table stores the fundamental definition of each super group. While the full column list is not detailed in the provided metadata, the structure typically includes a system-generated primary key, descriptive fields, and key flexfield columns. Based on the documented primary key and standard EBS design, the most critical columns include:

  • SUPER_GROUP_ID: The unique system-generated identifier (primary key) for the super group definition.
  • SUPER_GROUP_NAME or similar descriptive columns: Holds the name and description of the super group for identification.
  • Flexfield Segments: The table contains the key flexfield structure (commonly the Asset Key Flexfield) that allows for customizable, segment-based coding of the super group to align with organizational accounting practices.
  • Additional columns likely include creation date, last update date, created by, and other standard EBS audit columns.

Common Use Cases and Queries

This table is central to operations involving asset groups. Common use cases include generating reports on assets by super group, configuring group depreciation rules, and validating asset assignments. Administrators and developers query this table to list existing super groups or to find specific assets belonging to a group. A typical query retrieves super group details along with associated asset books:

SELECT fsg.super_group_id,
       fsg.super_group_name,
       fb.asset_id,
       fb.book_type_code
FROM   fa_super_groups fsg,
       fa_books fb
WHERE  fb.super_group_id = fsg.super_group_id
AND    fb.date_ineffective IS NULL;

Another common pattern is to query the table directly for a list of all defined super groups for setup or audit purposes.

Related Objects

As indicated by the foreign key relationships in the metadata, FA_SUPER_GROUPS is a key reference table for several major asset transaction tables. The primary related objects are:

  • FA_BOOKS: The main table for asset book controls. Its SUPER_GROUP_ID column is a foreign key to FA_SUPER_GROUPS, linking each asset book to its assigned super group.
  • FA_BOOKS_SUMMARY: The summary table for asset books. It also references FA_SUPER_GROUPS via the SUPER_GROUP_ID column to maintain summary data by group.
  • FA_MC_BOOKS: The table for multiple currency book information. It references FA_SUPER_GROUPS to maintain super group assignments in reporting currencies.

These relationships ensure that any asset assigned to a super group in its primary, summary, or reporting currency book consistently references a valid definition in FA_SUPER_GROUPS.