Search Results igi_exp_tran_unit_def_all




Overview
Explore in AI Chat

Overview

The IGI_EXP_TRAN_UNIT_DEF_ALL 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. It stores master definition information about exchange protocol transmission units — the discrete document/message units exchanged with external trading partners under a defined exchange protocol. Each row represents one transmission unit definition, uniquely identified by a surrogate key and further qualified by a business key made up of the transmission unit number, its number type, and the associated document type.

From a data-modeling perspective, the metadata’s heuristic Data Vault classification is standalone. This suggests the table behaves like a reference or definition hub, holding relatively stable descriptive attributes rather than acting as a transactional junction between two entities. Because the mined FK structure shows no strong link dependencies, it is best treated as an independent definition table that other process tables reference by key.

Key Information Stored

The table contains 24 documented columns. The most important are:

Common Use Cases and Queries

Typical usage includes defining valid transmission units before they are processed, reporting on the status and value of units exchanged with third parties, and reconciling reporting-currency amounts.

  • Look up a unit by its business key:

    SELECT * FROM igi.igi_exp_tran_unit_def_all WHERE trans_unit_num = :num AND trans_unit_num_type = :type AND doc_type_id = :doc AND org_id = :org;

  • Status reporting by operating unit:

    SELECT org_id, trans_unit_status, COUNT(*), SUM(amount) FROM igi.igi_exp_tran_unit_def_all GROUP BY org_id, trans_unit_status;

  • Third-party reconciliation: filter on THIRD_PARTY_ID and compare AMOUNT against MRC_AMOUNT using the stored exchange rate to detect conversion discrepancies.
  • Audit tracking: use the audit columns to identify recently created or modified definitions.

Related Objects

Although classified as standalone, the table participates in the IGI exchange-processing flow through its keys:

  • IGI_EXP_TRAN_UNIT_DEF_ALL joins to document-type definitions via DOC_TYPE_ID.
  • Transmission-unit process lines reference the definition via TRANS_UNIT_ID, linking definition to processing.
  • The business key columns (TRANS_UNIT_NUM, TRANS_UNIT_NUM_TYPE, DOC_TYPE_ID) relate to numbering and document-type setups.
  • THIRD_PARTY_ID links to the IGI third-party/trading-partner setup.
  • IEL_TRANS_UNIT_ID cross-references the corresponding IEL transmission-unit entity.
  • Multi-org queries are filtered through ORG_ID against the operating unit (HR_ALL_ORGANIZATION_UNITS).

Because no formal foreign keys are documented, joins should be validated against the business keys and the surrounding IGI exchange-protocol tables.