Results for “fa_mc_retirements”

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

Overview

FA_MC_RETIREMENTS is an Oracle E-Business Suite Assets (OFA) table that stores currency and financial information about asset retirements in each reporting book. In an EBS environment, asset retirements are captured at the corporate (primary) book in the base functional currency, and this table mirrors that retirement activity at the reporting-book level, allowing each reporting book to record its own cost, net book value, reserve, gain/loss, and proceeds figures for the same retirement event. This is essential where multiple reporting books exist alongside the corporate book, particularly for MRC (Multiple Reporting Currencies) installations.

The table resides in the FA schema and is documented as VALID under release 12.1.1 / 12.2.2. It contains 60 documented columns. From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification: the table describes financial measures and descriptive attributes about a retirement event and is keyed, in part, by references to parent objects such as the asset and the set of books. Columns such as COST_RETIRED, NBV_RETIRED, and GAIN_LOSS_AMOUNT typify this measure-oriented, satellite character.

Key Information Stored

The primary key is FA_MC_RETIREMENTS_PK, defined on the surrogate pair RETIREMENT_ID and SET_OF_BOOKS_ID. Two unique indexes act as business-key candidates: FA_MC_RETIREMENTS_U1 on (SET_OF_BOOKS_ID, RETIREMENT_ID) and FA_MC_RETIREMENTS_U2 on (SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID_IN). The most significant columns include:

• SET_OF_BOOKS_ID — identifies the set of books (reporting book) to which the retirement row belongs; part of the primary key.
• RETIREMENT_ID — surrogate identifier for the retirement event; part of the primary key.
• ASSET_ID — foreign key to FA_ADDITIONS_B, linking the retirement to the underlying asset.
• BOOK_TYPE_CODE — the reporting book type, referencing FA_MC_BOOK_CONTROLS.
• COST_RETIRED and NBV_RETIRED — the cost and net book value removed from the book as a result of the retirement.
• GAIN_LOSS_AMOUNT and GAIN_LOSS_TYPE_CODE — the realized gain or loss and its classification.
• PROCEEDS_OF_SALE and COST_OF_REMOVAL — sale proceeds and removal costs associated with the disposition.
• DATE_RETIRED and DATE_EFFECTIVE — the retirement date and the effective accounting date.
• STATUS — processing status of the retirement record within the reporting book.
• TRANSACTION_HEADER_ID_IN and TRANSACTION_HEADER_ID_OUT — foreign keys to FA_TRANSACTION_HEADERS for the retirement transaction.
• REVAL_RESERVE_RETIRED, RESERVE_RETIRED, and BONUS_RESERVE_RETIRED — reserve amounts retired, including revaluation and bonus reserves.
• ITC_RECAPTURED and ITC_RECAPTURE_ID — investment tax credit recapture figures and reference.

Common Use Cases and Queries

Typical uses include reporting realized gains and losses by reporting book, reconciling retirement cost and NBV across books, and auditing proceeds and cost-of-removal figures. A gain/loss report joined to book and asset details is illustrative:

• Gain/loss by book and period: aggregate GAIN_LOSS_AMOUNT grouped by BOOK_TYPE_CODE and DATE_EFFECTIVE.
• Retirement reconciliation: join FA_MC_RETIREMENTS to FA_ADDITIONS_B on ASSET_ID to validate retired cost against asset cost.
• Proceeds and removal analysis: filter rows where PROCEEDS_OF_SALE is not null and compare against COST_OF_REMOVAL.
• Transaction tracing: join to FA_TRANSACTION_HEADERS via TRANSACTION_HEADER_ID_IN to trace the originating transaction.

Related Objects

The following objects are the most significant relationships, drawn from the documented foreign keys:

• GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID.
• FA_MC_BOOK_CONTROLS — joined on BOOK_TYPE_CODE and SET_OF_BOOKS_ID.
• FA_ADDITIONS_B — joined on ASSET_ID (and separately on TRADE_IN_ASSET_ID).
• FA_TRANSACTION_HEADERS — joined on TRANSACTION_HEADER_ID_IN and TRANSACTION_HEADER_ID_OUT.
• FA_ITC_RECAPTURE_RATES — joined on ITC_RECAPTURE_ID.
• FA_CONVENTION_TYPES — joined on RETIREMENT_PRORATE_CONVENTION.
• FA_METHODS — joined on STL_METHOD_CODE and STL_LIFE_IN_MONTHS.
• FA_MC_BOOKS — references this table via RETIREMENT_ID and SET_OF_BOOKS_ID.