Search Results fa_flat_rates_u1

Overview

The FA.FA_FLAT_RATES table is a seed data object within the Oracle E-Business Suite Fixed Assets (FA) schema. It stores the flat-rate configuration used by depreciation methods that apply a constant periodic rate rather than a calculated, life-based rate. Records in this table define the basic rate, any adjusting rate, and the resulting adjusted rate applied to an asset cost during depreciation processing. Because the table resides in the APPS_TS_SEED tablespace, it is classified as reference or setup data rather than transactional data, and it is typically populated during implementation or when new flat-rate depreciation methods are configured.

From a Data Vault modeling perspective, the mined relationship structure suggests a satellite-leaning classification. The table carries descriptive rate attributes keyed to a parent depreciation method, which aligns with the role of a satellite attached to the FA_METHODS hub. This classification is a modeling suggestion only; in Oracle EBS the object is a conventional setup table with a composite unique index rather than a formally modeled Data Vault construct.

Key Information Stored

The most significant columns in FA_FLAT_RATES are the rate-defining and key columns, supplemented by standard audit and descriptive attributes:

• METHOD_ID — Numeric (15) identifier of the parent depreciation method. This is the foreign key referencing FA_METHODS and the principal join column.
• BASIC_RATE — The base flat rate applied by the depreciation method.
• ADJUSTING_RATE — A secondary rate used to modify the basic rate.
• ADJUSTED_RATE — The net or resultant rate after adjustment, used directly in depreciation calculations.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing record creation and maintenance history.
• ATTRIBUTE_CATEGORY_CODE and ATTRIBUTE1–ATTRIBUTE15 — The flexible descriptive flexfield (DFF) columns, with fifteen VARCHAR2(150) segments plus a context code, allowing client-specific rate metadata to be captured.
• ZD_EDITION_NAME — The edition column used in the 12.2.2 online patching (Editioning) architecture.

The documented physical schema carries a composite primary key, FA_FLAT_RATES_PK, over METHOD_ID, BASIC_RATE, and ADJUSTED_RATE. The unique index FA_FLAT_RATES_U1 covers METHOD_ID, BASIC_RATE, ADJUSTED_RATE, and ZD_EDITION_NAME, making this the business-key candidate and enforcing that a single method cannot carry duplicate rate combinations within the same edition.

Common Use Cases and Queries

Typical scenarios include verifying which rates are attached to a given depreciation method, auditing rate changes for statutory reporting, and joining flat-rate configuration to asset books and categories to explain computed depreciation. A common query pattern joins FA_FLAT_RATES to FA_METHODS on METHOD_ID:

• Listing all rates for a depreciation method: SELECT method_id, basic_rate, adjusting_rate, adjusted_rate FROM fa.fa_flat_rates WHERE method_id = :method_id;
• Reporting methods that share identical basic rates: SELECT basic_rate, COUNT(*) FROM fa.fa_flat_rates GROUP BY basic_rate HAVING COUNT(*) > 1;
• Auditing recent maintenance: SELECT method_id, last_updated_by, last_update_date FROM fa.fa_flat_rates ORDER BY last_update_date DESC;
• Joining to the method definition to display method names alongside rates for setup validation.

Because this is setup data, queries are generally read-only in production; modifications should be made through the Fixed Assets setup forms to preserve integrity and trigger any dependent validation.

Related Objects

The following objects are the most significant dependencies and related entities:

• FA_METHODS — Parent table referenced through METHOD_ID; holds depreciation method definitions such as method type, life, and computation basis.
• FA_FLAT_RATES (APPS synonym) — The APPS-owned synonym through which application code and reports access the FA schema table.
• FA_BOOKS and FA_BOOK_CONTROLS — Book-level setup that associates methods with rate processing behavior.
• FA_CATEGORIES and FA_CATEGORY_BOOKS — Category defaults that determine which methods and rates apply to an asset.
• FA_DEPRN_DETAIL and FA_DEPRN_SUMMARY — Depreciation output tables where the resulting rates are applied and recorded.
• FA_ADJUSTMENTS — Transactions affecting cost or rate application that may reference the configured flat rates.

Together these objects form the configuration and processing chain through which flat-rate depreciation is defined and executed in Oracle EBS 12.1.1 and 12.2.2.