Search Results igi_dos_items




Overview
Explore in AI Chat

Overview

IGI_DOS_ITEMS is a table in the IGI schema, part of the Oracle E-Business Suite product IGI - Public Sector Financials International. It stores dossier items—individual line-level entries that belong to a dossier maintained within the Public Sector Financials International module. In EBS 12.1.1 and 12.2.2 this object is documented as VALID and contains a physical schema of 10 columns. Functionally, it acts as the transactional detail table for dossier content, capturing the type and reference of each item together with descriptive text and standard audit columns.

From a heuristic Data Vault perspective, the mined relationship data classifies this table as standalone. This is a modeling suggestion rather than a statement of the underlying design: the table does not present the typical hub-and-satellite association pattern in the extracted metadata. Where a Data Vault model is desired, IGI_DOS_ITEMS would most plausibly be treated as a satellite describing dossier context, or as a standalone reference set, because the only documented foreign key relationship is a single parent reference rather than a network of links.

Key Information Stored

The table's most significant columns are centered on identification of the parent dossier and classification of each item:

  • DOSSIER_ID — the key that ties each item to its parent dossier; this is the sole documented foreign key and the primary business reference for the row.
  • SOB_ID — the Set of Books identifier, establishing the accounting context under which the dossier item was created (relevant for 12.1.1 and retained through 12.2.2).
  • ITEM_TYPE — classifies the nature of the dossier item, allowing mixed content within a single dossier.
  • ITEM_REFERENCE — a business reference pointing to the underlying source; together with DOSSIER_ID and ITEM_TYPE it forms the practical lookup key for consumers.
  • ITEM_TEXT — free-form descriptive or narrative content associated with the item.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit columns recording who created and last modified the row and when.

The documented unique indexes list only a system-generated index (SYS_IL0000134057C00010$$), which is associated with an LOB or similar internal construct rather than a declarative business key. Users should therefore regard DOSSIER_ID plus ITEM_TYPE and ITEM_REFERENCE as the de facto logical identifier, while recognizing that no enforced unique constraint on those columns is documented.

Common Use Cases and Queries

The predominant use case is reporting on the contents of a dossier by joining the items back to their parent dossier. A typical pattern is:

  • Listing all items for a dossier: SELECT item_type, item_reference, item_text FROM igi.igi_dos_items WHERE dossier_id = :p_dossier_id;
  • Auditing capture activity within a period: filter on creation_date and group by created_by to identify who entered each item.
  • Joining to igi_dos_doc_types to resolve the dossier definition referenced by dossier_id.
  • Cross-referencing set-of-books context by joining sob_id to the appropriate ledger or set-of-books view for financial reporting.

Related Objects

  • IGI_DOS_DOC_TYPES — the documented parent table, joined on IGI_DOS_ITEMS.DOSSIER_ID = IGI_DOS_DOC_TYPES.DOSSIER_ID.
  • IGI_DOS_ITEMS audit and inquiry views that expose dossier content to end users.
  • The IGI dossier entry and inquiry forms/APIs that insert and update rows in this table.
  • Reporting templates in the Public Sector Financials International module that consume dossier item detail.