Search Results fa_mc_group_deprn_summary




Overview
Explore in AI Chat

Overview

FA_MC_GROUP_DEPRN_SUMMARY is a Multi-Currency (MC) depreciation summary table within the Oracle Assets (OFA) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores periodic depreciation results for group assets — as distinct from the more commonly referenced FA_DEPRN_SUMMARY, which covers individual assets. The table resides in the FA schema and is classified as VALID in the ETRM repository. Its documented physical schema at 12.2.2 comprises 22 columns, and it carries a foreign key on GROUP_ASSET_ID referencing FA_GROUP_ASSETS.

The "MC" prefix reflects the multi-reporting-currency context: alongside the primary functional-currency amounts held in the standard depreciation summary, this table retains converted or reporting-currency balances (notably carried by attributes such as CONVERTED_FLAG) so that depreciation can be presented in secondary currencies. It is a periodic, dated snapshot rather than a master record.

From a heuristic Data Vault perspective, the metadata classifies this object as standalone — it is not identified as part of a hub/link/satellite chain in the mined FK structure. As a modeling suggestion, it is most naturally treated as a satellite: a dated, descriptive store of depreciation measures keyed to a parent group asset, with little to no dependent child objects of its own. This classification should be validated against actual integrity constraints before use in any warehouse design.

Key Information Stored

Rather than enumerating all 22 columns, the following represent the most operationally significant attributes:

  • SET_OF_BOOKS_ID and BOOK_TYPE_CODE — the accounting book (and its tax/corporate type) in which the depreciation was computed. These are the leading business-key candidates used in virtually every query.
  • GROUP_ASSET_ID — the foreign-key pointer to FA_GROUP_ASSETS; this is the parent business key that ties the summary row to a specific group asset.
  • DEPRN_RUN_DATE and PERIOD_COUNTER — the effective date and period identifier of the depreciation run, providing the time dimension.
  • DEPRN_AMOUNT — the period (current-run) depreciation expense amount.
  • YTD_DEPRN and DEPRN_RESERVE — year-to-date depreciation and the accumulated depreciation reserve carried forward.
  • ADJUSTED_COST — the cost basis against which depreciation is calculated.
  • DEPRN_SOURCE_CODE and DEPRN_RATE — the origin of the calculation and the applied rate.
  • BONUS_RATE — applicable where bonus depreciation rules are in effect.
  • PRODUCTION, YTD_PRODUCTION, and LTD_PRODUCTION — physical usage measures for units-of-production depreciation.
  • REVAL_AMORTIZATION, REVAL_AMORTIZATION_BASIS, REVAL_DEPRN_EXPENSE, REVAL_RESERVE, and YTD_REVAL_DEPRN_EXPENSE — the family of revaluation-related balances that reconcile the summary for revalued assets.
  • PRIOR_FY_EXPENSE — the prior fiscal-year expense figure, used in roll-forward reporting.
  • CONVERTED_FLAG — indicates whether the row has been converted/translated into a reporting currency, which is the defining marker of the MC table.

The surrogate identity is the composite of the book, group asset, and period/run; the FK to FA_GROUP_ASSETS is the only documented referential link.

Common Use Cases and Queries

Because group assets aggregate many member assets, this table is the standard source for period-end group depreciation reporting without the need to sum individual asset rows. Typical patterns include:

  • Period depreciation roll-forward — extracting DEPRN_AMOUNT, YTD_DEPRN, and DEPRN_RESERVE for a book and period.
  • Reconciliation of revaluation balances — comparing REVAL_DEPRN_EXPENSE and REVAL_RESERVE against the general ledger.
  • Multi-currency reporting — filtering on CONVERTED_FLAG to obtain translated balances.
  • Group asset trend analysis — joining to FA_GROUP_ASSETS for group descriptions and tracking YTD_DEPRN over PERIOD_COUNTER.

A representative query:

  • SELECT g.group_asset_id, s.book_type_code, s.period_counter, s.deprn_amount, s.ytd_deprn, s.deprn_reserve FROM fa_mc_group_deprn_summary s JOIN fa_group_assets g ON g.group_asset_id = s.group_asset_id WHERE s.set_of_books_id = :book AND s.period_counter = :period;

Reports typically restrict on BOOK_TYPE_CODE and SET_OF_BOOKS_ID, then aggregate by DEPRN_RUN_DATE or PERIOD_COUNTER.

Related Objects

  • FA_GROUP_ASSETS — the directly referenced parent (GROUP_ASSET_ID → GROUP_ASSET_ID); the primary join target.
  • FA_DEPRN_SUMMARY — the asset-level counterpart, useful for drill-down and reconciliation to detail.
  • FA_BOOK_CONTROLS — defines the book and depreciation conventions for SET_OF_BOOKS_ID and BOOK_TYPE_CODE.
  • FA_DEPRN_PERIODS — maps PERIOD_COUNTER to the accounting period and run date.
  • FA_GROUP_ASSET_HISTORY — tracks group membership changes over time.
  • FA_DEPRN_RUN / depreciation program APIs — the processes that populate and update these summary rows.
  • FA_MC_BOOK_CONTROLS — reporting-currency book parameters relevant to the MC context.

Together these objects support period-close, reporting, and reconciliation for grouped assets within Oracle Assets.