Search Results igi_dos_doc_types




Overview
Explore in AI Chat

Overview

The IGI_DOS_DOC_TYPES table is a core configuration and definition object within the IGI - Public Sector Financials International module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the master registry of dossier document types — the templates or classifications that define how dossiers (grouped sets of financial, transactional, or documentary records) are structured, numbered, and governed within the IGI Public Sector localization used by government and public-sector entities.

In Oracle EBS terms, this table functions as a definition/reference master. Its rows are established during implementation and subsequently referenced by transactional and historical dossier tables throughout the IGI_DOS schema. The mined Data Vault classification is satellite-leaning, suggesting it is best modeled as a descriptive satellite of dossier type attributes rather than a pure hub or link; however, because it also carries its own unique surrogate key and is referenced by multiple child tables, it behaves as a parent master table in the relational sense.

Key Information Stored

The table contains 39 documented columns. The most significant include:

The distinction is important: DOSSIER_ID is the technical surrogate key, while DOSSIER_NAME is the documented unique business identifier.

Common Use Cases and Queries

Typical scenarios include listing active dossier types for a given set of books, validating configuration during implementation, and reporting on numbering or hierarchy assignments.

SELECT dossier_id, dossier_name, dossier_description, dosser_status
FROM   igi_dos_doc_types
WHERE  retired_flag = 'N'
ORDER  BY dossier_name;

Analysts commonly join to explore related definitions:

SELECT t.dossier_id, t.dossier_name, t.coa_id, t.sob_id
FROM   igi_dos_doc_types t
WHERE  t.multiannual = 'Y';

Reporting use cases include auditing which types are retired, mapping types to their associated workflow, and identifying types that participate in related-dossier relationships.

Related Objects

The FK metadata identifies the following significant relationships:

  • IGI_DOS_DESTINATIONS — references IGI_DOS_DOC_TYPES.DOSSIER_ID; defines destination routing for each type.
  • IGI_DOS_TRX_DEST_HIST — references DOSSIER_ID, retaining destination history.
  • IGI_DOS_TRX_SOURCES_HIST — references DOSSIER_ID, retaining source history.
  • IGI_DOS_TRX_HEADERS_HIST — references DOSSIER_ID, the historical transaction header store.
  • IGI_DOS_ITEMS — references DOSSIER_ID, holding line items associated with dossiers.
  • IGI_DOS_DOC_TYPES.DOSSIER_NUMBERING — the numbered reference (foreign key DOSSIER_NUMBERING) governing numbering sequences.

Together these child tables confirm IGI_DOS_DOC_TYPES as the parent master governing dossier definitions across transactional, historical, and item-level data in the IGI Public Sector Financials module.