Search Results fa_flat_rates_pk

Overview

FA_FLAT_RATES is a standard Oracle E-Business Suite table owned by the FA schema and delivered under the OFA – Assets product. Its documented purpose is to store the annual depreciation rates that apply to all flat-rate depreciation methods defined in Oracle Assets. Where FA_METHODS establishes the depreciation method header and its associated rules, FA_FLAT_RATES supplies the periodic rate values that the depreciation engine consumes when calculating expense for assets assigned to a flat-rate method.

In Oracle EBS 12.1.1 and 12.2.2, the table is registered as VALID in the ETRM data dictionary and exposes 26 physical columns. The relationship metadata classifies FA_FLAT_RATES as satellite-leaning under a heuristic Data Vault model. This is a modeling suggestion only: the table behaves as a dependent child that captures descriptive rate attributes hanging off the FA_METHODS business key rather than as an independent hub or an associative link between two hubs. The presence of METHOD_ID as a foreign key to FA_METHODS reinforces this satellite interpretation, since the rate rows are meaningless without their parent method.

Key Information Stored

The most significant columns concern method identity and rate values:

• METHOD_ID – Foreign key to FA_METHODS. Identifies the flat-rate depreciation method to which the rate row belongs.
• BASIC_RATE – The base annual depreciation rate tied to the method.
• ADJUSTED_RATE – The adjusted annual rate applied after method-specific adjustments, and part of the primary key.
• ADJUSTING_RATE – A distinct rate column separate from the adjusted rate, supporting adjustment logic.
• ZD_EDITION_NAME – Editioning column used for online patching and edition-based redefinition, particularly relevant in 12.2.x.
• ATTRIBUTE_CATEGORY_CODE and ATTRIBUTE1–ATTRIBUTE15 – The standard Oracle EBS descriptive flexfield (DFF) columns for extensible, customer-defined rate attributes.
• CREATED_BY / CREATION_DATE and LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN – Standard WHO audit columns recording creation and change history.

The physical primary key is FA_FLAT_RATES_PK, defined over METHOD_ID, BASIC_RATE, and ADJUSTED_RATE. A separate unique index, FA_FLAT_RATES_U1, extends the same column set with ZD_EDITION_NAME and represents the business-key candidate used for editioning-aware uniqueness. The surrogate primary key and this business key should not be conflated when writing joins.

Common Use Cases and Queries

FA_FLAT_RATES is primarily queried for depreciation method configuration reporting and troubleshooting. A common pattern retrieves all rates for a given method:

• Join to FA_METHODS on METHOD_ID to resolve the method name, then list BASIC_RATE, ADJUSTING_RATE, and ADJUSTED_RATE for review.
• Detect duplicate or conflicting rate definitions using the business-key columns before a period close.
• Reconcile depreciation expense by comparing the rate applied against the configured BASIC_RATE.
• Report DFF attributes (ATTRIBUTE_CATEGORY_CODE and ATTRIBUTE1–15) for audit or localization.
• Filter by ZD_EDITION_NAME when operating under 12.2.x online patching, ensuring only the active edition is selected.

Typical SQL joins FA_FLAT_RATES fr to FA_METHODS m on fr.METHOD_ID = m.METHOD_ID, selecting rate columns for a specific method. Because configuration changes are audited, LAST_UPDATE_DATE filters help isolate recently modified rates.

Related Objects

The following objects are most significant to FA_FLAT_RATES:

• FA_METHODS – Parent table; FA_FLAT_RATES.METHOD_ID references FA_METHODS. The primary join partner.
• FA_FLAT_RATES_PK – Primary key constraint over METHOD_ID, BASIC_RATE, ADJUSTED_RATE.
• FA_FLAT_RATES_U1 – Unique index (business-key candidate) adding ZD_EDITION_NAME.
• FA_DEPRN_SUMMARY – Stores depreciation results generated using these rates.
• FA_BOOKS – Defines the corporate and tax books whose methods reference these rates.
• FA_ASSET_HISTORY and FA_TRANSACTION_HISTORY – Reflect depreciation transactions whose amounts derive from flat-rate configuration.
• FA_METHODS API / depreciation engine – Internal program units that read FA_FLAT_RATES during depreciation run.

Together these objects frame FA_FLAT_RATES as a configuration-side satellite tightly bound to the FA_METHODS hub within the Oracle Assets depreciation model.