Search Results fa_itc_recapture_rates




Overview
Explore in AI Chat

Overview

The FA_ITC_RECAPTURE_RATES table is a core reference table within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). Its primary function is to store the predefined percentage rates used to calculate the recapture of Investment Tax Credit (ITC) when an asset is retired before the end of its specified useful life. This table is essential for ensuring accurate and compliant tax accounting for early asset disposals, as tax regulations often mandate the partial or full repayment of previously claimed tax credits based on the timing of the retirement. The table serves as a lookup for the retirement processing logic, enabling the system to automatically determine the correct recapture liability.

Key Information Stored

While the provided ETRM metadata does not list specific column names beyond the primary key, the table's structure is designed to support its defined purpose. The central column is ITC_RECAPTURE_ID, which serves as the unique primary key identifier for each recapture rate record. Other columns typically found in such a reference table would include fields to define the recapture percentage and the time-based condition that triggers it. This would logically involve a column for the recapture rate percentage and columns defining the applicable year range or period threshold from the asset's placed-in-service date. The table likely contains a set of static, seeded data corresponding to the tax rules in effect for different asset life categories.

Common Use Cases and Queries

The primary use case is during the asset retirement process. When a user retires an asset in the FA_RETIREMENTS interface, the system references this table via the ITC_RECAPTURE_ID to calculate any required ITC recapture amount, which is then posted to the general ledger. A common reporting need is to review the configured recapture rules. A sample query to retrieve all recapture rates would be:

  • SELECT itc_recapture_id, recapture_rate, year_from, year_to FROM fa_itc_recapture_rates ORDER BY year_from;

For troubleshooting retirement transactions, one might join to the retirement tables to see which rate was applied:

  • SELECT r.asset_number, r.retirement_id, rc.recapture_rate FROM fa_retirements r, fa_itc_recapture_rates rc WHERE r.itc_recapture_id = rc.itc_recapture_id;

Related Objects

The FA_ITC_RECAPTURE_RATES table is referenced as a foreign key by two critical transaction tables in the Fixed Assets module, establishing its role in the retirement process.

  • FA_RETIREMENTS: The FA_RETIREMENTS.ITC_RECAPTURE_ID column references this table. This is the primary table for single-currency asset retirements.
  • FA_MC_RETIREMENTS: The FA_MC_RETIREMENTS.ITC_RECAPTURE_ID column references this table. This is the reporting currency table for multicurrency asset retirements.

These relationships confirm that every retirement transaction (in both primary and reporting currency) that involves ITC recapture will store a key pointing to a specific rate defined in the FA_ITC_RECAPTURE_RATES table.