Search Results igi_exp_dus_u1

Overview

IGI.IGI_EXP_DUS_ALL is a transactional table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, residing in the IGI schema—the schema historically associated with the Public Sector/Federal financials and the Global Intercompany/Expenditure Tracking functionality. This table stores "Dialog Units" (DUs) as defined in the form IGIPEPDU. A Dialog Unit represents a logical grouping of financial transactions or obligations, typically used in government or public sector accounting for tracking budgets, commitments, and expenditures against specific funding sources or legal directives.

Based on the foreign key relationships and structural metadata, IGI_EXP_DUS_ALL exhibits a satellite-leaning Data Vault classification. It acts as a satellite surrounding the central hubs of Dialog Unit Types (IGI_EXP_DU_TYPE_HEADERS_ALL) and Transmission Units (IGI_EXP_TUS_ALL). It captures the descriptive and mutable attributes of a Dialog Unit, such as amounts, statuses, and dates, rather than serving as a pure hub or link table itself.

Key Information Stored

The table is anchored by the surrogate primary key, DU_ID, which is generated via sequence. This column is also the sole column in the unique index IGI_EXP_DUS_U1, confirming it as the definitive unique identifier for the record. The most critical business columns include:

• DU_TYPE_HEADER_ID: A foreign key identifying the Dialog Unit Type, classifying the instance.
• DU_ORDER_NUMBER and DU_LEGAL_NUMBER: VARCHAR2(250) fields holding the actual order and legal reference numbers for the dialog unit.
• DU_STATUS: Tracks the lifecycle state of the dialog unit (e.g., open, closed, pending).
• DU_AMOUNT and DU_PREPAY_AMOUNT: Numeric fields recording the total financial value and any prepayments associated with the unit.
• DU_CURRENCY_CODE: The functional currency for the transactions, linked to FND_CURRENCIES.
• TU_ID: A foreign key linking the Dialog Unit to a specific Transmission Unit (IGI_EXP_TUS_ALL).
• DU_STP_ID and DU_STP_SITE_ID: Third Party identifiers (linked to PO_VENDORS) when the DU is assigned to a specific supplier or site.
• PRINT_DATE and DU_DATE: Dates tracking when the unit was printed and when it was created or amended.
• ORG_ID: The organization identifier, supporting Multi-Org access control.
• DU_FISCAL_YEAR and DU_BY_USER_ID: Associating the unit with a fiscal period and the preparer.

The table also includes standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, etc.) and 15 generic ATTRIBUTE columns for extensibility.

Common Use Cases and Queries

This table is primarily queried for financial reporting, audit trails, and reconciliation of expenditures against dialog units. A typical use case involves retrieving all active dialog units for a specific supplier or transmission unit.

Sample Query: Retrieve Dialog Unit Details by Transmission Unit

SELECT du.DU_ID, du.DU_ORDER_NUMBER, du.DU_LEGAL_NUMBER, du.DU_AMOUNT, du.DU_CURRENCY_CODE, du.DU_STATUS, du.DU_DATE
FROM IGI.IGI_EXP_DUS_ALL du
WHERE du.TU_ID = :transmission_unit_id
AND du.DU_STATUS = 'OPEN';

Sample Query: Sum Expenditures by Third Party

SELECT du.DU_STP_ID, SUM(du.DU_AMOUNT) AS TOTAL_DU_AMOUNT
FROM IGI.IGI_EXP_DUS_ALL du
WHERE du.ORG_ID = :org_id
AND du.DU_FISCAL_YEAR = :fiscal_year
GROUP BY du.DU_STP_ID;

Reporting use cases include generating legal number registers, tracking prepayment balances, and auditing the print status of dialog units for compliance purposes.

Related Objects

The object participates in several key relationships within the IGI schema and EBS financials:

• IGI.IGI_EXP_DU_TYPE_HEADERS_ALL: Joined via DU_TYPE_HEADER_ID to obtain the definition and rules of the dialog unit type.
• IGI.IGI_EXP_TUS_ALL: Joined via TU_ID to group dialog units into transmission units.
• IGI.IGI_EXP_AP_TRANS_ALL: References this table via DU_ID, linking Accounts Payable transactions to specific dialog units.
• IGI.IGI_EXP_AR_TRANS_ALL: References this table via DU_ID, linking Accounts Receivable transactions to dialog units.
• FND.FND_CURRENCIES: Joined via DU_CURRENCY_CODE to resolve currency descriptions.
• PO.PO_VENDORS: Joined via DU_STP_ID to retrieve third-party supplier information.

These relationships underscore the table's role as a central reference point for financial transaction tracking and reporting within the IGI module.