Search Results fa_mc_retirements




Overview
Explore in AI Chat

Overview

The FA_MC_RETIREMENTS table is a core data object within the Oracle E-Business Suite (EBS) Fixed Assets module, specifically for versions 12.1.1 and 12.2.2. It is designed to support the application's multi-currency accounting capabilities. As indicated by its description, this table stores currency and financial information about asset retirements in each reporting book. Its primary role is to maintain the detailed transactional and monetary data associated with retiring an asset across different reporting currencies, ensuring accurate financial reporting and compliance in a multi-book or multi-currency environment. The table is integral to the retirement process, capturing the financial impact separate from the primary asset book records.

Key Information Stored

The table's structure centers on linking a retirement transaction to its specific financial context. Its primary key combines RETIREMENT_ID and SET_OF_BOOKS_ID, uniquely identifying a retirement record for a given reporting ledger. Key columns include TRANSACTION_HEADER_ID_IN and TRANSACTION_HEADER_ID_OUT, which link to the FA_TRANSACTION_HEADERS table to track the retirement transaction's history. Financial columns would typically store cost, proceeds, cost of removal, and gain or loss amounts in the reporting book's currency. The BOOK_TYPE_CODE and SET_OF_BOOKS_ID define the reporting book context. Other significant columns reference related data, such as ASSET_ID, TRADE_IN_ASSET_ID, ITC_RECAPTURE_ID for investment tax credit, and RETIREMENT_PRORATE_CONVENTION for depreciation calculations.

Common Use Cases and Queries

This table is primarily accessed for generating detailed retirement audit trails and financial reports across multiple reporting books. A common use case is reconciling retirement gains or losses between the primary asset book and various reporting ledgers. For reporting, one might join to FA_ADDITIONS_B to get asset details and to FA_TRANSACTION_HEADERS for transaction dates. A typical query pattern would retrieve retirement details for a specific asset across all reporting books:

  • SELECT fmcr.*, fab.asset_number FROM fa_mc_retirements fmcr, fa_additions_b fab WHERE fmcr.asset_id = fab.asset_id AND fab.asset_number = '<ASSET_NUM>';

Another critical use case is supporting period-end close processes, where financial teams validate retirement transactions and their currency impacts before posting to the general ledger via the GL_SETS_OF_BOOKS_11I relationship.

Related Objects

FA_MC_RETIREMENTS has extensive foreign key relationships, as documented, making it a central hub for retirement data. Key related objects include:

  • FA_MC_BOOKS: This table references FA_MC_RETIREMENTS via RETIREMENT_ID and SET_OF_BOOKS_ID, storing the book-level details of the retired asset.
  • FA_TRANSACTION_HEADERS: Linked twice for the inbound (TRANSACTION_HEADER_ID_IN) and outbound (TRANSACTION_HEADER_ID_OUT) retirement transactions.
  • FA_ADDITIONS_B: Linked for the retired ASSET_ID and for any TRADE_IN_ASSET_ID.
  • GL_SETS_OF_BOOKS_11I: Defines the reporting ledger via SET_OF_BOOKS_ID.
  • FA_MC_BOOK_CONTROLS: Linked via BOOK_TYPE_CODE and SET_OF_BOOKS_ID for book setup validation.
  • FA_ITC_RECAPTURE_RATES, FA_CONVENTION_TYPES, FA_METHODS: Reference tables for specific retirement attributes like recapture rules, prorate conventions, and settlement methods.