Results for “fa_itc_rates”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_ITC_RATES is a reference and configuration table in the Oracle EBS Assets (OFA) module, owned by the FA schema. It stores Investment Tax Credit (ITC) rate information used to determine the amount of investment tax credit that an asset is eligible to claim, along with the corresponding reduction to the depreciable basis. Investment tax credits are a tax incentive mechanism under which a portion of the cost of a qualifying asset can be credited against tax liability, and Oracle Assets uses the rates defined in this table to compute and track that credit during asset additions, adjustments, and tax reporting.

Based on the foreign-key topology documented in the ETRM metadata, FA_ITC_RATES exhibits a hub-leaning Data Vault classification. In a Data Vault model this object would best be represented as a hub, since its primary key (ITC_AMOUNT_ID) is a surrogate key that is referenced by numerous downstream tables, and the table itself holds relatively stable reference attributes rather than transactional event history.

Key Information Stored

The table contains 26 documented columns, of which the most functionally significant are:

• ITC_AMOUNT_ID — the surrogate primary key (defined by FA_ITC_RATES_PK) and the column referenced by all downstream foreign keys. It is also the sole business-key candidate, enforced by the unique index FA_ITC_RATES_U1.
• TAX_YEAR — the tax year to which the ITC rate applies, allowing rates to vary by legislative period.
• LIFE_IN_MONTHS — the asset life range, expressed in months, to which the ITC rate applies.
• ITC_AMOUNT_RATE — the percentage rate used to compute the investment tax credit amount.
• BASIS_REDUCTION_RATE — the rate by which the depreciable basis of the asset is reduced when the credit is taken.
• ATTRIBUTE_CATEGORY_CODE and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield (DFF) columns, providing extensibility for site-specific ITC attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard Oracle audit columns tracking who created and last modified each rate row.

The remaining columns round out the 26-column structure and support the same referential and audit purposes, but the columns above constitute the practical core used in ITC calculation and reporting.

Common Use Cases and Queries

FA_ITC_RATES is typically queried to resolve the credit rate and basis reduction applicable to a given asset addition, tax year, and asset life. A representative lookup follows:

• Selecting the applicable rate row: SELECT itc_amount_id, tax_year, life_in_months, itc_amount_rate, basis_reduction_rate FROM fa_itc_rates WHERE tax_year = :year AND life_in_months = :life;
• Joining to the owning book to reconcile credits assigned at book level: SELECT b.book_type_code, r.itc_amount_id, r.itc_amount_rate FROM fa_books b JOIN fa_itc_rates r ON b.itc_amount_id = r.itc_amount_id;
• Populating or validating tax interface records before transfer to the tax engine, using the FA_TAX_INTERFACE.ITC_AMOUNT_ID relationship.
• Finding all books or book groups referencing a specific ITC rate, supporting audits and impact analysis when a rate is superseded.

Related Objects

The FK metadata documents the following significant dependents, all joining through ITC_AMOUNT_ID:

• FA_BOOKS — FA_BOOKS.ITC_AMOUNT_ID references FA_ITC_RATES, associating the applicable ITC rate with a depreciation book.
• FA_MC_BOOKS — FA_MC_BOOKS.ITC_AMOUNT_ID links the rate to multiple reporting currencies for a book.
• FA_TAX_INTERFACE — FA_TAX_INTERFACE.ITC_AMOUNT_ID carries the rate reference into the tax interface for external tax processing.
• FA_BOOKS_GROUPS and FA_MC_BOOKS_GROUPS — these reference the rate at the book-group level, enabling shared ITC treatment across grouped books.
• FA_ADJUSTMENTS_T — FA_ADJUSTMENTS_T.ITC_AMOUNT_ID associates ITC rate information with asset adjustment transactions.

Together these relationships establish FA_ITC_RATES as a central reference hub for investment tax credit computation across books, book groups, adjustments, and the tax interface in Oracle Assets.