Search Results fa_retirements

Overview

The FA_RETIREMENTS table is a core transaction table within the Oracle E-Business Suite Fixed Assets module (OFA). It serves as the central repository for recording and managing all asset retirement and reinstatement transactions. When an asset is fully or partially retired, or when a prior retirement is reversed (reinstated), a corresponding record is created in this table. It acts as the definitive ledger for these events, linking the asset, the specific book, and the detailed transaction headers that document the financial and accounting impacts of the retirement action. Its integrity is maintained through a primary key and a network of foreign key relationships to other essential asset tables.

Key Information Stored

The table's structure captures the complete context of a retirement event. Its primary key is the RETIREMENT_ID, a unique system-generated identifier. Critical foreign key columns establish essential relationships: ASSET_ID links to FA_ADDITIONS_B to identify the retired asset; BOOK_TYPE_CODE links to FA_BOOK_CONTROLS to specify the asset book; and TRANSACTION_HEADER_ID_IN/OUT link to FA_TRANSACTION_HEADERS for the underlying accounting transactions. Other significant columns include RETIREMENT_TYPE_CODE (e.g., 'FULL', 'PARTIAL'), RETIREMENT_DATE, RETIREMENT_PRORATE_CONVENTION (linked to FA_CONVENTION_TYPES), COST_RETIRED, and NBV_RETIRED. For partial retirements, the table stores details on the cost and NBV of the retired portion. It also holds references for specialized scenarios, such as ITC_RECAPTURE_ID for Investment Tax Credit and TRADE_IN_ASSET_ID for trade-in transactions.

Common Use Cases and Queries

This table is fundamental for retirement reporting, audit trails, and reconciliation. Common analytical queries involve joining it with FA_ADDITIONS_B and FA_BOOKS to report on retired assets by category, cost center, or date range. A typical pattern is to retrieve retirement details for a specific period to analyze disposal activity. The table is also crucial for reinstatement processes, where the original retirement record provides the baseline data for reversal. Support and implementation consultants frequently query this table to troubleshoot retirement accounting or validate data integrity between the retirement transaction and its associated distribution history (FA_DISTRIBUTION_HISTORY).

• Reporting total retired cost by asset category for a fiscal year.
• Identifying assets retired in a partial retirement to analyze remaining book values.
• Troubleshooting by linking a retirement ID to its corresponding transaction headers and general ledger entries.

Related Objects

FA_RETIREMENTS has extensive relationships within the Fixed Assets schema, as documented in the ETRM. It is a parent table referenced by FA_BOOKS and FA_DISTRIBUTION_HISTORY via the RETIREMENT_ID, meaning these tables store key information tied to a specific retirement record. As a child table, its primary foreign key dependencies are on FA_ADDITIONS_B (ASSET_ID), FA_BOOK_CONTROLS (BOOK_TYPE_CODE), and FA_TRANSACTION_HEADERS (TRANSACTION_HEADER_ID_IN/OUT). It also references lookup and setup tables like FA_CONVENTION_TYPES and FA_METHODS. Furthermore, it is referenced by localization objects such as JA_AU_BAL_CHG_SOURCE and JL_ZZ_FA_RETIREMNT_ADJS, indicating its role in country-specific functionality for Japan and Latin America.