Search Results fa_price_index_values_pk

Overview

The FA_PRICE_INDEX_VALUES table is a core reference data object within the Oracle E-Business Suite (EBS) Assets module (OFA). It stores the individual price index values associated with each defined price index, allowing organizations to model inflationary or market-based valuation adjustments for asset books and mass revaluation processes. Each row represents a single index value effective for a defined date range, tied back to a parent price index definition.

The table is owned by the FA schema and is valid in both Oracle EBS 12.1.1 and 12.2.2. It is referenced heavily by the revaluation and mass additions functionality within Oracle Assets, where price indices are used to restate asset costs to current values.

Under a heuristic Data Vault classification derived from its foreign key structure, FA_PRICE_INDEX_VALUES is characterized as satellite-leaning. This suggests a modeling interpretation in which the table functions as a dependent, time-variant attribute store — the descriptive and historical behavior — for a parent business key represented by FA_PRICE_INDEXES. In Data Vault terms, it behaves similarly to a satellite: it carries descriptive values (the index value) keyed by a parent hub reference (PRICE_INDEX_ID) combined with an effective-dating attribute (FROM_DATE).

Key Information Stored

The table contains 20 documented columns. The most significant columns are:

• PRICE_INDEX_ID — Foreign key to FA_PRICE_INDEXES. Identifies the parent price index to which the value belongs. This column participates in both the primary key and the documented foreign key relationship.
• PRICE_INDEX_VALUE — The numeric index value applied for the given effective period. This is the central business attribute of the table.
• FROM_DATE — The effective start date of the index value. Combined with PRICE_INDEX_ID, this forms the composite primary key, defining uniqueness per index per period.
• TO_DATE — The effective end date of the index value, defining the validity window for the row.
• ATTRIBUTE_CATEGORY_CODE — Descriptive flexfield context, allowing users to define context-sensitive descriptive attributes.
• ATTRIBUTE1 through ATTRIBUTE15 — A set of 15 generic descriptive flexfield columns used to capture organization-specific, user-defined index metadata. These are frequently leveraged during implementation to store additional reference characteristics beyond the standard value and date range.

The primary key, FA_PRICE_INDEX_VALUES_PK, is a composite surrogate key built from PRICE_INDEX_ID and FROM_DATE. There is no separate single-column surrogate. PRICE_INDEX_ID is the key business-foreign identifier, while FROM_DATE supplies the temporal dimension, ensuring a single value per index per effective period.

Common Use Cases and Queries

Typical use cases center on reporting and validating price index data that drives asset revaluation. Common scenarios include:

• Retrieving the current (latest) index value for a given price index, useful for revaluation calculations.
• Auditing historical index values across periods for compliance or reconciliation.
• Validating that no gaps or overlaps exist in the FROM_DATE/TO_DATE ranges for a price index.
• Feeding downstream revaluation reports and mass revaluation program inputs.

A representative query to retrieve the latest value for a specific index:

SELECT piv.price_index_id, piv.from_date, piv.to_date, piv.price_index_value
FROM fa_price_index_values piv
WHERE piv.price_index_id = :index_id
AND piv.from_date = (SELECT MAX(piv2.from_date) FROM fa_price_index_values piv2 WHERE piv2.price_index_id = piv.price_index_id);

A join to the parent index name is also common:

SELECT fpi.price_index_name, piv.from_date, piv.to_date, piv.price_index_value
FROM fa_price_index_values piv, fa_price_indexes fpi
WHERE piv.price_index_id = fpi.price_index_id
ORDER BY fpi.price_index_name, piv.from_date;

Related Objects

The most significant related object is its parent table, which this table directly references via foreign key. Other related objects are inferred from Oracle Assets module dependencies:

• FA_PRICE_INDEXES — Parent table; joined on PRICE_INDEX_ID. Holds the definition of each price index. This is the direct FK target documented in the metadata.
• FA_BOOKS — Asset books that reference price indices for revaluation of asset costs.
• FA_MASS_ADDITIONS — May reference price indices during mass revaluation processing.
• FA_REVALUATIONS — Revaluation records whose computations depend on index values from this table.
• FA_ADJUSTMENTS — Adjustment transactions generated from revaluation using index values.
• FA_DEPRN_SUMMARY and FA_ASSET_HISTORY — Downstream tables reflecting post-revaluation asset costs influenced by these index values.

The primary documented reference relationship is the foreign key from FA_PRICE_INDEX_VALUES.PRICE_INDEX_ID to FA_PRICE_INDEXES, confirming the parent-child dependency that anchors this satellite-style reference data within the Oracle Assets schema.