Results for “fa_mc_books”

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

Overview

FA_MC_BOOKS is a core table in the Oracle E-Business Suite Assets module (OFA), owned by the FA schema. In the context of Oracle EBS 12.1.1 and 12.2.2, it stores the financial information for each asset in the reporting (multiple reporting currency) book. While the primary asset book records reside in FA_BOOKS, FA_MC_BOOKS maintains the parallel reporting-currency equivalent of that data, enabling statutory and management reporting in a currency distinct from the primary ledger currency. The table is valid and contains 125 documented columns in the 12.2.2 physical schema.

From a data-modeling perspective, the ETRM heuristic classifies this object as a link table. This classification reflects its role in bridging the asset master (FA_ADDITIONS_B) to book controls, depreciation methods, conventions, and transaction headers, rather than acting as a pure hub or satellite. The composite unique keys underscore this linking behavior.

Key Information Stored

The table's surrogate and business-key structure is defined by two unique indexes. FA_MC_BOOKS_U1 spans (SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID_IN), while FA_MC_BOOKS_U2 spans (SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, TRANSACTION_HEADER_ID_OUT). These composite keys constitute the business-key candidates for the object.

The most significant columns include:

• SET_OF_BOOKS_ID, BOOK_TYPE_CODE, ASSET_ID — the composite identifier linking a reporting book to a specific asset.
• TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT — references to the asset transaction headers that added or removed the asset from the book.
• ADJUSTED_COST, COST, ORIGINAL_COST, SALVAGE_VALUE — cost basis and residual-value amounts held in the reporting currency.
• DEPRN_METHOD_CODE, LIFE_IN_MONTHS, PRORATE_CONVENTION_CODE — depreciation method, useful life, and prorate convention applied.
• DATE_PLACED_IN_SERVICE, DEPRN_START_DATE, DATE_EFFECTIVE, DATE_INEFFECTIVE — lifecycle dates governing depreciation.
• PERIOD_COUNTER_CAPITALIZED, PERIOD_COUNTER_FULLY_RETIRED, PERIOD_COUNTER_FULLY_RESERVED, PERIOD_COUNTER_LIFE_COMPLETE — depreciation-period counters tracking key milestones.
• ITC_AMOUNT, ITC_BASIS, ITC_AMOUNT_ID — investment tax credit amounts and references.
• RETIREMENT_ID, RETIREMENT_PENDING_FLAG — retirement tracking linkage.
• GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1–20 — descriptive flexfield storage.

Common Use Cases and Queries

Typical uses include reconciling reporting-currency asset balances against the primary book, generating depreciation reports in a reporting currency, and auditing adjusted cost or salvage values. A representative query joining to the asset master is:

• SELECT m.asset_id, m.book_type_code, m.cost, m.adjusted_cost, m.salvage_value FROM fa_mc_books m WHERE m.set_of_books_id = :sob_id AND m.book_type_code = :book;
• Join to FA_ADDITIONS_B on ASSET_ID to retrieve asset descriptions, and to FA_MC_DEPRN_PERIODS for period-level depreciation drill-down.

Reporting scenarios commonly filter on RETIREMENT_PENDING_FLAG, PERIOD_COUNTER_FULLY_RETIRED, or CONVERTED_FLAG to isolate assets in specific lifecycle states within the reporting currency.

Related Objects

The following tables are among the most significant related objects, based on documented foreign-key relationships:

• FA_ADDITIONS_B — joined on ASSET_ID; source of the asset master record.
• FA_MC_DEPRN_PERIODS — joined on BOOK_TYPE_CODE and SET_OF_BOOKS_ID, with period counters for fully reserved, retired, and life-complete states.
• FA_MC_BOOK_CONTROLS — referenced via BOOK_TYPE_CODE, holding book-level controls.
• FA_METHODS — referenced via DEPRN_METHOD_CODE and LIFE_IN_MONTHS.
• FA_CONVENTION_TYPES — referenced via PRORATE_CONVENTION_CODE.
• FA_TRANSACTION_HEADERS — referenced via TRANSACTION_HEADER_ID_IN and TRANSACTION_HEADER_ID_OUT.
• FA_MC_RETIREMENTS — referenced via RETIREMENT_ID and SET_OF_BOOKS_ID.
• FA_CEILING_TYPES, FA_SUPER_GROUPS, FA_ITC_RATES, FA_BONUS_RULES, FA_GROUP_ASSETS — additional referenced lookups and allocation entities.