Search Results igi_exp_tus_pk

Overview

IGI_EXP_TUS_ALL is a transactional table in the Oracle EBS Public Sector Financials International (IGI) module. It stores transmission units (TUs), the core financial documents used by government and public sector organizations to move funds, obligations, or budget authorizations through an approval workflow. Each row represents a single transmission unit, capturing its identity, currency, amount, status, and current position in the approval chain.

The table is owned by the IGI schema and is valid in both Oracle EBS 12.1.1 and 12.2.2. It carries the standard multi-org column ORG_ID and the full set of EBS WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN), which enables auditing, concurrency control, and operating unit partitioning. Fifteen descriptive flexfield attributes (ATTRIBUTE_CATEGORY, ATTRIBUTE1 through ATTRIBUTE15) allow customer-specific extensions without schema changes.

From a Data Vault modeling perspective, the heuristic classification of IGI_EXP_TUS_ALL is satellite-leaning. The table is anchored by the surrogate primary key TU_ID and enriched with descriptive and status attributes; the approval profile and next approver columns suggest a workflow-state satellite rather than a pure hub.

Key Information Stored

The 35 documented columns break into identification, financial, workflow, and audit groups. The most significant are:

• TU_ID — surrogate primary key defined by the unique index IGI_EXP_TUS_U1 and the constraint IGI_EXP_TUS_PK. It is the only documented business-key candidate.
• TU_TYPE_HEADER_ID — foreign key to IGI_EXP_TU_TYPE_HEADERS_ALL, identifying the transmission unit type that governs the document.
• TU_ORDER_NUMBER and TU_LEGAL_NUMBER — human-readable document identifiers used in correspondence and reporting.
• TU_DESCRIPTION — free-text summary of the transmission unit.
• TU_STATUS — current lifecycle state of the TU (draft, submitted, approved, rejected, etc.).
• TU_CURRENCY_CODE — foreign key to FND_CURRENCIES, defining the currency of TU_AMOUNT.
• TU_AMOUNT — monetary value of the transmission unit.
• APPRV_PROFILE_ID — foreign key to IGI_EXP_APPRV_PROFILES_ALL, the approval profile that determines routing rules.
• NEXT_APPROVER_USER_ID — foreign key to FND_USER, the approver currently responsible for action.
• TU_FISCAL_YEAR — fiscal period context for the document.
• TU_BY_USER_ID and TU_DATE — the originating user and document date.
• ORG_ID — operating unit that owns the transmission unit.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — descriptor flexfield segments for client-specific data.

Common Use Cases and Queries

Typical reporting scenarios include approval workload analysis, outstanding transmission unit tracking, and currency exposure summaries. A status-and-approver query, for example, joins IGI_EXP_TUS_ALL to FND_USER to list pending items per approver:

SELECT t.tu_id, t.tu_order_number, t.tu_status, u.user_name FROM igi.igi_exp_tus_all t JOIN fnd_user u ON t.next_approver_user_id = u.user_id WHERE t.tu_status = 'PENDING' AND t.org_id = :org_id;

Amount aggregation by type and currency supports financial reporting:

SELECT h.tu_type_name, t.tu_currency_code, SUM(t.tu_amount) FROM igi.igi_exp_tus_all t JOIN igi.igi_exp_tu_type_headers_all h ON t.tu_type_header_id = h.tu_type_header_id GROUP BY h.tu_type_name, t.tu_currency_code;

Related Objects

• IGI_EXP_TU_TYPE_HEADERS_ALL — joined on TU_TYPE_HEADER_ID; defines TU classification.
• IGI_EXP_APPRV_PROFILES_ALL — joined on APPRV_PROFILE_ID; supplies approval routing rules.
• FND_USER — joined on NEXT_APPROVER_USER_ID; resolves the current approver.
• FND_CURRENCIES — joined on TU_CURRENCY_CODE; currency validation and formatting.
• IGI_EXP_DUS_ALL — child (detail) table referencing TU_ID; stores the distribution or detail units belonging to each transmission unit.