Results for “fa_rates”

50+ results




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

Overview

FA_RATES is a reference table in the Oracle E-Business Suite Assets (OFA) module, owned by the FA schema. It stores the annual depreciation rate values applied by life-based depreciation methods. Depreciation methods such as straight-line, declining balance, and sum-of-years-digits require a rate percentage for each year of an asset's life; FA_RATES holds those percentages in a normalized, year-by-year form so the depreciation engine can retrieve the correct rate for a given method, fiscal year, and period of placement in service. The table is therefore a core lookup consumed during depreciation calculation, and its correctness directly affects posted depreciation expense.

From a dimensional modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification: FA_RATES hangs off FA_METHODS via METHOD_ID and carries descriptive measures (RATE) rather than acting as an independent hub or an associative link between two hubs. This is offered as a heuristic suggestion only; the table does not carry Oracle's own Data Vault labeling.

Key Information Stored

The table contains ten documented columns. The composite primary key, FA_RATES_PK, is defined over METHOD_ID, YEAR, and PERIOD_PLACED_IN_SERVICE, which together determine a single rate row. A second unique index, FA_RATES_U1, extends this tuple with ZD_EDITION_NAME, reflecting the editioning column used in the 12.2 online patching architecture. The business-key candidate for this table is therefore METHOD_ID + YEAR + PERIOD_PLACED_IN_SERVICE (with ZD_EDITION_NAME as an editioning qualifier), not a single surrogate column.

  • METHOD_ID — identifier of the depreciation method in FA_METHODS that owns the rate; part of the primary key and the FK to FA_METHODS.
  • YEAR — the year of asset life for which the rate applies (for example, year 1, year 2, and so on); part of the composite primary key.
  • PERIOD_PLACED_IN_SERVICE — the period in which the asset was placed in service, allowing different rate schedules for assets acquired at different points in the fiscal year; part of the composite primary key.
  • RATE — the annual depreciation rate (a percentage/number value) applied for the given method, year, and placement period.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle WHO columns recording the last modification audit trail.
  • CREATED_BY, CREATION_DATE — standard WHO columns recording initial row creation.
  • ZD_EDITION_NAME — editioning column supporting the 12.2 online patching (edition-based redefinition) model; included in the FA_RATES_U1 unique index.

Common Use Cases and Queries

Typical usage centers on validating or reporting the rate schedule associated with a depreciation method. A common query joins FA_RATES back to FA_METHODS to resolve the method name, filtering by method and year to inspect the rate ladder:

  • Verify rate completeness — confirm that every year of a method's life has a row, and that rates sum appropriately for the method type.
  • Audit changes — report rows where LAST_UPDATE_DATE or LAST_UPDATED_BY fall within a specific window to trace who altered a rate schedule.
  • Depreciation reconciliation — join to FA_METHODS to map METHOD_ID to the human-readable method name and reconcile calculated depreciation against stored rates.
  • Sample SQL pattern: SELECT m.method_name, r.year, r.period_placed_in_service, r.rate FROM fa.fa_rates r JOIN fa.fa_methods m ON m.method_id = r.method_id WHERE r.method_id = :method_id ORDER BY r.year, r.period_placed_in_service;

Because rates are consumed by the depreciation engine, any reporting on this table should respect the ZD_EDITION_NAME editioning column when running under 12.2 to avoid reading stale or cross-edition rows.

Related Objects

The most significant dependency is FA_METHODS, the parent of the FA_RATES.METHOD_ID foreign key, which defines the depreciation method header that these annual rates belong to. Beyond that direct FK relationship, FA_RATES is consumed indirectly by the broader Assets depreciation objects that resolve method rates during calculation. Key related objects include:

  • FA_METHODS — parent table; joined on FA_RATES.METHOD_ID = FA_METHODS.METHOD_ID.
  • FA_RATES_PK and FA_RATES_U1 — the primary key constraint and unique index enforcing row uniqueness on (METHOD_ID, YEAR, PERIOD_PLACED_IN_SERVICE) and its editioned variant.
  • FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL — depreciation result tables whose calculated amounts derive from the rates held here.
  • FA_BOOK_CONTROLS — defines the books whose methods reference these rates.
  • FA_ASSET_DEPRN APIs and the Assets depreciation program — runtime consumers that look up method rates when processing assets.