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.
-
Annual depreciation rates for life-based depreciation methods
-
Annual depreciation rates for life-based depreciation methods
-
TABLE: FA.FA_RATES 12.2.2
-
SYNONYM: APPS.FA_RATES 12.1.1
-
SYNONYM: APPS.FA_RATES 12.2.2
-
TABLE: FA.FA_RATES 12.1.1
-
VIEW: FA.FA_RATES# 12.2.2
-
PACKAGE: APPS.FA_RATES_PKG 12.2.2
-
TRIGGER: APPS.FA_RATES+ 12.2.2
-
TRIGGER: APPS.FA_RATES+ 12.2.2
-
PACKAGE: APPS.FA_RATES_PKG 12.1.1
-
FUNCTION: APPS.FA_RATES= 12.2.2
-
VIEW: FA.FA_RATES# 12.2.2
-
FUNCTION: APPS.FA_RATES= 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
PACKAGE: APPS.JGRX_FAREG 12.1.1
-
PACKAGE: APPS.JGRX_FAREG 12.2.2
-
TABLE: FA.FA_METHODS 12.2.2
-
PACKAGE: APPS.FA_CDE_PKG 12.1.1
-
PACKAGE: APPS.FA_CDE_PKG 12.2.2
-
12.2.2 DBA Data 12.2.2