Results for “information_type”

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

Overview

The HRFV_PERSON_SPECIAL_INFO view is a business view template within the PER (Human Resources) product of Oracle E-Business Suite. In the EBS 12.1.1 and 12.2.2 releases, it resides in the APPS schema with a status of VALID. As its documented description indicates, it is a template from which the flexfield view is generated. This places it within the family of "HRFV" (HR Flexfield View) objects that Oracle HRMS uses to expose person special information — the descriptive flexfield-based "Special Information Types" (SITs) that organizations configure to capture supplementary person data such as qualifications, competencies, or medical details.

The view presents a denormalized, readable projection of person analysis records, resolving raw foreign keys into meaningful business names and applying organizational security. Rather than requiring report authors and integrators to join analysis criteria, flexfield structures, and organization translations manually, HRFV_PERSON_SPECIAL_INFO delivers a single query surface that is suitable for reporting tools, concurrent programs, and integration extracts.

Underlying Base Objects

The view is defined over a set of base tables, synonyms, and supporting packages. Documented referenced objects include:

• PER_PERSON_ANALYSES (synonym) — the transaction table holding each person's special information records, keyed by PERSON_ID and ANALYSIS_CRITERIA_ID.
• PER_ANALYSIS_CRITERIA (synonym) — ties each analysis record to a descriptive flexfield structure via ID_FLEX_NUM.
• PER_SPECIAL_INFO_TYPES (synonym) — controls which special information types are enabled (ENABLED_FLAG = 'Y').
• FND_ID_FLEX_STRUCTURES_VL (view) — provides the descriptive flexfield structure name (ID_FLEX_STRUCTURE_NAME) for the PEA flexfield code.
• HR_ALL_ORGANIZATION_UNITS_TL (synonym) — supplies the translated business group name.
• PER_PEOPLE_X (view) — the person view providing the full person name.

Supporting packages include HR_BIS, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY. The view text confirms that only flexfield structures with APPLICATION_ID = 800 and ID_FLEX_CODE = 'PEA' are eligible, restricted to enabled special information types, and filtered by HR_BIS.GET_SEC_PROFILE_BG_ID so that users only see data for business groups within their security profile.

Key Columns

• BUSINESS_GROUP_NAME — translated name of the business group owning the record.
• PERSON_NAME — full name of the person (from PER_PEOPLE_X).
• START_DATE / END_DATE — validity dates of the special information record.
• INFORMATION_TYPE — name of the descriptive flexfield structure, i.e. the Special Information Type.
• _DF:PER_PERSON_ANALYSES — a literal marker identifying the descriptive flexfield context segment.
• BUSINESS_GROUP_ID, ID_FLEX_NUM, PERSON_ID — foreign keys enabling joins back to base HR tables.

The view is declared WITH READ ONLY, so it cannot be used as a DML target.

Common Use Cases and Queries

Typical uses include HR reporting on qualifications and competencies, extracting person special information for interfaces, and feeding BI Publisher or OBIEE reports. A representative query:

• SELECT person_name, information_type, start_date, end_date FROM apps.hrfv_person_special_info WHERE person_id = :p_person_id;
• SELECT business_group_name, information_type, COUNT(*) FROM apps.hrfv_person_special_info GROUP BY business_group_name, information_type;

Because the view enforces HR security through HR_BIS and USERENV language settings, results are automatically scoped to the querying user's business group access and session language, making it suitable for secured, multi-organization deployments.