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.
  • 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_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_ITC_RECAPTURE_RATES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ITC_RECAPTURE_RATES,  object_name:FA_ITC_RECAPTURE_RATES,  status:VALID,  product: OFA - Assets ,  description: Percentage of Investment Tax Credit (ITC) to recapture for early retirements ,  implementation_dba_data: FA.FA_ITC_RECAPTURE_RATES , 

  • 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_RECAPTURE_RATES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ITC_RECAPTURE_RATES,  object_name:FA_ITC_RECAPTURE_RATES,  status:VALID,  product: OFA - Assets ,  description: Percentage of Investment Tax Credit (ITC) to recapture for early retirements ,  implementation_dba_data: FA.FA_ITC_RECAPTURE_RATES , 

  • 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_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_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_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 , 

  • 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.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_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_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 , 

  • 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 , 

  • View: FA_RETIREMENTS_MRC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_RETIREMENTS_MRC_V,  object_name:FA_RETIREMENTS_MRC_V,  status:VALID,  product: OFA - Assets ,  description: - Retrofitted ,  implementation_dba_data: APPS.FA_RETIREMENTS_MRC_V , 

  • View: FA_RETIREMENTS_MRC_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_RETIREMENTS_MRC_V,  object_name:FA_RETIREMENTS_MRC_V,  status:VALID,  product: OFA - Assets ,  description: - Retrofitted ,  implementation_dba_data: APPS.FA_RETIREMENTS_MRC_V ,