Search Results fa_group_assets_u1

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:

• GROUP_ASSET_ID — the surrogate primary key; not a business key.
• ID_FLEX_NUM — internal identifier binding the row to the group asset key flexfield structure.
• SEGMENT1 through SEGMENT7 — the individual flexfield segments forming the group asset name (business‑key candidates when combined).
• CONCATENATED_SEGMENTS — the fully concatenated, user‑facing group asset name.
• DESCRIPTION — free‑text description of the group.
• SUMMARY_FLAG — indicates whether the segment value is a summary (roll‑up) entry.
• ENABLED_FLAG — controls whether the group asset is active for use.
• START_DATE_ACTIVE / END_DATE_ACTIVE — validity range of the group asset.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

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:

• FA_BOOKS (GROUP_ASSET_ID) — per‑book asset/group linkage.
• FA_BOOKS_SUMMARY_T and FA_BOOKS_GROUPS — book‑level group membership.
• FA_MC_BOOKS, FA_MC_BOOKS_SUMMARY, FA_MC_BOOKS_GROUPS — multiple reporting book equivalents.
• FA_MC_GROUP_DEPRN_SUMMARY and FA_MC_GROUP_DEPRN_DETAIL — group depreciation results.
• FA_MASS_ADDITIONS / FA_MASS_RETIREMENTS — mass transactions targeting group assets.
• FA_ADJUSTMENTS_T, FA_BALANCES_REPORT, and XLA extension/staging tables (e.g., FA_XLA_EXT_LINES_B_GT).

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.