Results for “tu_type_header_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGI_EXP_TU_TYPE_DETAILS_ALL table is a core configuration object within the IGI (Public Sector Financials International) product family of Oracle E-Business Suite, available in both release 12.1.1 and 12.2.2. It stores the detail-level information that defines a TU (Transaction Unit) Type, complementing the header-level definition held in IGI_EXP_TU_TYPE_HEADERS_ALL. In practice, TU Types are used by public sector organizations to model the composition of a transaction — for example, the sets of expenditure or budgetary line attributes that roll up under a given transaction definition. This table therefore acts as the fine-grained descriptor container for each TU Type, capturing the specific detail rows (and their associated DU Type linkage) that the application applies when validating or deriving transaction attributes.
From a Data Vault modeling perspective, the metadata's heuristic classification places this object as a link. This is a modeling suggestion rather than a functional designation: the table's foreign keys tie a TU Type Header to a DU Type Header, and it carries its own surrogate key plus standard audit columns, making it a natural candidate for a link entity that resolves a many-to-many relationship between two header hubs.
Key Information Stored
The documented physical schema consists of nine columns. The most significant are:
- TU_TYPE_DETAIL_ID — the surrogate primary key, enforced by constraint
IGI_EXP_TU_TYPE_DETAILS_PKand backed by the unique indexIGI_EXP_TU_TYPE_DETAILS_U1. This is the unique business-key candidate for each detail row. - TU_TYPE_HEADER_ID — a foreign key referencing
IGI_EXP_TU_TYPE_HEADERS_ALL, identifying the parent TU Type definition to which this detail belongs. - DU_TYPE_HEADER_ID — a foreign key referencing
IGI_EXP_DU_TYPE_HEADERS_ALL, linking the detail to a DU (Data Unit) Type header definition. - ORG_ID — the operating unit identifier, supporting the multi-org (partitioned) nature of the
_ALLtable. - CREATED_BY, CREATION_DATE — standard "who created this row, and when" audit attributes.
- LAST_UPDATED_BY, LAST_UPDATE_DATE — the standard "who last changed this row, and when" audit attributes.
- LAST_UPDATE_LOGIN — the login identifier associated with the most recent update, used for auditing and diagnostics.
Taken together, the detail rows define which DU Types participate in each TU Type. The absence of a documented name or description column means that all descriptive text is likely resolved by joining to the referenced header tables.
Common Use Cases and Queries
Typical applications include configuration validation, migration and cloning, and reporting on which DU Types a TU Type comprises.
- Retrieving all details for a given TU Type:
SELECT d.tu_type_detail_id,
d.tu_type_header_id,
d.du_type_header_id,
d.org_id
FROM igi.igi_exp_tu_type_details_all d
WHERE d.tu_type_header_id = :p_tu_type_header_id
AND d.org_id = :p_org_id;
- Resolving detail rows to their header descriptions:
SELECT d.tu_type_detail_id, t.tu_type_name, u.du_type_name
FROM igi.igi_exp_tu_type_details_all d,
igi.igi_exp_tu_type_headers_all t,
igi.igi_exp_du_type_headers_all u
WHERE d.tu_type_header_id = t.tu_type_header_id
AND d.du_type_header_id = u.du_type_header_id;
- Validating duplicates or orphaned rows prior to migration (checking that each
tu_type_detail_idis unique and that both foreign keys resolve). - Reporting the DU Type coverage across all TU Types for an operating unit.
Related Objects
The table's principal relationships are defined by its foreign keys and its own primary key:
- IGI_EXP_TU_TYPE_HEADERS_ALL — parent table; joined on
TU_TYPE_HEADER_ID. - IGI_EXP_DU_TYPE_HEADERS_ALL — referenced table; joined on
DU_TYPE_HEADER_ID. - IGI_EXP_TU_TYPE_DETAILS_PK — primary key constraint on
TU_TYPE_DETAIL_ID. - IGI_EXP_TU_TYPE_DETAILS_U1 — unique index on
TU_TYPE_DETAIL_ID, the documented business-key candidate.
Because the table is an _ALL object owned by the IGI schema, access is normally mediated through the corresponding multi-org views and the IGI setup forms rather than direct DML. Any integration or reporting effort should treat IGI_EXP_TU_TYPE_HEADERS_ALL and IGI_EXP_DU_TYPE_HEADERS_ALL as the primary header-level companions to this detail table.
-
Stores the detail level information for the TU Type definition
-
Stores the detail level information for the TU Type definition
-
Stores the headers information for the TU type definition
-
Stores the headers information for the TU type definition
-
Stores the transmission units
-
Stores the transmission units
-
View: IGI_EXP_TUS_V 12.2.2
Displays details of Transmission Units and is primarily used by the 'Define Transmission Units' screen
APPS.IGI_EXP_TUS_V·↳ FND_USER·↳ IGI_EXP_APPRV_PROFILES_ALL·↳ IGI_EXP_TUS·Explore IGI module →
-
View: IGI_EXP_TUS_V 12.1.1
Displays details of Transmission Units and is primarily used by the 'Define Transmission Units' screen
APPS.IGI_EXP_TUS_V·↳ FND_USER·↳ IGI_EXP_APPRV_PROFILES_ALL·↳ IGI_EXP_TUS·Explore IGI module →
-
VIEW: IGI.IGI_EXP_TUS_ALL# 12.2.2
-
VIEW: APPS.IGI_EXP_TUS_V 12.1.1
-
VIEW: IGI.IGI_EXP_TUS_ALL# 12.2.2
-
VIEW: APPS.IGI_EXP_TUS_V 12.2.2
-
TABLE: IGI.IGI_EXP_TUS_ALL 12.2.2
-
TABLE: IGI.IGI_EXP_TUS_ALL 12.1.1
-
eTRM - IGI Tables and Views 12.1.1
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.
-
eTRM - IGI Tables and Views 12.1.1
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.