Results for “fa_mc_books_summary_u1”

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

Overview

FA.FA_MC_BOOKS_SUMMARY is a materialized summary table in the Oracle E-Business Suite Fixed Assets (FA) module, owned by the FA schema and registered under FND Design Data as OFA.FA_MC_BOOKS_SUMMARY. It stores period-by-period, book-level depreciation and cost balances for each asset and mass-copy (MC) group, serving as the transactional source for the Mass Copy and depreciation summarization processes used to roll sub-ledger activity forward within an asset book. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10, while its indexes are held separately in APPS_TS_TX_IDX.

The ETRM metadata is standalone in heuristic Data Vault terms — the table carries no surrogate-hub pattern of its own and is mined as independent, though it references FA_GROUP_ASSETS and FA_SUPER_GROUPS through foreign keys. This suggests a satellite-style staging model: the business identifiers of the parent asset, book, and period act as a natural key, and the remaining measures describe changes across periods. Physical schema in the 12.2.2 ETRM extract documents 104 columns.

Key Information Stored

The primary business key candidate is the unique index FA_MC_BOOKS_SUMMARY_U1, composed of SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, and TRANSACTION_HEADER_ID_OUT. There is no separate surrogate primary key column in the documented schema; uniqueness is enforced entirely through this composite unique index. The secondary non-unique index FA_MC_BOOKS_SUMMARY_N1 covers BOOK_TYPE_CODE, PERIOD_COUNTER, and TRANSACTION_HEADER_ID_OUT, supporting period and book reporting.

The most significant columns for reporting and integration include:

• SET_OF_BOOKS_ID / BOOK_TYPE_CODE — identify the asset book ledger in which the balance applies.
• ASSET_ID — the asset to which the summarized row belongs.
• PERIOD_COUNTER / FISCAL_YEAR / PERIOD_NUM — place the row in the correct accounting period.
• CALENDAR_PERIOD_OPEN_DATE / CALENDAR_PERIOD_CLOSE_DATE — the reporting window boundary for the period.
• COST / ADJUSTED_COST / CIP_COST — acquisition cost, net adjusted cost, and construction-in-progress cost.
• CHANGE_IN_COST, CHANGE_IN_ADDITIONS_COST, CHANGE_IN_ADJUSTMENTS_COST, CHANGE_IN_RETIREMENTS_COST — period movement categories driving the cost roll-forward.
• DEPRN_AMOUNT / YTD_DEPRN / DEPRN_RESERVE — current-period, year-to-date, and accumulated depreciation.
• SALVAGE_VALUE / PERCENT_SALVAGE_VALUE / RECOVERABLE_COST — depreciation-basis components.
• DEPRN_METHOD_CODE / LIFE_IN_MONTHS / ADJUSTED_RATE — the method, life, and adjusted rate used for the period.
• TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT — links to the FA transaction trail used to build the summary.
• GROUP_ASSET_ID / SUPER_GROUP_ID — foreign-key references into the group-asset hierarchy.

Common Use Cases and Queries

The table is queried primarily for period-end tax and book roll-forward reports, mass-copy reconciliation, and audit of depreciation runs. A typical join retrieves summary activity for an asset in a given period:

• SELECT cost, ytd_deprn, deprn_reserve FROM fa.fa_mc_books_summary WHERE asset_id = :asset_id AND set_of_books_id = :sob AND book_type_code = :book AND period_counter = :period;
• Aggregate by book and period: SELECT book_type_code, period_counter, SUM(deprn_amount) FROM fa.fa_mc_books_summary GROUP BY book_type_code, period_counter;
• Reconcile mass-copy output against source transactions using transaction_header_id_in and transaction_header_id_out.
• Report group-level balances by joining to FA_GROUP_ASSETS and FA_SUPER_GROUPS via GROUP_ASSET_ID and SUPER_GROUP_ID.

Because the unique index includes TRANSACTION_HEADER_ID_OUT, the same asset-book-period can appear multiple times when output transaction headers differ, so queries should explicitly aggregate by the grouping level required rather than assuming one row per period.

Related Objects

Foreign-key and dependency relationships documented for FA_MC_BOOKS_SUMMARY include:

• FA.FA_GROUP_ASSETS — referenced by FA_MC_BOOKS_SUMMARY.GROUP_ASSET_ID; stores the group asset definition used in group depreciation and mass-copy processing.
• FA.FA_SUPER_GROUPS — referenced by FA_MC_BOOKS_SUMMARY.SUPER_GROUP_ID; holds super-group hierarchy used for tax grouping.
• FA.FA_BOOK_CONTROLS — book definition and control settings for SET_OF_BOOKS_ID / BOOK_TYPE_CODE.
• FA.FA_ADDITIONS and FA.FA_ADJUSTMENTS — source transactions contributing CHANGE_IN_ADDITIONS_COST and CHANGE_IN_ADJUSTMENTS_COST.
• FA.FA_RETIREMENTS — source of CHANGE_IN_RETIREMENTS_COST.
• FA.FA_DEPRN_SUMMARY / FA.FA_BOOKS — parallel period summarization tables joined on ASSET_ID and BOOK_TYPE_CODE for reconciliation.
• FA.FA_MASS_COPY — the concurrent process that populates and consumes this table.

These relationships make the table central to Fixed Assets period-close and mass-copy workflows across both 12.1.1 and 12.2.2 releases.