Results for “fa_mc_deprn_detail”

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

Overview

FA_MC_DEPRN_DETAIL is a reporting-currency depreciation detail table in the Oracle Assets (OFA) module of Oracle E-Business Suite, owned by the FA schema. Its documented purpose is to hold depreciation amounts expressed in the reporting currency that have been charged to the depreciation expense account on each distribution line. Within Oracle Assets, depreciation is calculated and stored in the primary (functional) ledger of a book, while multi-currency books — those that share a corporate book and maintain separate reporting books — require the same depreciation results restated into the reporting currency. FA_MC_DEPRN_DETAIL serves precisely that role, complementing the primary-currency depreciation tables and providing the per-distribution, per-period amounts that drive accounting entries in the reporting set of books.

Because each row is defined by the combination of book type, asset, period, distribution, and set of books, the table behaves as an intersection of those dimensions rather than as a standalone entity. In Data Vault terms, the heuristic classification supplied with this object is link. That classification is a modeling suggestion: the row resolves the relationship between an asset, a depreciation distribution, a period, and a reporting book, carrying descriptive and financial measures alongside those relationships.

Key Information Stored

The table contains 51 documented columns. The most significant of these are the primary key components and the financial measures.

• BOOK_TYPE_CODE — the depreciation book in which the amounts were generated; identifies the reporting book.
• ASSET_ID — the asset to which the depreciation detail belongs.
• PERIOD_COUNTER — the depreciation period for which amounts were calculated.
• DISTRIBUTION_ID — the distribution line to which the depreciation was charged; this links amounts to the cost distribution assignment.
• SET_OF_BOOKS_ID — the ledger associated with the reporting book.
• DEPRN_AMOUNT — depreciation expense charged for the period.
• YTD_DEPRN — year-to-date depreciation expense.
• DEPRN_RESERVE — accumulated depreciation reserve balance.
• REVAL_DEPRN_EXPENSE, REVAL_RESERVE, and YTD_REVAL_DEPRN_EXPENSE — revaluation-related depreciation amounts.
• BONUS_DEPRN_AMOUNT, BONUS_YTD_DEPRN, and BONUS_DEPRN_RESERVE — bonus depreciation measures where applicable.
• DEPRN_EXPENSE_CCID, DEPRN_RESERVE_CCID, and related CCID columns — the accounting flexfield combinations to which the depreciation and reserve amounts are posted.
• JE_HEADER_ID together with the JE line-number columns — identifies the journal entry created in General Ledger.

The documented primary key is FA_MC_DEPRN_DETAIL_PK, composed of BOOK_TYPE_CODE, ASSET_ID, PERIOD_COUNTER, DISTRIBUTION_ID, and SET_OF_BOOKS_ID. A unique index, FA_MC_DEPRN_DETAIL_U1, lists DISTRIBUTION_ID, ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, and SET_OF_BOOKS_ID — effectively the same business key in a differing column order. This confirms that the natural identity of a row is the asset, its distribution, the period, and the book.

Common Use Cases and Queries

Typical uses include reconciliation between primary and reporting books, depreciation expense reporting by distribution and cost center, and tracing accounting entries back to their source asset and period.

• Reporting depreciation expense by period for a book, joining to the asset and distribution for context.
• Reconciling reporting-currency expense to the primary book using the SOURCE_* columns (for example SOURCE_DEPRN_AMOUNT against DEPRN_AMOUNT) and the CONVERTED_FLAG.
• Tracing journal entries by joining JE_HEADER_ID to GL_JE_HEADERS and GL_JE_LINES.
• Analyzing depreciation, reserve, and revaluation balances by cost center through the CCID columns joined to GL_CODE_COMBINATIONS.

A representative query pattern filters by BOOK_TYPE_CODE, PERIOD_COUNTER, and ASSET_ID, then joins FA_ADDITIONS_B for asset attributes and GL_CODE_COMBINATIONS for the expense account, aggregating DEPRN_AMOUNT and YTD_DEPRN.

Related Objects

Documented foreign keys connect this table to several core Oracle Assets and General Ledger objects.

• FA_BOOK_CONTROLS — joined on BOOK_TYPE_CODE; defines the book and its accounting rules.
• FA_DEPRN_PERIODS — joined on BOOK_TYPE_CODE and PERIOD_COUNTER; provides period status and dates.
• FA_ADDITIONS_B — joined on ASSET_ID; supplies asset identification.
• FA_DISTRIBUTION_HISTORY — joined on DISTRIBUTION_ID; supplies the distribution line detail.
• GL_CODE_COMBINATIONS — referenced through the six CCID columns (expense, reserve, bonus, and revaluation combinations).
• GL_JE_HEADERS and GL_JE_LINES — joined on JE_HEADER_ID and the JE line-number columns; link the detail to the generated journal entries.

These relationships establish FA_MC_DEPRN_DETAIL as the reporting-currency counterpart of primary-book depreciation detail, anchoring depreciation accounting in General Ledger.