Search Results igi_dos_sources_pk

Overview

IGI_DOS_SOURCES is a table in the IGI schema belonging to the Oracle E-Business Suite product IGI - Public Sector Financials International. In EBS 12.1.1 and 12.2.2, it is documented as a VALID table whose stated purpose is to store sources against a dossier. Within the IGI dossier processing model, a dossier groups a set of budget or accounting selection criteria, and this table holds the source-side definition of those criteria — that is, the range of accounting flexfield values and budget identifiers that a dossier draws from.

The table is a wide object: the ETRM 12.2.2 physical schema documents 79 columns. A large proportion of these are the paired SEGMENTn_LOW and SEGMENTn_HIGH columns (n = 1 through 30), reflecting the need to express low/high ranges for every key flexfield segment of the Accounting Flexfield structure.

From a heuristic Data Vault modeling perspective, the mined foreign-key structure classifies this table as satellite-leaning. This classification is offered as a modeling suggestion derived from the FK topology and should be validated against the intended integration design, since the table carries its own surrogate key and descriptive range attributes rather than merely acting as a pure relationship link.

Key Information Stored

The primary key is IGI_DOS_SOURCES_PK, defined on the surrogate column SOURCE_ID. A second unique index, IGI_DOS_SOURCES_U1, is also documented on SOURCE_ID; no other business-key combination is listed as unique in the provided metadata. The most significant columns include:

• SOURCE_ID — surrogate primary key identifying each source row.
• DOSSIER_ID — foreign key linking the source to its parent dossier.
• BUDGET_ENTITY_ID and BUDGET_ENTITY_NAME — the budget entity the source targets; BUDGET_ENTITY_ID references GL_BUDGET_ENTITIES.
• SOB_ID and COA_ID — the set of books and chart of accounts context for the range.
• BUDGET, BUDGET_VERSION_ID, and PERIOD_NAME — budget and period qualifiers for the selection.
• SEGMENT1_LOW … SEGMENT30_HIGH — low/high range pairs for each Accounting Flexfield segment.
• SEGMENTS_LOW_CCID and SEGMENTS_HIGH_CCID — compiled code combination identifiers for the low and high bounds, with matching …_DESC description columns.
• LINE_NUM — ordering of source lines within the dossier.
• Standard WHO audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical use is the retrieval of all sources belonging to a dossier, along with their flexfield ranges, for reporting or for feeding downstream budget execution logic.

• List sources for a dossier:

  SELECT source_id, dossier_id, budget_entity_name, period_name
  FROM   igi.igi_dos_sources
  WHERE  dossier_id = :p_dossier_id
  ORDER  BY line_num;

• Resolve the budget entity details by joining to GL_BUDGET_ENTITIES on BUDGET_ENTITY_ID.
• Determine destination mappings by joining to IGI_DOS_DESTINATIONS on SOURCE_ID.
• Range-oriented reporting: extract SEGMENT1_LOW through SEGMENTn_HIGH pairs to reconstruct the account range selected by each source line.

Because the table holds 79 columns, queries should project only required columns to avoid unnecessary I/O on this wide structure.

Related Objects

• IGI_DOS_DESTINATIONS — references this table via SOURCE_ID, forming the destination side of the dossier mapping.
• GL_BUDGET_ENTITIES — referenced by IGI_DOS_SOURCES.BUDGET_ENTITY_ID.
• The dossier parent object identified by DOSSIER_ID (the referenced foreign table is not fully resolved in the provided metadata).
• Standard IGI dossier processing logic, which consumes source and destination rows together to build budget or accounting selections.