Search Results fa_itc_rates




Overview
Explore in AI Chat

Overview

The FA_ITC_RATES table is a core data repository within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It is designed to store and manage master data for Investment Tax Credit (ITC) rates. An ITC is a tax incentive that allows a business to reduce its income tax liability by a percentage of the cost of qualifying capital assets. This table's primary role is to serve as a reference source for predefined ITC rates and associated rules, which are then linked to specific asset transactions. By centralizing this information, it ensures consistent application of tax credits across asset additions and enables accurate tax reporting and compliance.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the table's primary key is documented as ITC_AMOUNT_ID. This unique identifier is the critical column used to link ITC rate records to asset data in related tables. Based on its function, the table typically stores data such as the effective ITC percentage rate, applicable dates or date ranges for the rate, a description of the credit, and potentially flags or codes indicating the type of credit or its eligibility criteria. The ITC_AMOUNT_ID itself is likely a system-generated sequence number serving as the primary key for this reference data.

Common Use Cases and Queries

The primary use case for the FA_ITC_RATES table is during the addition or capitalization of an asset. When an asset is assigned an ITC, the system references a specific record in this table via the ITC_AMOUNT_ID. This drives the calculation of the credit amount, which reduces the asset's cost basis for tax purposes. Common reporting and query scenarios involve analyzing tax credit utilization. A fundamental query pattern joins this table to the main asset books to retrieve the credit details applied to assets.

  • Sample Query: To list assets with their associated ITC rates, a query would join FA_BOOKS to FA_ITC_RATES: SELECT fb.asset_id, fb.book_type_code, fir.* FROM fa_books fb, fa_itc_rates fir WHERE fb.itc_amount_id = fir.itc_amount_id;
  • Reporting Use Case: Generating a summary report of total ITC claimed per book for a fiscal year, which requires joining through FA_BOOKS to access the rate details stored in FA_ITC_RATES.

Related Objects

The FA_ITC_RATES table is a key reference table with several important foreign key relationships, as documented in the ETRM. The ITC_AMOUNT_ID column is referenced by core asset transaction tables.

  • FA_BOOKS: This primary asset table references FA_ITC_RATES via the column FA_BOOKS.ITC_AMOUNT_ID. This links the master ITC rate to the specific asset book record.
  • FA_MC_BOOKS: The reporting currency equivalent of FA_BOOKS also references FA_ITC_RATES via FA_MC_BOOKS.ITC_AMOUNT_ID, maintaining the ITC link in multiple currencies.
  • FA_TAX_INTERFACE: This table, which handles data for tax reporting, references FA_ITC_RATES via FA_TAX_INTERFACE.ITC_AMOUNT_ID, ensuring tax credit data flows correctly to tax subsystems.
  • Table: FA_ITC_RATES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ITC_RATES,  object_name:FA_ITC_RATES,  status:VALID,  product: OFA - Assets ,  description: Investment tax credit (ITC) rate information ,  implementation_dba_data: FA.FA_ITC_RATES , 

  • Table: FA_ITC_RATES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ITC_RATES,  object_name:FA_ITC_RATES,  status:VALID,  product: OFA - Assets ,  description: Investment tax credit (ITC) rate information ,  implementation_dba_data: FA.FA_ITC_RATES , 

  • Table: FA_TAX_INTERFACE 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_TAX_INTERFACE,  object_name:FA_TAX_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Tax Book Interface table ,  implementation_dba_data: FA.FA_TAX_INTERFACE , 

  • Table: FA_TAX_INTERFACE 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_TAX_INTERFACE,  object_name:FA_TAX_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Tax Book Interface table ,  implementation_dba_data: FA.FA_TAX_INTERFACE , 

  • Table: FA_BOOKS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOKS,  object_name:FA_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Financial information of each asset ,  implementation_dba_data: FA.FA_BOOKS , 

  • 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_BOOKS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOKS,  object_name:FA_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Financial information of each asset ,  implementation_dba_data: FA.FA_BOOKS , 

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