Search Results fa_mc_books_groups




Overview
Explore in AI Chat

Overview

FA_MC_BOOKS_GROUPS is a table in the Oracle Assets (OFA) module, owned by the FA schema. It stores the multi-currency (MC) grouped asset book information for group assets across multiple depreciation books. It maintains a record for each combination of a group asset and a book (group asset ID and book type code), holding the cost, recoverable cost, salvage value, and related depreciation/retirement fields required for group asset book maintenance.

The table is documented in ETRM for both Oracle EBS 12.1.1 and 12.2.2, with 57 columns in the documented 12.2.2 physical schema. Based on the dependency structure, the heuristic Data Vault classification is standalone — this suggests it is best modeled as its own satellite-like structure rather than being split into hubs and links, though individual implementations may vary.

Key Information Stored

The table has no single-column surrogate primary key defined in the metadata; the effective business key is the combination of SET_OF_BOOKS_ID, GROUP_ASSET_ID, and BOOK_TYPE_CODE, which together identify a group asset within a specific book.

Common Use Cases and Queries

Key use cases include group asset depreciation reporting, cost reconciliation, and retirement analysis. A typical reporting query joins the table to FA_GROUP_ASSETS to obtain the group asset name:

  • Query group asset book costs by book: SELECT g.group_asset_id, gb.set_of_books_id, gb.book_type_code, gb.cost, gb.recoverable_cost FROM fa.fa_mc_books_groups gb, fa.fa_group_assets g WHERE gb.group_asset_id = g.group_asset_id;
  • Retirement and proceeds reporting filtered by RETIREMENT_PENDING_FLAG = 'Y'.
  • Reconciling ITC amounts referenced by ITC_AMOUNT_ID to FA_ITC_RATES.
  • Identifying group assets with pending cost changes via COST_CHANGE_FLAG.
  • Multi-book comparisons using SET_OF_BOOKS_ID across records sharing a GROUP_ASSET_ID.

Because there is no documented unique index beyond the effective business key, reports should filter on SET_OF_BOOKS_ID, GROUP_ASSET_ID, and BOOK_TYPE_CODE to retrieve an exact record.

Related Objects

The following are the most significant related objects based on the documented foreign key relationships:

  • FA_GROUP_ASSETS — referenced via GROUP_ASSET_ID; the parent group asset definition.
  • FA_ITC_RATES — referenced via ITC_AMOUNT_ID; provides investment tax credit rates.
  • FA_RETIREMENTS — referenced via RETIREMENT_ID; provides retirement transaction details.
  • FA_BOOK_CONTROLS — for book definition context through SET_OF_BOOKS_ID and BOOK_TYPE_CODE.
  • FA_ADDITIONS_B and FA_ADDITIONS_T — for related asset addition information.
  • FA_DEPRN_SUMMARY — for depreciation comparatives against group asset book records.
  • FA_TRANSACTION_HEADERS — referenced through the transaction header ID columns.