Search Results igi_dos_trx_sources_pk

Overview

IGI_DOS_TRX_SOURCES is a table in the IGI (Public Sector Financials International) product family of Oracle E-Business Suite, present and valid in both 12.1.1 and 12.2.2. Per the ETRM documentation, it "stores source transactions" and is owned by the IGI schema. In practice, this table acts as the central registry of transaction-level records that feed the IGI budgetary control and funds-checking engine, capturing the budget, funds-availability, and accounting-flexfield context associated with each source transaction before that transaction is processed and, where applicable, propagated to a destination table.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. Because it carries a single-column surrogate primary key plus descriptive and quantitative attributes tied to an originating transaction, it is best treated as a satellite attached to a transaction hub rather than as an independent hub or a pure link. This is a heuristic modeling suggestion derived from the FK topology, not an authoritative designation.

Key Information Stored

The table documents 74 columns. The most significant are summarized below.

• SOURCE_TRX_ID — the surrogate primary key (IGI_DOS_TRX_SOURCES_PK) and the column referenced by a large set of downstream foreign keys. It is also the single column of unique index IGI_DOS_TRX_SOURCES_U1, making it the principal business-key candidate as well as the surrogate identifier.
• TRX_ID — identifies the originating transaction within IGI; a self-referencing foreign key column.
• DOSSIER_ID — links the record to its budget dossier (budgetary control grouping).
• BUDGET_ENTITY_ID — references GL_BUDGET_ENTITIES, tying the transaction to a specific budget entity.
• SOB_ID and CODE_COMBINATION_ID — the set of books and the accounting flexfield combination against which budgeting and funds checking are performed.
• PROFILE_CODE — the budgetary control profile that governs how the transaction is checked.
• BUDGET_NAME and BUDGET_VERSION_ID — the budget and its version used for the check.
• BUDGET_AMOUNT, FUNDS_AVAILABLE, and NEW_BALANCE — the core quantitative results of the funds-availability calculation, including the resulting balance after the transaction is applied.
• MRC_* columns (e.g., MRC_BUDGET_AMOUNT, MRC_FUNDS_AVAIL, MRC_NEW_BALANCE and their exchange-rate/status companions) — reporting-currency equivalents of the primary amounts for multiple reporting currencies.
• PERIOD_NAME, PERIOD_YEAR, PERIOD_NUM, QUARTER_NUM — the accounting period context of the transaction.
• STATUS — processing state of the source record.
• SEGMENT1 … SEGMENT30, VISIBLE_SEGMENTS, ACTUAL_SEGMENTS — the account segment values and their display/storage variants.
• LINE_NUM, GROUP_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard line identification and audit columns.

Common Use Cases and Queries

Typical uses center on tracing how a source transaction was budget-checked and what funds result it produced.

Funds-availability audit for a dossier:

• SELECT SOURCE_TRX_ID, TRX_ID, BUDGET_AMOUNT, FUNDS_AVAILABLE, NEW_BALANCE, STATUS FROM IGI.IGI_DOS_TRX_SOURCES WHERE DOSSIER_ID = :dosser_id;

Multi-currency reconciliation between primary and reporting amounts:

• SELECT SOURCE_TRX_ID, BUDGET_AMOUNT, MRC_BUDGET_AMOUNT, CURRENCY_CODE, MRC_BUDGET_AMT_EXCH_RATE FROM IGI.IGI_DOS_TRX_SOURCES WHERE CURRENCY_CODE <> :functional_currency;

Locating source records for a specific account combination and period:

• SELECT SOURCE_TRX_ID, PERIOD_NAME, PERIOD_YEAR, CODE_COMBINATION_ID FROM IGI.IGI_DOS_TRX_SOURCES WHERE CODE_COMBINATION_ID = :ccid AND PERIOD_NAME = :period;

Because SOURCE_TRX_ID is heavily referenced, joins from downstream transaction tables (for example AP_INVOICE_LINES_ALL, RA_INTERFACE_LINES_ALL, or ZX_TRANSACTION_LINES_GT) back to this table are a frequent pattern for reporting the budgetary impact of individual invoice, receivable, or tax lines.

Related Objects

• IGI_DOS_TRX_DEST — references IGI_DOS_TRX_SOURCES via SOURCE_TRX_ID, holding the destination-side result of the same processing flow.
• IGI_DOS_SOURCE_ALLOC — references SOURCE_TRX_ID; records allocations associated with the source transaction.
• GL_BUDGET_ENTITIES — referenced by IGI_DOS_TRX_SOURCES.BUDGET_ENTITY_ID.
• AP_INVOICE_LINES_ALL and AP_INVOICE_LINES_INTERFACE — reference SOURCE_TRX_ID for Payables invoice lines subject to funds checking.
• RA_INTERFACE_LINES_ALL and AR_TRX_LINES_GT — reference SOURCE_TRX_ID for Receivables interface and transaction lines.
• ZX_LINES_DET_FACTORS and ZX_TRANSACTION_LINES_GT — E-Business Tax lines referencing SOURCE_TRX_ID.
• CN_TRX_LINES_ALL, CN_SCA_LINES_INTERFACE_ALL, and CN_COMMISSION_HEADERS_ALL — Channel/Commission transaction structures referencing SOURCE_TRX_ID.
• IGI_DOS_TRX_DEST_HIST — historical companion to IGI_DOS_TRX_DEST, also referencing SOURCE_TRX_ID.