Search Results igi_exp_dus_all




Overview
Explore in AI Chat

Overview

IGI_EXP_DUS_ALL is a transactional table in the IGI (Public Sector Financials International) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description states that it "stores the dialog units," and its structure, foreign keys, and dependent child tables confirm that it functions as the central record for a "Dialog Unit" (DU) — a discrete financial instrument or transaction tracked for expenditure control, advance, or commitment purposes in a public-sector accounting context. The document content excerpt marks the object owner as IGI, status VALID.

The table is keyed by the surrogate primary key IGI_EXP_DUS_PK on the DU_ID column, and a unique index (IGI_EXP_DUS_U1) on DU_ID is the documented business-key candidate. The heuristic Data Vault classification mined from the FK structure is satellite-leaning, suggesting that IGI_EXP_DUS_ALL should be modeled as descriptive/transactional detail that hangs off hub entities such as IGI_EXP_TUS_ALL and IGI_EXP_DU_TYPE_HEADERS_ALL. The table carries the full 38 documented columns, including standard EBS WHO columns and fifteen ATTRIBUTE1–ATTRIBUTE15 flex fields.

Key Information Stored

Common Use Cases and Queries

Practical reporting typically starts from the DU_ID join to its dependent transaction tables or from the FK hierarchies upward to the TUS and DU-type headers. Common patterns include:

  • Listing outstanding dialog units for an operating unit: SELECT du_id, du_order_number, du_status, du_amount, du_currency_code FROM igi.igi_exp_dus_all WHERE org_id = :org_id AND du_status = :status;
  • Joining to supplier information via the FK to PO_VENDORS: ... FROM igi_exp_dus_all d, po_vendors v WHERE d.du_stp_id = v.vendor_id;
  • Rolling DU amounts up to the TUS level: ... FROM igi_exp_dus_all d, igi_exp_tus_all t WHERE d.tu_id = t.tu_id;
  • Driving AP and AR transaction detail through the child tables IGI_EXP_AP_TRANS_ALL and IGI_EXP_AR_TRANS_ALL on DU_ID.
  • Currency conversion or reporting using FND_CURRENCIES via DU_CURRENCY_CODE.

Related Objects

  • IGI_EXP_DU_TYPE_HEADERS_ALL — referenced via DU_TYPE_HEADER_ID; defines the dialog unit type.
  • IGI_EXP_TUS_ALL — referenced via TU_ID; parent grouping for the DU.
  • FND_CURRENCIES — referenced via DU_CURRENCY_CODE.
  • PO_VENDORS — referenced via DU_STP_ID (supplier/payee).
  • IGI_EXP_AP_TRANS_ALL — child table referencing IGI_EXP_DUS_ALL.DU_ID (payables transactions).
  • IGI_EXP_AR_TRANS_ALL — child table referencing IGI_EXP_DUS_ALL.DU_ID (receivables transactions).

Together these relationships make IGI_EXP_DUS_ALL the pivotal transactional hub for dialog-unit activity, joining type definitions, parent groupings, suppliers, currencies, and both AP and AR transaction detail within the IGI public-sector financials schema.