Search Results igi_dos_trx_dest

Overview

The IGI_DOS_TRX_DEST table resides in the IGI (Public Sector Financials International) schema and stores destination transaction records produced by the ETRM (Enterprise Transaction and Reconciliation Management) subsystem. In Oracle EBS 12.1.1 and 12.2.2, this object captures the destination-side posting of a transaction—typically budget, funds-checking, or funds-reservation activity—after it has been transferred from a source transaction. It links a destination transaction to its originating source transaction, its controlling transaction header, and the destination definition, forming the transactional backbone of ETRM's distribution and funds-control logic.

From a Data Vault modeling perspective (heuristic, mined from the foreign-key structure), IGI_DOS_TRX_DEST is best classified as a link table. Its composite foreign keys connect transaction headers, source transactions, and destinations, while the entity's own descriptive and monetary attributes resemble satellite-style payload. This classification is a modeling suggestion rather than a documented EBS design intent.

Key Information Stored

The table contains 76 documented columns. The following are the most significant:

DEST_TRX_ID — Surrogate primary key (IGI_DOS_TRX_DEST_PK, also referenced by unique index IGI_DOS_TRX_DEST_U1). Uniquely identifies each destination transaction row.
TRX_ID — Foreign key to IGI_DOS_TRX_HEADERS, tying the destination row to its parent transaction header.
SOURCE_TRX_ID — Foreign key to IGI_DOS_TRX_SOURCES, identifying the originating source transaction.
DESTINATION_ID — Foreign key to IGI_DOS_DESTINATIONS, identifying the destination definition.
BUDGET_ENTITY_ID — Foreign key to GL_BUDGET_ENTITIES, linking the transaction to a budget entity.
SOB_ID — Set of Books identifier for the ledger context.
BUDGET_NAME, BUDGET_VERSION_ID, PERIOD_NAME — Budget and period context for the posting.
BUDGET_AMOUNT, FUNDS_AVAILABLE, NEW_BALANCE — Core monetary measures: the budgeted amount, funds checked/available, and resulting balance.
CURRENCY_CODE — Currency of the amounts stored.
CODE_COMBINATION_ID — Accounting flexfield combination for the distribution.
SEGMENT1–SEGMENT30 — Denormalized accounting flexfield segments captured with each row.
MRC_* columns — Multiple Reporting Currency equivalents of budget amount, funds available, and new balance, each with exchange rate, rate type, exchange date, and status.
DOSSIER_ID, STATUS, LINE_NUM, GROUP_ID, PERCENTAGE — Administrative and processing attributes.

No alternate business-key unique index beyond DEST_TRX_ID (IGI_DOS_TRX_DEST_U1) is documented, so DEST_TRX_ID serves as the sole documented unique identifier.

Common Use Cases and Queries

Typical uses include budget execution reporting, funds-availability reconciliation, and audit trails tracing a destination posting back to its source. Join patterns rely on the documented foreign keys:

Retrieve all destination rows for a transaction header: SELECT * FROM IGI.IGI_DOS_TRX_DEST WHERE TRX_ID = :trx_id; joined to IGI_DOS_TRX_HEADERS.
Trace source-to-destination flows: SELECT d.DEST_TRX_ID, s.SOURCE_TRX_ID FROM IGI.IGI_DOS_TRX_DEST d JOIN IGI.IGI_DOS_TRX_SOURCES s ON d.SOURCE_TRX_ID = s.SOURCE_TRX_ID;
Report funds availability by destination: aggregate BUDGET_AMOUNT, FUNDS_AVAILABLE, and NEW_BALANCE grouped by DESTINATION_ID, joining IGI_DOS_DESTINATIONS.
Reconcile budget amounts to GL: join on BUDGET_ENTITY_ID to GL_BUDGET_ENTITIES and CODE_COMBINATION_ID to GL code combinations.
Multi-currency reporting using MRC_BUDGET_AMOUNT, MRC_FUNDS_AVAIL, and MRC_NEW_BALANCE for secondary ledgers.

Related Objects

IGI_DOS_TRX_HEADERS — Parent transaction header; joined on TRX_ID.
IGI_DOS_TRX_SOURCES — Source transactions; joined on SOURCE_TRX_ID.
IGI_DOS_DESTINATIONS — Destination definitions; joined on DESTINATION_ID.
GL_BUDGET_ENTITIES — Budget entities; joined on BUDGET_ENTITY_ID.
GL_CODE_COMBINATIONS — Accounting flexfield combinations referenced by CODE_COMBINATION_ID.
GL_SETS_OF_BOOKS — Ledger context referenced by SOB_ID.

Table: IGI_DOS_TRX_DEST 12.2.2
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_DOS_TRX_DEST, object_name:IGI_DOS_TRX_DEST, status:VALID, product: IGI - Public Sector Financials International , description: Stores destination transactions , implementation_dba_data: IGI.IGI_DOS_TRX_DEST ,
Table: IGI_DOS_TRX_DEST 12.1.1
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_DOS_TRX_DEST, object_name:IGI_DOS_TRX_DEST, status:VALID, product: IGI - Public Sector Financials International , description: Stores destination transactions , implementation_dba_data: IGI.IGI_DOS_TRX_DEST ,
SYNONYM: APPS.IGI_DOS_TRX_DEST 12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGI_DOS_TRX_DEST, status:VALID,
SYNONYM: APPS.IGI_DOS_TRX_DEST 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGI_DOS_TRX_DEST, status:VALID,
VIEW: IGI.IGI_DOS_TRX_DEST# 12.2.2
owner:IGI, object_type:VIEW, object_name:IGI_DOS_TRX_DEST#, status:VALID,
Table: IGI_DOS_TRX_SOURCES 12.1.1
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_DOS_TRX_SOURCES, object_name:IGI_DOS_TRX_SOURCES, status:VALID, product: IGI - Public Sector Financials International , description: Stores source transactions , implementation_dba_data: IGI.IGI_DOS_TRX_SOURCES ,
APPS.IGI_DOS_TRX_DEST_PKG SQL Statements 12.1.1
APPS.IGI_DOS_TRX_DEST_PKG SQL Statements 12.2.2
Table: IGI_DOS_TRX_HEADERS 12.2.2
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_DOS_TRX_HEADERS, object_name:IGI_DOS_TRX_HEADERS, status:VALID, product: IGI - Public Sector Financials International , description: Stores transaction header information , implementation_dba_data: IGI.IGI_DOS_TRX_HEADERS ,
Table: IGI_DOS_TRX_SOURCES 12.2.2
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_DOS_TRX_SOURCES, object_name:IGI_DOS_TRX_SOURCES, status:VALID, product: IGI - Public Sector Financials International , description: Stores source transactions , implementation_dba_data: IGI.IGI_DOS_TRX_SOURCES ,
Table: IGI_DOS_TRX_HEADERS 12.1.1
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_DOS_TRX_HEADERS, object_name:IGI_DOS_TRX_HEADERS, status:VALID, product: IGI - Public Sector Financials International , description: Stores transaction header information , implementation_dba_data: IGI.IGI_DOS_TRX_HEADERS ,
TRIGGER: APPS.IGI_DOS_TRX_HEADERS_T1 12.2.2
owner:APPS, object_type:TRIGGER, object_name:IGI_DOS_TRX_HEADERS_T1, status:VALID,
TRIGGER: APPS.IGI_DOS_TRX_HEADERS_T1 12.1.1
owner:APPS, object_type:TRIGGER, object_name:IGI_DOS_TRX_HEADERS_T1, status:VALID,
PACKAGE BODY: APPS.IGI_DOS_FUNDS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_DOS_FUNDS, status:VALID,
PACKAGE BODY: APPS.IGI_DOS_TRX_HEADERS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_DOS_TRX_HEADERS_PKG, status:VALID,
APPS.IGI_DOS_FUNDS SQL Statements 12.1.1
VIEW: IGI.IGI_DOS_TRX_DEST# 12.2.2
APPS.IGI_DOS_FUNDS SQL Statements 12.2.2
PACKAGE BODY: APPS.IGI_DOS_TRX_DEST_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_DOS_TRX_DEST_PKG, status:VALID,
PACKAGE BODY: APPS.IGI_DOS_TRX_HEADERS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_DOS_TRX_HEADERS_PKG, status:VALID,
PACKAGE BODY: APPS.IGI_DOS_TRX_DEST_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_DOS_TRX_DEST_PKG, status:VALID,
PACKAGE BODY: APPS.IGI_DOS_FUNDS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IGI_DOS_FUNDS, status:VALID,
TABLE: IGI.IGI_DOS_TRX_DEST 12.2.2
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_DOS_TRX_DEST, object_name:IGI_DOS_TRX_DEST, status:VALID,
PACKAGE BODY: APPS.IGIDOSL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGIDOSL, status:VALID,
TABLE: IGI.IGI_DOS_TRX_DEST 12.1.1
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_DOS_TRX_DEST, object_name:IGI_DOS_TRX_DEST, status:VALID,
PACKAGE BODY: APPS.IGIDOSL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IGIDOSL, status:VALID,
12.1.1 FND Design Data 12.1.1
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.IGI_DOS_TRX_DEST_PKG 12.2.2
12.2.2 DBA Data 12.2.2
APPS.IGIDOSL SQL Statements 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.IGI_DOS_TRX_DEST_PKG 12.1.1
APPS.IGIDOSL SQL Statements 12.2.2
TRIGGER: APPS.IGI_DOS_TRX_HEADERS_T1 12.1.1
TRIGGER: APPS.IGI_DOS_TRX_HEADERS_T1 12.2.2
PACKAGE BODY: APPS.IGI_DOS_FUNDS 12.1.1
PACKAGE BODY: APPS.IGI_DOS_FUNDS 12.2.2
APPS.IGI_DOS_FUNDS dependencies on IGI_DOS_TRX_DEST 12.1.1
APPS.IGI_DOS_TRX_DEST_PKG dependencies on IGI_DOS_TRX_DEST 12.2.2
APPS.IGI_DOS_TRX_DEST_PKG dependencies on IGI_DOS_TRX_DEST 12.1.1
APPS.IGI_DOS_FUNDS dependencies on IGI_DOS_TRX_DEST 12.2.2
Foreign Keys 12.2.2
APPS.IGI_DOS_TRX_HEADERS_PKG dependencies on IGI_DOS_TRX_DEST 12.1.1