Search Results fa_price_index_values




Overview
Explore in AI Chat

Overview

The FA_PRICE_INDEX_VALUES table is a core data repository within the Oracle E-Business Suite (EBS) Fixed Assets (OFA) module, specifically for versions 12.1.1 and 12.2.2. It serves the critical function of storing the historical and current values for defined price indexes. These indexes are essential for the asset revaluation process, a key accounting practice that adjusts the book value of assets to reflect their current fair market value. The table enables the system to track the precise index value applicable for any given period, ensuring accurate and auditable revaluation calculations.

Key Information Stored

The table's primary purpose is to maintain a time-series of values for each price index. Its structure is defined by its composite primary key and the value it tracks. The most critical columns include:

  • PRICE_INDEX_ID: A foreign key that uniquely identifies the specific price index, as defined in the parent table FA_PRICE_INDEXES. This links the index value to its master definition.
  • FROM_DATE: The effective start date from which the associated index value becomes applicable. This column, combined with PRICE_INDEX_ID, forms the table's primary key, ensuring only one value per index per effective date.
  • PRICE_INDEX_VALUE (implied by the table's description): Although not explicitly listed in the provided metadata, this is the core data column that stores the numerical value of the price index as of the FROM_DATE. This value is used in revaluation formulas.

Common Use Cases and Queries

This table is primarily accessed during asset revaluation runs and for reporting on index trends. A common operational use case is retrieving the valid index value for a specific index and target revaluation date. For example, to find the value for index 100 effective on January 1, 2023, a query would be: SELECT price_index_value FROM fa_price_index_values WHERE price_index_id = 100 AND from_date = (SELECT MAX(from_date) FROM fa_price_index_values WHERE price_index_id = 100 AND from_date <= TO_DATE('01-JAN-2023','DD-MON-YYYY')); Financial reporting often requires analyzing the progression of an index over time, which involves querying all records for a given PRICE_INDEX_ID ordered by FROM_DATE. This data is fundamental for generating audit trails that justify revaluation adjustments posted to the general ledger.

Related Objects

The FA_PRICE_INDEX_VALUES table has a direct and singular parent-child relationship within the Fixed Assets schema, as documented in the provided metadata.

  • FA_PRICE_INDEXES: This is the primary related table. FA_PRICE_INDEX_VALUES.PRICE_INDEX_ID is a foreign key referencing FA_PRICE_INDEXES. The FA_PRICE_INDEXES table holds the master definition (name, description, type) of each index, while FA_PRICE_INDEX_VALUES holds its historical data points. A typical join for a comprehensive report would be: SELECT pix.name, piv.from_date, piv.price_index_value FROM fa_price_indexes pix, fa_price_index_values piv WHERE pix.price_index_id = piv.price_index_id;