Results for “revaluation_period”

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

Overview

The IGI.IAC_REVALUATIONS table is a core data object within the IGI – Public Sector Financials International product family of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It stores information about revaluations performed for an asset book and an accounting period, providing the transactional backbone for the International Accounting Standards (IAS) revaluation functionality used by public sector and international organizations to restate asset carrying values in accordance with fair value or current cost accounting models. Each row in the table represents a discrete revaluation event tied to a specific book and period, capturing both the request lifecycle and the final accounting impact.

From a data modeling perspective, the heuristic Data Vault classification for this table is standalone, meaning it exhibits no documented foreign key dependencies to other tables within the mined relationship structure. In Data Vault terms, this suggests the table functions as a self-contained hub-like entity, where REVALUATION_ID acts as the business entity identifier. Because the relationship mining returned no FK links, the table may be treated as an independent hub, though integration with asset book and period dimensions would typically be handled at the application layer rather than through enforced constraints.

Key Information Stored

The physical schema documents 14 columns. The most significant are:

• REVALUATION_ID — The surrogate primary key, enforced by IGI_IAC_REVALUATIONS_PK, uniquely identifying each revaluation record.
• BOOK_TYPE_CODE — Identifies the asset book to which the revaluation applies, a primary business-key candidate for joining to book definition tables.
• REVALUATION_DATE — The effective date on which the revaluation is recognized.
• REVALUATION_PERIOD — The accounting period associated with the revaluation, establishing the reporting timeframe.
• STATUS — The current processing state of the revaluation (for example, pending, in process, completed, or failed).
• REVAL_REQUEST_ID — The identifier of the originating revaluation request, linking the row to the user-initiated request.
• CREATE_REQUEST_ID — The concurrent request identifier that created or processed the revaluation.
• CALLING_PROGRAM — The name of the program that invoked the revaluation process.
• EVENT_ID — A reference to the accounting event generated by the revaluation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns providing audit and concurrency information.

Business-key uniqueness is likely defined on the combination of BOOK_TYPE_CODE, REVALUATION_PERIOD, and REVALUATION_DATE, though the primary key remains the surrogate REVALUATION_ID.

Common Use Cases and Queries

Typical reporting scenarios include reconciling revaluations by book and period, auditing the request lifecycle, and tracing accounting events. A sample query retrieving completed revaluations for a book and period follows:

• SELECT revaluation_id, book_type_code, revaluation_date, revaluation_period, status FROM igi.igi_iac_revaluations WHERE book_type_code = :p_book AND revaluation_period = :p_period AND status = 'COMPLETED';
• Auditing user activity: select rows by CREATED_BY and LAST_UPDATE_DATE to trace who initiated a revaluation.
• Tracing concurrent processing: join on CREATE_REQUEST_ID against FND_CONCURRENT_REQUESTS to review request outcomes.
• Drill-down to accounting events: query by EVENT_ID to reconcile subledger accounting entries.

Related Objects

Although the mined relationship data classifies this table as standalone (no documented foreign keys), functionally it interacts with several IGI and Oracle Assets objects. Key related objects include:

• FA_BOOK_CONTROLS — joined on BOOK_TYPE_CODE to obtain book details.
• FA_BOOKS — for asset book configuration.
• FND_CONCURRENT_REQUESTS — linked by CREATE_REQUEST_ID to trace submission.
• IGI_IAC_REVAL_LINES — presumed child table holding per-asset revaluation lines.
• XLA_EVENTS / XLA_AE_HEADERS — linked via EVENT_ID for accounting event details.
• FA_ADDITIONS — asset-level detail referenced indirectly through revaluation lines.
• GL_PERIODS — joined on REVALUATION_PERIOD for period validation.

Administrators should note that no enforced foreign keys are documented, so referential integrity is maintained by the application logic rather than the database.