Search Results igi_dos_source_alloc




Overview
Explore in AI Chat

Overview

The IGI_DOS_SOURCE_ALLOC table resides in the IGI schema and belongs to the IGI – Public Sector Financials International product family within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store allocation records applied against a source transaction. Within the public sector financials model, this table captures how a single originating source transaction has been distributed or apportioned across one or more allocation lines, each tied to a specific set of accounts and a defined accounting period. This makes it a supporting detail table for expenditure tracking, cost distribution, and reconciliation in government-oriented deployments.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification identifies this object as standalone, meaning it does not participate in a strongly linked hub-and-satellite network as inferred from the foreign key structure. A modeling suggestion would be to treat it as an independent satellite-like entity anchored to the source transaction hub, rather than as a hub itself, since its identity is defined largely by its allocation context rather than an independent business key.

Key Information Stored

The documented physical schema contains 16 columns. The most significant include:

The FK relationship confirms SOURCE_TRX_ID as the business-key lineage to the source transaction, while SOURCE_ALLOC_ID serves as the line-level surrogate.

Common Use Cases and Queries

Typical reporting scenarios include examining how a source transaction was split across allocations, verifying multi-currency translation integrity, and reconciling allocation amounts against their originating transactions. A representative query joining to the source transaction table:

  • SELECT a.SOURCE_ALLOC_ID, a.SOURCE_TRX_ID, a.AMOUNT, a.MRC_AMOUNT, a.PERIOD_NAME FROM IGI.IGI_DOS_SOURCE_ALLOC a WHERE a.SOURCE_TRX_ID = :trx_id;
  • Aggregating allocations by period: SELECT PERIOD_NAME, SUM(AMOUNT) FROM IGI.IGI_DOS_SOURCE_ALLOC GROUP BY PERIOD_NAME;
  • Currency translation review: filtering where MRC_EXCHANGE_STATUS indicates incomplete or pending translation.

Related Objects

  • IGI_DOS_TRX_SOURCES – The referenced parent, joined on IGI_DOS_SOURCE_ALLOC.SOURCE_TRX_ID = IGI_DOS_TRX_SOURCES.SOURCE_TRX_ID; this is the primary FK dependency.
  • Other IGI_DOS_* transaction and distribution tables within the Public Sector Financials International module, which typically share the SOURCE_TRX_ID lineage and extend the allocation model.
  • General Ledger period and Set of Books objects (GL_PERIODS, GL_SETS_OF_BOOKS) referenced indirectly through PERIOD_NAME and SOB_ID for reporting joins.
  • Standard EBS concurrency and multi-reporting-currency components leveraged by the MRC_* columns.