Search Results igi_iac_transaction_headers




Overview
Explore in AI Chat

Overview

IGI.IGI_IAC_TRANSACTION_HEADERS is a table within the IGI – Public Sector Financials International product family of Oracle E-Business Suite. It functions as the transaction header store for the International Assets Conversion (IAC) subsystem, holding the details of transactions performed against all assets. Each row represents a discrete asset transaction executed through the IAC adjustment framework, carrying the transaction type, sub-type, posting period, depreciation start information, and the associated asset and category references required by the fixed assets integration.

From a Data Vault modeling perspective, the ETRM heuristic classifies this object as hub-leaning, mined from its foreign key structure. In practical terms this suggests the table behaves primarily as a key-bearing entity centered on the adjustment identifier, with descriptive attributes attached. This classification should be treated as a modeling suggestion rather than a documented Oracle design decision. The table resides in the IGI schema and is marked VALID in the applications data dictionary, with a documented physical schema of twenty columns in ETRM 12.2.2.

Key Information Stored

The documented metadata exposes twenty columns; the following are the most operationally significant:

  • ADJUSTMENT_ID – the primary key column of the table, defined by the constraint IGI_IAC_TRANS_ADJUSMENT. It also serves as the target of a foreign key from IGI_IAC_ADJUSTMENTS.ADJUSTMENT_ID, making it the principal integration point with the adjustment master data.
  • TRANSACTION_HEADER_ID – a surrogate identifier for the transaction header record itself, useful when the adjustment context is not the primary grain of a query.
  • ADJUSTMENT_ID_OUT – an outbound adjustment reference, typically used to trace offsetting or paired adjustments generated by the IAC process.
  • TRANSACTION_TYPE_CODE and TRANSACTION_SUB_TYPE – the classification of the transaction performed against the asset, distinguishing the nature of the adjustment activity.
  • TRANSACTION_DATE_ENTERED – the date the transaction was captured into the system, distinct from the accounting period to which it applies.
  • BOOK_TYPE_CODE – identifies the asset book (for example, a corporate or tax book) against which the transaction is recorded.
  • ASSET_ID and CATEGORY_ID – references to the affected asset and its asset category, enabling joins to the fixed assets hierarchy.
  • ADJ_DEPRN_START_DATE – the depreciation start date resulting from the adjustment, critical for period-based depreciation recalculation.
  • REVALUATION_TYPE_FLAG – indicates whether the transaction relates to a revaluation, an important distinction for public sector reporting.
  • ADJUSTMENT_STATUS – the workflow or processing state of the transaction header, used to filter posted versus pending transactions.
  • PERIOD_COUNTER – the accounting period reference, the standard join key to the period and calendar tables.
  • MASS_REFERENCE_ID and EVENT_ID – references to the mass transaction grouping and the underlying business event used by the IAC processing and accounting engines.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – the standard Oracle EBS WHO audit columns for row-level change tracking.

Common Use Cases and Queries

This table is typically queried when reconciling IAC asset adjustments, investigating transactions that failed to post to the general ledger, or reporting on asset movements by book and period. A representative pattern joins the header to the adjustment master and to the period reference:

  • Adjustment reconciliation – SELECT h.adjustment_id, h.transaction_type_code, h.adjustment_status, h.transaction_date_entered FROM igi.igi_iac_transaction_headers h WHERE h.book_type_code = :book AND h.period_counter = :period;
  • Status exception reporting – counting headers by ADJUSTMENT_STATUS and TRANSACTION_SUB_TYPE to surface unprocessed activity.
  • Depreciation impact analysis – grouping by ADJ_DEPRN_START_DATE and REVALUATION_TYPE_FLAG to model the depreciation consequences of adjustments.
  • Traceability queries – following ADJUSTMENT_ID_OUT and MASS_REFERENCE_ID to reconstruct the chain of related transactions.

Because the table is IGI-owned and populated by the IAC concurrent programs, read-only reporting is strongly recommended; direct DML should be avoided.

Related Objects

  • IGI_IAC_ADJUSTMENTS – the principal related table; joined on IGI_IAC_ADJUSTMENTS.ADJUSTMENT_ID = IGI_IAC_TRANSACTION_HEADERS.ADJUSTMENT_ID, supplying the adjustment definition referenced by this header.
  • Fixed Assets tables (FA) – FA_ADDITIONS supplies asset detail for ASSET_ID, and FA_CATEGORIES supplies category detail for CATEGORY_ID; FA_BOOK_CONTROLS anchors BOOK_TYPE_CODE.
  • Period and calendar references – the period identified by PERIOD_COUNTER resolves against the standard EBS period tables used throughout General Ledger and Fixed Assets.
  • IAC processing programs – the concurrent processes in the IGI product module that create and update these transaction header rows, and which consume EVENT_ID and MASS_REFERENCE_ID during accounting generation.
  • IGI adjustment views and public APIs – reporting views layered over the IAC adjustment and transaction data expose this table's columns for inquiry and extract purposes without direct base-table access.

Together these objects form the IAC adjustment transaction model, with IGI_IAC_TRANSACTION_HEADERS acting as the transaction-grain header that ties asset adjustments to books, periods, and accounting events.