Search Results fa_mc_books

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:

FA_ADDITIONS_B: Joined on ASSET_ID for core asset master data.
FA_MC_BOOK_CONTROLS: Joined on BOOK_TYPE_CODE and SET_OF_BOOKS_ID for reporting book setup.
FA_TRANSACTION_HEADERS: Joined on TRANSACTION_HEADER_ID_IN (for asset addition) and TRANSACTION_HEADER_ID_OUT (for retirement).
FA_MC_DEPRN_PERIODS: Joined multiple times using BOOK_TYPE_CODE, SET_OF_BOOKS_ID, and period counters (PERIOD_COUNTER_CAPITALIZED, PERIOD_COUNTER_FULLY_RETIRED, PERIOD_COUNTER_FULLY_RESERVED, PERIOD_COUNTER_LIFE_COMPLETE) for period validation.
FA_METHODS: Joined on DEPRN_METHOD_CODE and LIFE_IN_MONTHS for depreciation rules.
FA_CONVENTION_TYPES: Joined on PRORATE_CONVENTION_CODE.
Other related tables include FA_CEILING_TYPES (CEILING_NAME), FA_SUPER_GROUPS (SUPER_GROUP_ID), FA_ITC_RATES (ITC_AMOUNT_ID), FA_MC_RETIREMENTS (RETIREMENT_ID, SET_OF_BOOKS_ID), and FA_BONUS_RULES (BONUS_RULE).

Table: FA_MC_BOOKS 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_MC_BOOKS, object_name:FA_MC_BOOKS, status:VALID, product: OFA - Assets , description: Financial information for each asset in the reporting currency , implementation_dba_data: FA.FA_MC_BOOKS ,
Table: FA_MC_BOOKS 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_MC_BOOKS, object_name:FA_MC_BOOKS, status:VALID, product: OFA - Assets , description: Financial information for each asset in the reporting currency , implementation_dba_data: FA.FA_MC_BOOKS ,
Table: FA_MC_DEPRN_PERIODS 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_MC_DEPRN_PERIODS, object_name:FA_MC_DEPRN_PERIODS, status:VALID, product: OFA - Assets , description: Information about each depreciation period , implementation_dba_data: FA.FA_MC_DEPRN_PERIODS ,
Table: FA_MC_DEPRN_PERIODS 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_MC_DEPRN_PERIODS, object_name:FA_MC_DEPRN_PERIODS, status:VALID, product: OFA - Assets , description: Information about each depreciation period , implementation_dba_data: FA.FA_MC_DEPRN_PERIODS ,
Table: FA_TRANSACTION_HEADERS 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_TRANSACTION_HEADERS, object_name:FA_TRANSACTION_HEADERS, status:VALID, product: OFA - Assets , description: Information about all transactions performed within Oracle Assets , implementation_dba_data: FA.FA_TRANSACTION_HEADERS ,
Table: FA_TRANSACTION_HEADERS 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_TRANSACTION_HEADERS, object_name:FA_TRANSACTION_HEADERS, status:VALID, product: OFA - Assets , description: Information about all transactions performed within Oracle Assets , implementation_dba_data: FA.FA_TRANSACTION_HEADERS ,
Table: FA_BONUS_RULES 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_BONUS_RULES, object_name:FA_BONUS_RULES, status:VALID, product: OFA - Assets , description: Bonus rule information used by the Depreciation program , implementation_dba_data: FA.FA_BONUS_RULES ,
Table: FA_CEILING_TYPES 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_CEILING_TYPES, object_name:FA_CEILING_TYPES, status:VALID, product: OFA - Assets , description: General ceiling information , implementation_dba_data: FA.FA_CEILING_TYPES ,
View: FA_FINANCIAL_INQUIRY_COST_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OFA.FA_FINANCIAL_INQUIRY_COST_V, object_name:FA_FINANCIAL_INQUIRY_COST_V, status:VALID, product: OFA - Assets , description: Financial Cost History , implementation_dba_data: APPS.FA_FINANCIAL_INQUIRY_COST_V ,
Table: FA_MC_BOOK_CONTROLS 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_MC_BOOK_CONTROLS, object_name:FA_MC_BOOK_CONTROLS, status:VALID, product: OFA - Assets , description: Control information that affects all assets in a reporting depreciation book , implementation_dba_data: FA.FA_MC_BOOK_CONTROLS ,
Table: FA_ITC_RATES 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_ITC_RATES, object_name:FA_ITC_RATES, status:VALID, product: OFA - Assets , description: Investment tax credit (ITC) rate information , implementation_dba_data: FA.FA_ITC_RATES ,
Table: FA_SUPER_GROUPS 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_SUPER_GROUPS, object_name:FA_SUPER_GROUPS, status:VALID, product: OFA - Assets , description: Contains super group definitions - flexfield and general descriptive information. , implementation_dba_data: FA.FA_SUPER_GROUPS ,
Table: FA_SUPER_GROUPS 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_SUPER_GROUPS, object_name:FA_SUPER_GROUPS, status:VALID, product: OFA - Assets , description: Contains super group definitions - flexfield and general descriptive information. , implementation_dba_data: FA.FA_SUPER_GROUPS ,
Table: FA_ITC_RATES 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_ITC_RATES, object_name:FA_ITC_RATES, status:VALID, product: OFA - Assets , description: Investment tax credit (ITC) rate information , implementation_dba_data: FA.FA_ITC_RATES ,
Table: FA_MC_RETIREMENTS 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_MC_RETIREMENTS, object_name:FA_MC_RETIREMENTS, status:VALID, product: OFA - Assets , description: Currency and financial information about retirements in each reporting book , implementation_dba_data: FA.FA_MC_RETIREMENTS ,
Table: FA_MC_RETIREMENTS 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_MC_RETIREMENTS, object_name:FA_MC_RETIREMENTS, status:VALID, product: OFA - Assets , description: Currency and financial information about retirements in each reporting book , implementation_dba_data: FA.FA_MC_RETIREMENTS ,
Table: FA_BONUS_RULES 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_BONUS_RULES, object_name:FA_BONUS_RULES, status:VALID, product: OFA - Assets , description: Bonus rule information used by the Depreciation program , implementation_dba_data: FA.FA_BONUS_RULES ,
Table: FA_MC_BOOK_CONTROLS 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_MC_BOOK_CONTROLS, object_name:FA_MC_BOOK_CONTROLS, status:VALID, product: OFA - Assets , description: Control information that affects all assets in a reporting depreciation book , implementation_dba_data: FA.FA_MC_BOOK_CONTROLS ,
Table: FA_CEILING_TYPES 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_CEILING_TYPES, object_name:FA_CEILING_TYPES, status:VALID, product: OFA - Assets , description: General ceiling information , implementation_dba_data: FA.FA_CEILING_TYPES ,
Table: FA_CONVENTION_TYPES 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_CONVENTION_TYPES, object_name:FA_CONVENTION_TYPES, status:VALID, product: OFA - Assets , description: Names and descriptions for prorate conventions , implementation_dba_data: FA.FA_CONVENTION_TYPES ,
Table: FA_METHODS 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_METHODS, object_name:FA_METHODS, status:VALID, product: OFA - Assets , description: Depreciation method information , implementation_dba_data: FA.FA_METHODS ,
Table: FA_CONVENTION_TYPES 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_CONVENTION_TYPES, object_name:FA_CONVENTION_TYPES, status:VALID, product: OFA - Assets , description: Names and descriptions for prorate conventions , implementation_dba_data: FA.FA_CONVENTION_TYPES ,
Table: FA_METHODS 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_METHODS, object_name:FA_METHODS, status:VALID, product: OFA - Assets , description: Depreciation method information , implementation_dba_data: FA.FA_METHODS ,
View: FA_BOOKS_BOOK_CONTROLS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OFA.FA_BOOKS_BOOK_CONTROLS_V, object_name:FA_BOOKS_BOOK_CONTROLS_V, status:VALID, product: OFA - Assets , description: - Retrofitted , implementation_dba_data: APPS.FA_BOOKS_BOOK_CONTROLS_V ,
View: FA_TRANSACTION_HISTORY_BOOKS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OFA.FA_TRANSACTION_HISTORY_BOOKS_V, object_name:FA_TRANSACTION_HISTORY_BOOKS_V, status:VALID, product: OFA - Assets , description: - Retrofitted , implementation_dba_data: APPS.FA_TRANSACTION_HISTORY_BOOKS_V ,
View: FA_BOOKS_MRC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OFA.FA_BOOKS_MRC_V, object_name:FA_BOOKS_MRC_V, status:VALID, product: OFA - Assets , implementation_dba_data: APPS.FA_BOOKS_MRC_V ,
View: FA_BOOKS_MRC_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OFA.FA_BOOKS_MRC_V, object_name:FA_BOOKS_MRC_V, status:VALID, product: OFA - Assets , implementation_dba_data: APPS.FA_BOOKS_MRC_V ,
Table: FA_ADDITIONS_B 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_ADDITIONS_B, object_name:FA_ADDITIONS_B, status:VALID, product: OFA - Assets , description: Descriptive information about assets (base MLS table) , implementation_dba_data: FA.FA_ADDITIONS_B ,
Table: FA_ADDITIONS_B 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_ADDITIONS_B, object_name:FA_ADDITIONS_B, status:VALID, product: OFA - Assets , description: Descriptive information about assets (base MLS table) , implementation_dba_data: FA.FA_ADDITIONS_B ,