Results for “fa_mc_group_deprn_detail”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The FA_MC_GROUP_DEPRN_DETAIL table is a core repository within the Oracle E-Business Suite Assets (OFA) module that stores depreciation detail lines for group assets across multiple reporting books. Its name reflects the "MC" (multi-currency / multiple-book) context: the table records depreciation amounts, reserves, and revaluation figures associated with a group asset, keyed by accounting period and by the depreciation source. The physical schema documented in ETRM 12.2.2 shows the table owned by the FA schema with 32 columns, classified under the OFA - Assets product and marked VALID.

From a data-modeling perspective, the ETRM heuristics classify this object as standalone (a heuristic Data Vault classification rather than a definitive hub, link, or satellite designation). The only documented foreign key points to FA_GROUP_ASSETS via GROUP_ASSET_ID, indicating that FA_MC_GROUP_DEPRN_DETAIL functions as a dependent detail record anchored to the group asset definition. In a Data Vault model it would most naturally be modeled as a satellite attached to a group-asset hub, because it carries descriptive, transaction-oriented measures rather than serving as a join table.

Key Information Stored

The table captures a combination of book identifiers, period references, and depreciation measures. The most significant columns documented in the metadata are:

• SET_OF_BOOKS_ID and BOOK_TYPE_CODE — identify the reporting book (e.g., a corporate or tax book) to which the depreciation line belongs.
• GROUP_ASSET_ID — foreign key linking to FA_GROUP_ASSETS; defines the group asset being depreciated.
• PERIOD_COUNTER — references the accounting period in which depreciation was recognized.
• DISTRIBUTION_ID — associates the line with a cost distribution, enabling allocation across accounts.
• DEPRN_SOURCE_CODE and DEPRN_RUN_DATE — identify the source of the depreciation (e.g., standard run) and when it was processed.
• DEPRN_AMOUNT, YTD_DEPRN, DEPRN_RESERVE — current-period expense, year-to-date expense, and accumulated depreciation reserve.
• COST and ADDITION_COST_TO_CLEAR — cost basis and any addition cost pending clearing.
• DEPRN_ADJUSTMENT_AMOUNT — adjustments captured for the period.
• REVAL_AMORTIZATION, REVAL_DEPRN_EXPENSE, REVAL_RESERVE, YTD_REVAL_DEPRN_EXPENSE — revaluation-related amounts.
• JE_HEADER_ID with the JE line numbers — journal entry linkage for the generated depreciation, reserve, and revaluation entries.
• SOURCE_* columns (SOURCE_DEPRN_AMOUNT, SOURCE_YTD_DEPRN, and others) and CONVERTED_FLAG — preserve pre-conversion or source-system values and conversion status, supporting migration audits.

The metadata does not document a single surrogate primary key; instead, the effective business key is the composite of the book, group asset, period, distribution, and source codes. GROUP_ASSET_ID is the sole documented unique foreign key candidate.

Common Use Cases and Queries

Typical uses include reconciliation of group-asset depreciation to the general ledger, multi-book reporting, and conversion validation. A representative query joins to FA_GROUP_ASSETS and filters by book and period:

SELECT d.GROUP_ASSET_ID, d.PERIOD_COUNTER, d.DEPRN_AMOUNT, d.YTD_DEPRN, d.DEPRN_RESERVE FROM FA_MC_GROUP_DEPRN_DETAIL d WHERE d.SET_OF_BOOKS_ID = :book_id AND d.PERIOD_COUNTER = :period_id;

Analysts also aggregate revaluation and reserve balances to support period-close journal entry verification using JE_HEADER_ID.

Related Objects

• FA_GROUP_ASSETS — parent of GROUP_ASSET_ID.
• FA_DEPRN_DETAIL — member-asset depreciation detail, used for comparison.
• FA_BOOK_CONTROLS — book status and period open/close context.
• FA_DEPRN_PERIODS — maps PERIOD_COUNTER to accounting periods.
• FA_DISTRIBUTION_HISTORY — source of DISTRIBUTION_ID.
• GL_JE_HEADERS / GL_JE_LINES — journal entries linked via JE_HEADER_ID.
• FA_DEPRN_SUMMARY — summarized depreciation for reconciliation.