Results for “method_id”

8 results




Overview
Explore in AI Chat

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

Overview

FA_FORMULAS is a table in the FA (Assets) schema of Oracle E-Business Suite, belonging to the OFA - Assets product family. It stores the depreciation rates and formula definitions that drive formula-based depreciation methods. Where a standard method such as straight-line or declining balance relies on fixed rates, a formula-based method requires a stored expression that Oracle Assets evaluates to derive the periodic depreciation amount. FA_FORMULAS holds those expressions together with the computed and displayed rates used during depreciation processing.

The table is owned by the FA schema and is present and valid in both Oracle EBS 12.1.1 and 12.2.2. Its primary key is FA_FORMULAS_PK, defined on METHOD_ID. A foreign key from FA_FORMULAS.METHOD_ID references FA_METHODS, tying each formula row to the depreciation method it implements. Under the heuristic Data Vault classification mined from the foreign key structure, this table is satellite-leaning: it carries descriptive attributes keyed to a parent business entity (the method) rather than representing an independent hub or a many-to-many link. In practice, FA_FORMULAS is best modeled as a satellite of the depreciation method, with METHOD_ID as the parent key.

Key Information Stored

The table contains 13 documented columns. The most significant are the following.

  • METHOD_ID — The surrogate primary key (FA_FORMULAS_PK) and foreign key to FA_METHODS. It identifies the depreciation method to which the formula belongs.
  • FORMULA_ACTUAL — The actual formula expression used by Oracle Assets when computing depreciation. This is the operative definition for the method.
  • FORMULA_DISPLAYED — The user-facing representation of the formula, typically the formatted or readable version shown in the Assets setup forms.
  • FORMULA_PARSED — The parsed or compiled form of the formula, used internally for evaluation. It may differ from both the actual and displayed versions.
  • ORIGINAL_RATE — The original rate associated with the formula-based method, as defined at setup time.
  • REVISED_RATE — The revised rate, applied when the method's rates are adjusted after initial definition.
  • GUARANTEE_RATE — The guarantee rate, used in methods where a minimum or guaranteed depreciation amount applies.
  • ZD_EDITION_NAME — The edition name column characteristic of Oracle's edition-based redefinition (EBR) and multi-tenant support. It participates in the unique index FA_FORMULAS_U1 (METHOD_ID, ZD_EDITION_NAME), which is the business-key candidate for the table.
  • CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard Oracle EBS audit columns tracking who created and last modified the row and when.

The surrogate key is METHOD_ID; the business-key candidate is the combination of METHOD_ID and ZD_EDITION_NAME as defined by FA_FORMULAS_U1. The audit columns are informational and are not part of either key.

Common Use Cases and Queries

FA_FORMULAS is primarily referenced during depreciation setup and troubleshooting of formula-based methods. Typical scenarios include verifying which formula a method uses, reconciling rates applied to assets, and auditing formula changes across editions.

  • Retrieve the formula for a given method: SELECT METHOD_ID, FORMULA_DISPLAYED, FORMULA_ACTUAL, ORIGINAL_RATE, REVISED_RATE FROM FA_FORMULAS WHERE METHOD_ID = :method_id;
  • Join to the method definition: SELECT m.METHOD_CODE, m.DESCRIPTION, f.FORMULA_DISPLAYED, f.GUARANTEE_RATE FROM FA_METHODS m, FA_FORMULAS f WHERE m.METHOD_ID = f.METHOD_ID;
  • Identify methods using a guarantee rate: SELECT METHOD_ID, GUARANTEE_RATE FROM FA_FORMULAS WHERE GUARANTEE_RATE IS NOT NULL;
  • Edition-aware reporting: filter on ZD_EDITION_NAME to isolate the active edition when EBR is enabled.
  • Audit trail review: order by LAST_UPDATE_DATE to find recently modified formulas.

These queries support depreciation setup validation, financial reconciliation, and internal control reporting over asset depreciation methodology.

Related Objects

The most significant related objects are the parent method definition and the downstream depreciation objects that consume the rates and formulas defined here.

  • FA_METHODS — The parent table; joined via FA_FORMULAS.METHOD_ID = FA_METHODS.METHOD_ID. This is the documented foreign key relationship.
  • FA_METHODS_B / FA_METHODS_TL — Base and translation tables holding the method code and description referenced alongside the formula.
  • FA_BOOK_CONTROLS — The depreciation books that assign methods, indirectly determining which formulas apply to a given book's assets.
  • FA_ADDITIONS_B — The asset definition table whose assets inherit depreciation behavior from the assigned method and its formula.
  • FA_DEPRN_SUMMARY — The depreciation results table, reconciled against the rates produced by the referenced formula.
  • FA_DEPRN_DETAIL — The detailed depreciation line table, used when tracing how a formula-produced rate was applied.
  • FA_FORMULAS_PK and FA_FORMULAS_U1 — The primary key and unique index that enforce row identity and edition uniqueness.

Together these objects form the chain from method definition (FA_METHODS) through formula storage (FA_FORMULAS) to depreciation application and reporting (FA_DEPRN_SUMMARY, FA_DEPRN_DETAIL).