Search Results igi_dos_doc_types_pk

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:

• DOSSIER_ID — the surrogate primary key (index IGI_DOS_DOC_TYPES_PK), uniquely identifying each dossier document type.
• DOSSIER_NAME — the business-key candidate (unique index IGI_DOS_DOC_TYPES_U2) holding the user-facing name of the document type.
• DOSSIER_NUMBERING — foreign key linking to the IGI_DOS_DOC_TYPES.DOSSIER_NUMBERING reference, controlling numbering rules.
• DOSSIER_DESCRIPTION — textual description of the type's purpose.
• COA_ID and SOB_ID — chart of accounts and set of books identifiers scoping the type to an accounting context.
• HIERARCHY_ID — associates the type with an organizational or reporting hierarchy.
• BALANCED — flag indicating whether the dossier must balance.
• MULTI_ANNUAL — indicates whether the dossier spans multiple fiscal years.
• RELATED_DOSSIER_ID and RELATED_DOSSIER — define relationships between dossier types.
• DOSSIER_STATUS and RETIRED_FLAG — lifecycle state controls.
• WORKFLOW_NAME — the workflow associated with the type.
• AMOUNT_TYPE — categorizes monetary treatment.
• Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, etc.) and fifteen ATTRIBUTE descriptive flexfield columns.

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.