Results for “revaluation_id”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGI_IAC_REVAL_CATEGORIES table is a component of the IGI – Public Sector Financials International product suite in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the asset category information associated with an individual asset revaluation run executed through the IGI revaluation and inflation accounting functionality. In the Oracle Assets revaluation process, each revaluation event is scoped to particular asset categories; this table records which categories participated in a given revaluation, preserving the association between the revaluation identifier and the selected category.

The table resides in the IGI schema and is classified as VALID in the ETRM data model registry. Under the heuristic Data Vault classification mined from its foreign key structure, the object is described as satellite-leaning. In Data Vault modeling terms, this suggests the table behaves as a descriptive satellite attached to a parent revaluation hub, capturing the category-level attributes and qualifying context of a revaluation transaction rather than representing an independent business entity. It should therefore generally be joined back to its parent revaluation record to derive full meaning.

Key Information Stored

The table contains nine documented columns. The most important are grouped below:

  • REVALUATION_ID — Identifier of the parent revaluation run. This is the principal joining column, and the search term "revaluation_id" directly targets it.
  • BOOK_TYPE_CODE — The asset book in which the revaluation applies, distinguishing category participation across multiple books.
  • CATEGORY_ID — The asset category included in the revaluation, referencing the category definition in Oracle Assets.
  • SELECT_CATEGORY — A selection indicator or descriptive flag denoting whether the category was chosen for the revaluation run.
  • CREATED_BY, CREATION_DATE — Standard audit columns recording the creating user and timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification user, timestamp, and login identifier.

The primary key, IGI_IAC_REVAL_CATEGORIES_PK, is a composite of REVALUATION_ID, BOOK_TYPE_CODE, and CATEGORY_ID. This composite constitutes the business-key candidate unique index: exactly one row exists per revaluation, book, and category combination. No separate surrogate key column is documented, so the composite acts as both the primary key and the natural unique identifier. REVALUATION_ID additionally carries a foreign key relationship (documented as referencing the parent revaluation structure) and is the first column of the primary key, confirming its role as the dominant access path.

Common Use Cases and Queries

The most frequent access pattern is retrieving the categories belonging to a specific revaluation run, typically driven by the revaluation_id value:

  • Category listing by revaluation: SELECT category_id, book_type_code, select_category FROM igi.igi_iac_reval_categories WHERE revaluation_id = :reval_id;
  • Book-scoped filtering: Because the primary key includes BOOK_TYPE_CODE, queries that restrict by both revaluation and book take full advantage of index access.
  • Audit and lineage reporting: The standard WHO columns support reconciliation reports showing who created or last modified a revaluation's category scope.
  • Validation of run scope: Before executing or re-executing a revaluation, the presence of expected categories can be validated by comparing this table against the category definitions in Oracle Assets.
  • Impact analysis: Joining this table to asset-level revaluation detail allows reporting on which categories contributed to specific revaluation outcomes.

Related Objects

The most significant related objects, grounded in the documented FK relationship and the parent revaluation structure, include:

  • IGI_IAC_REVALUATIONS (or equivalent parent revaluation table) — joined via REVALUATION_ID; supplies run-level attributes.
  • FA_CATEGORIES_B — Oracle Assets category definitions, joined via CATEGORY_ID.
  • FA_BOOK_CONTROLS — book definitions, joined via BOOK_TYPE_CODE.
  • FA_ADDITIONS_B / FA_BOOKS — asset-level revaluation context resolved through category and book.
  • IGI_IAC_ADJUSTMENTS and related IGI inflation accounting tables — depend on the revaluation and category scope recorded here.

The composite primary key and the REVALUATION_ID foreign key make this table a dependable bridge between revaluation header data and asset category metadata, and it is central to any query that resolves "revaluation_id" to its participating categories.