Search Results fa_price_indexes




Overview
Explore in AI Chat

Overview

The FA_PRICE_INDEXES table is a core reference table within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It serves as the master repository for defining and storing general price index information. Price indexes are critical for calculating asset revaluations, particularly in environments with high inflation or for compliance with specific accounting standards that require periodic restatement of asset carrying values to reflect changes in the general price level. The table's primary role is to provide a centralized, validated list of indexes that can be associated with asset categories and books, enabling systematic and auditable revaluation processes.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the primary and foreign key relationships define the essential data structure. The central column is PRICE_INDEX_ID, which serves as the unique system identifier (primary key) for each index record. Based on standard EBS Fixed Assets table design and the foreign key relationships, the table also stores descriptive information for each index. This typically includes a PRICE_INDEX_NAME (a user-defined identifier referenced by FA_CATEGORY_BOOK_DEFAULTS) and other supporting columns such as a description, effective date range, and potentially a source or calculation method. The table acts as the parent definition for the detailed periodic index values stored in the related FA_PRICE_INDEX_VALUES table.

Common Use Cases and Queries

The primary use case is configuring the system for asset revaluation. An administrator defines a price index (e.g., "Consumer Price Index - US") in this table, then assigns it to specific asset category and book combinations via FA_CATEGORY_BOOK_DEFAULTS. During revaluation runs, the system retrieves the applicable index definition and its corresponding historical values to adjust asset costs. Common queries include listing all active price indexes for setup verification or identifying which asset categories use a specific index. A sample SQL pattern to retrieve basic index information might be:

  • SELECT price_index_id, price_index_name, description FROM fa_price_indexes WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);

Reporting use cases often involve joining this table to FA_PRICE_INDEX_VALUES to analyze index trends over time or to FA_CATEGORY_BOOK_DEFAULTS to audit revaluation setup.

Related Objects

The FA_PRICE_INDEXES table maintains documented foreign key relationships with two other critical Fixed Assets tables, as per the provided metadata:

  • FA_CATEGORY_BOOK_DEFAULTS: This table references FA_PRICE_INDEXES via the column FA_CATEGORY_BOOK_DEFAULTS.PRICE_INDEX_NAME. This relationship links a price index definition to the default settings for an asset category within a specific asset book, determining the revaluation method for assets assigned to that category and book.
  • FA_PRICE_INDEX_VALUES: This child table references FA_PRICE_INDEXES via the column FA_PRICE_INDEX_VALUES.PRICE_INDEX_ID. This is a direct one-to-many relationship where FA_PRICE_INDEXES stores the index header, and FA_PRICE_INDEX_VALUES stores the periodic (e.g., monthly, yearly) index factor values necessary for performing revaluation calculations.