Search Results info_exists

Overview

APPS.PER_SPECIAL_INFO_TYPES_V is a supplementary Oracle EBS view owned by the APPS schema, registered under FND Design Data as PER.PER_SPECIAL_INFO_TYPES_V and documented as VALID across 12.1.1 and 12.2.2. It exposes the definition of Special Information Types (SITs) — the configurable Extra Information categories used by Oracle HRMS to capture person-level, assignment-level, and other entity-level descriptive flexfield data. The view is a classic "supplementary view used to simplify forms coding," and Oracle explicitly warns that it should not be queried or altered directly for data maintenance because its definition may change dramatically in subsequent minor or major releases. In practice, it functions as a read-only reporting and integration surface over the SIT definitions registered in the enterprise's HRMS configuration.

Underlying Base Objects

The documented dependency list for this view references two objects: FND_ID_FLEX_STRUCTURES_VL (VIEW) and PER_SPECIAL_INFO_TYPES (SYNONYM). The synonym resolves to the PER_SPECIAL_INFO_TYPES base table, which stores the SIT records themselves, including the descriptive flexfield structure number (ID_FLEX_NUM), the business group context, and the audit columns. FND_ID_FLEX_STRUCTURES_VL is the Application Object Library's translated view of descriptive flexfield structure definitions, supplying the flexfield-level attributes needed to resolve and validate each Special Information Type against its underlying structure. The join between PER_SPECIAL_INFO_TYPES and FND_ID_FLEX_STRUCTURES_VL yields the effective SIT definition exposed by the view.

Key Columns

• SPECIAL_INFORMATION_TYPE_ID — Primary identifier for the Special Information Type definition.
• BUSINESS_GROUP_ID — Business group that owns the SIT, enabling multi-organization filtering.
• ID_FLEX_NUM — Descriptive flexfield structure number that governs the SIT's segments; the link back to FND_ID_FLEX_STRUCTURES_VL.
• NAME — User-visible name of the Special Information Type (for example, "Passport Details" or "Emergency Contact").
• INFO_EXISTS — Flag column, directly relevant to the user's search term, indicating whether an information type record exists for the relevant context.
• COMMENTS — CLOB column holding descriptive text for the SIT.
• ENABLED_FLAG — Indicates whether the SIT is active and available for data entry.
• ROW_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — Standard audit and row-versioning columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program who-columns for change tracking.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — Developer descriptive flexfield attributes available for extension.

Common Use Cases and Queries

Typical usage is read-only: identifying which Special Information Types are enabled for a business group, joining to flexfield structure definitions for reporting, or feeding data-migration and integration scripts. Because the view is flagged in ETRM as not recommended for direct query, production integrations should generally prefer the base table PER_SPECIAL_INFO_TYPES or supported APIs, but the view remains useful for diagnostic and investigative SQL.

A representative query to list enabled SITs within a business group is:

• SELECT special_information_type_id, name, info_exists, enabled_flag FROM apps.per_special_info_types_v WHERE business_group_id = :p_bg_id AND enabled_flag = 'Y' ORDER BY name;
• SELECT name, id_flex_num FROM apps.per_special_info_types_v WHERE info_exists = 'Y';
• SELECT name, comments FROM apps.per_special_info_types_v WHERE business_group_id = :p_bg_id AND enabled_flag = 'Y';

Because the object is a view over a synonym and a translated flexfield view, results reflect current configuration immediately; no invalidation or snapshot refresh is required, though consumers should treat the structure as subject to change between releases.