Results for “igi_dos_default_values”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGI_DOS_DEFAULT_VALUES view is a reporting and integration construct in the IGI - Public Sector Financials International product family within Oracle E-Business Suite, residing in the APPS schema and holding VALID status in both 12.1.1 and 12.2.2. It presents a consolidated list of default values that may be applied to dossier (document of service) numbering and segment configuration. Rather than storing data of its own, the view derives its rows at runtime by unioning selections from several Key Flexfield and IGI dossier configuration objects, presented through four generic columns. Its role is to provide a single, flat source of candidate default values that IGI Public Sector Financials uses when assigning segments, flex values, value sets, or numbering schemes to dossiers.

Underlying Base Objects

The view is documented as being based on FND_ID_FLEX_SEGMENTS, FND_FLEX_VALUES, FND_FLEX_VALUE_SETS, IGI_DOSSIER_NUMBERING, and IGI_DOS_SOURCE_USAGES_V. In the APPS schema these resolve through synonyms. The union structure is significant: the first branch joins FND_FLEX_VALUES, FND_ID_FLEX_SEGMENTS, FND_FLEX_VALUE_SETS, IGI_DOSSIER_NUMBERING, and IGI_DOS_SOURCE_USAGES_V to return segment-level defaults, tagged with a key of 'S'. A second branch of 'V' rows is drawn directly from FND_FLEX_VALUE_SETS, exposing value set identifiers and names. A third branch of 'N' rows is drawn from IGI_DOSSIER_NUMBERING where the numbering type is 'SEG' and the record is enabled, excluding numbering schemes already referenced in IGI_DOS_SOURCE_USAGES_V. A commented-out 'P' branch referencing FND_PROFILE_OPTIONS_VL is present in the definition but not active. This view therefore touches the core Flexfield definitions that many administrators know through the fnd_flex_value_sets table.

Key Columns

The view exposes four columns, all generically named to accommodate the union:

• DEFAULT_KEY0 — a discriminator indicating the origin of the row: 'S' for segment/value defaults, 'V' for value set entries, and 'N' for numbering schemes.
• DEFAULT_KEY1 — the primary identifier for the source, such as ID_FLEX_NUM, FLEX_VALUE_SET_ID, or COA_ID.
• DEFAULT_KEY2 — the descriptive name, such as SEGMENT_NAME, FLEX_VALUE_SET_NAME, or NUMBERING_SCHEME.
• DEFAULT_VALUE — the value offered as a default, such as FLEX_VALUE or the numbering scheme name itself.

Common Use Cases and Queries

Because the search that surfaced this object referenced fnd_flex_value_sets, the most frequent use is retrieving the value sets available for dossier segment defaults. A representative query is:

• SELECT DEFAULT_KEY0, DEFAULT_KEY1, DEFAULT_KEY2, DEFAULT_VALUE FROM APPS.IGI_DOS_DEFAULT_VALUES WHERE DEFAULT_KEY0 = 'V' ORDER BY DEFAULT_KEY2;
• SELECT DEFAULT_KEY1, DEFAULT_KEY2, DEFAULT_VALUE FROM APPS.IGI_DOS_DEFAULT_VALUES WHERE DEFAULT_KEY0 = 'N';
• SELECT DEFAULT_KEY0, DEFAULT_KEY1, DEFAULT_KEY2, DEFAULT_VALUE FROM APPS.IGI_DOS_DEFAULT_VALUES WHERE DEFAULT_KEY2 = :segment_name;

These queries support configuration reporting, validation of available defaults prior to dossier setup, and diagnostic work when default values fail to appear in the IGI Public Sector Financials interface. Because the view is a union of live configuration objects without a base table of its own, any change to the referenced value sets, segments, or numbering schemes is reflected immediately on the next query.