Search Results fa_price_indexes




Overview
Explore in AI Chat

Overview

FA_PRICE_INDEXES is a general price index information table owned by the FA schema within the Oracle E-Business Suite Assets (OFA) module. It stores the master definitions of price indexes used to revalue asset costs under inflation-adjusted accounting conventions, such as the revaluation rules applied in highly inflationary economies. Each row defines a distinct price index that Oracle Assets can subsequently reference when computing revaluation adjustments for asset books and categories.

From a data modeling perspective, the table exhibits a hub-leaning structure, as classified heuristically from its foreign-key topology. The ETRM data vault classification places FA_PRICE_INDEXES as a candidate hub, meaning it functions as a primary business entity referenced by dependent tables rather than one that merely carries descriptive attributes of another subject. This suggested modeling role reflects the fact that multiple foreign tables point back to the index definition, and that the definition itself is stable and independently identifiable.

Key Information Stored

The table contains 23 documented physical columns. The most significant include:

Two unique indexes qualify as business-key candidates: FA_PRICE_INDEXES_U1 on PRICE_INDEX_ID (the primary identifier) and FA_PRICE_INDEXES_U2 on PRICE_INDEX_NAME (the functional business name). Both the numeric key and the character name provide consistent, non-duplicated identification of a price index definition.

Common Use Cases and Queries

Typical scenarios involve joining index definitions to the periodic values held in FA_PRICE_INDEX_VALUES, or to book/category defaults that select a default index. A representative query joining definition to values is:

SELECT i.PRICE_INDEX_NAME, v.PRICE_INDEX_ID, v.PRICE_INDEX_VALUE
FROM FA.FA_PRICE_INDEXES i, FA.FA_PRICE_INDEX_VALUES v
WHERE i.PRICE_INDEX_ID = v.PRICE_INDEX_ID;

Another common pattern retrieves the index defaults configured for a category and book:

SELECT d.CATEGORY_ID, d.BOOK_TYPE_CODE, d.PRICE_INDEX_NAME
FROM FA.FA_CATEGORY_BOOK_DEFAULTS d, FA.FA_PRICE_INDEXES i
WHERE d.PRICE_INDEX_NAME = i.PRICE_INDEX_NAME;

Reporting uses include listing all defined indexes for revaluation setup review, validating that every defaulted index name has a corresponding definition, and reconciling the audit columns to identify recently modified index definitions before a period close.

Related Objects

  • FA_PRICE_INDEX_VALUES — references FA_PRICE_INDEXES via PRICE_INDEX_ID; holds the time-series values for each index.
  • FA_CATEGORY_BOOK_DEFAULTS — references FA_PRICE_INDEXES via PRICE_INDEX_NAME; stores the default index assigned to a category/book combination.
  • FA_PRICE_INDEXES_PK — the primary-key constraint on PRICE_INDEX_ID.
  • FA_PRICE_INDEXES_U1 — the unique index on PRICE_INDEX_ID.
  • FA_PRICE_INDEXES_U2 — the unique index on PRICE_INDEX_NAME.

These dependencies confirm that FA_PRICE_INDEXES acts as a reference hub for both the index-value satellite data and the book/category default configuration in the Oracle Assets revaluation subsystem.