Search Results fa_mc_books




Overview
Explore in AI Chat

Overview

The FA_MC_BOOKS table is a core data object within the Oracle E-Business Suite Fixed Assets (OFA) module. It stores the primary financial information for each capitalized asset, specifically in the reporting currency. This table is fundamental to Oracle Assets' multi-currency accounting capabilities, enabling organizations to maintain and report asset valuations, depreciation, and retirement activities in a currency different from the transaction (or corporate) currency. Its role is to serve as the central repository for an asset's financial lifecycle within a given asset book, supporting critical processes such as depreciation calculation, revaluation, transfers, and retirement in the reporting ledger context.

Key Information Stored

The table's structure captures the complete financial snapshot of an asset in a reporting book. Key columns include identifiers like ASSET_ID, BOOK_TYPE_CODE, and SET_OF_BOOKS_ID, which link the record to a specific asset, book, and reporting ledger. Financial columns track cost (COST), accumulated depreciation (RESERVE), and year-to-date depreciation (YTD_DEPRN). The table also stores critical depreciation parameters such as DEPRN_METHOD_CODE, LIFE_IN_MONTHS, and PRORATE_CONVENTION_CODE. Status and timing are managed through period counters (e.g., PERIOD_COUNTER_CAPITALIZED, PERIOD_COUNTER_FULLY_RETIRED) and foreign keys to transaction headers (TRANSACTION_HEADER_ID_IN, TRANSACTION_HEADER_ID_OUT). Additional columns support specific features like Investment Tax Credit (ITC_AMOUNT_ID), bonus depreciation (BONUS_RULE), and ceiling rules (CEILING_NAME).

Common Use Cases and Queries

This table is central to reporting and data validation for multi-currency asset accounting. Common use cases include generating the reporting currency Asset Register, reconciling asset costs and reserves between corporate and reporting ledgers, and supporting period-end depreciation runs. Technical consultants often query this table to troubleshoot asset balances or audit transaction history. A typical query pattern joins FA_MC_BOOKS to FA_ADDITIONS_B for descriptive asset information:

  • SELECT mc.asset_id, mc.book_type_code, a.description, mc.cost, mc.reserve, mc.ytd_deprn FROM fa_mc_books mc, fa_additions_b a WHERE mc.asset_id = a.asset_id AND mc.set_of_books_id = :reporting_ledger_id;

Another critical pattern involves joining to FA_MC_DEPRN_PERIODS via the various period counter columns to validate the period of capitalization, retirement, or life completion for an asset in the reporting currency.

Related Objects

FA_MC_BOOKS maintains extensive foreign key relationships, as documented in the ETRM. Key parent tables and their join columns include: