Search Results fa_group_assets




Overview
Explore in AI Chat

Overview

FA_GROUP_ASSETS is a core reference table in the Oracle E-Business Suite OFA – Assets module, residing in the FA schema. It contains group asset definitions, storing the flexfield and general descriptive information used to organize individual assets into groups for collective depreciation and accounting treatment. Group assets are a mandatory construct when an organization uses group‑based (member) depreciation, where members inherit depreciation attributes from their assigned group. Each row in the table represents a single group asset, keyed by the surrogate primary key GROUP_ASSET_ID (index FA_GROUP_ASSETS_U1).

In Data Vault modeling terms, the metadata’s heuristic classification indicates this table is standalone — effectively a reference or hub‑like entity, with no parent foreign keys but referenced by numerous transactional and summary tables. This suggests modeling the group asset as a hub/reference table with an associated satellite for descriptive attributes (description, flags, dates).

Key Information Stored

The most significant columns are:

Common Use Cases and Queries

Typical scenarios include listing active group assets, resolving a member book’s group membership, and reporting depreciation balances aggregated at the group level. A representative query joins the group definition to its associated books:

  • Listing enabled groups: SELECT GROUP_ASSET_ID, CONCATENATED_SEGMENTS, DESCRIPTION FROM FA_GROUP_ASSETS WHERE ENABLED_FLAG='Y' AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,SYSDATE);
  • Group‑asset assignment per book: join FA_BOOKS to FA_GROUP_ASSETS on GROUP_ASSET_ID to see which group each asset (book) belongs to.
  • Depreciation summaries: join FA_BOOKS_SUMMARY_T or FA_MC_GROUP_DEPRN_SUMMARY to the group definition to report balances by group asset.

These queries support reconciliation, group depreciation reporting, and mass addition/retirement validation.

Related Objects

Numerous child tables reference FA_GROUP_ASSETS.GROUP_ASSET_ID, most notably:

Together, these dependencies establish FA_GROUP_ASSETS as the central reference point for group‑level asset processing in Oracle Assets 12.1.1 and 12.2.2.