Search Results igi_dos_trx_sources_hist




Overview
Explore in AI Chat

Overview

IGI_DOS_TRX_SOURCES_HIST is a table in the IGI schema (Public Sector Financials International) within Oracle EBS 12.1.1 and 12.2.2. It stores historical source transactions used by the IGI budgetary control and funds-checking engine to record the transactions that influenced budget balances, funds availability, and dossier processing. In effect, it acts as the archival counterpart to the operative source-transaction table, preserving prior states of each source record for audit, reconciliation, and year-end reporting across multiple sets of books.

From a Data Vault modeling heuristic, the FK structure suggests a satellite-leaning classification: the table is dominated by descriptive and monetary attributes tied to a source transaction identity, with limited outward referencing. This classification should be treated as a modeling suggestion rather than a binding design assertion.

Key Information Stored

The table contains 75 documented columns. The most operationally significant are:

TRX_ID serves as the surrogate primary key, while SOURCE_TRX_ID combined with related source identifiers represents the principal business-key candidate.

Common Use Cases and Queries

Typical usage centers on funds-checking audits, budget reconciliation, and historical balance reporting. A common pattern joins the table to its historical header and budget entity:

  • Reconciling NEW_BALANCE against current budget balances for a given PERIOD_NAME and BUDGET_ENTITY_ID.
  • Tracing a source transaction lineage via SOURCE_TRX_ID or HISTORY_TRX_ID.
  • Reporting MRC-equivalent amounts by CURRENCY_CODE for multi-currency consolidation.
  • Auditing STATUS transitions and SEGMENT-level impact over time.

Sample query pattern: SELECT t.SOURCE_TRX_ID, t.BUDGET_AMOUNT, t.FUNDS_AVAILABLE, t.NEW_BALANCE FROM IGI.IGI_DOS_TRX_SOURCES_HIST t WHERE t.BUDGET_ENTITY_ID = :entity AND t.PERIOD_NAME = :period ORDER BY t.CREATION_DATE DESC;

Related Objects

  • IGI_DOS_TRX_HEADERS_HIST – joined on HISTORY_TRX_ID; provides historical header context.
  • GL_BUDGET_ENTITIES – joined on BUDGET_ENTITY_ID; defines budget entity.
  • IGI_DOS_DOC_TYPES – joined on DOSSIER_ID; identifies dossier/document type.
  • IGI_DOS_TRX_SOURCES_HIST (self) – self-referencing FK via SOURCE_TRX_ID.
  • GL_CODE_COMBINATIONS – joined on CODE_COMBINATION_ID for accounting flexfield detail.
  • GL_BUDGETS / GL_BUDGET_VERSIONS – joined via BUDGET_NAME and BUDGET_VERSION_ID for budget definition context.