Search Results parent_position_name

Overview

APPS.HRFV_POSITION_HIERARCHIES is a business view template from which the flexfield view for the PER (Human Resources) product is generated. It exposes the full hierarchical decomposition of a position hierarchy within a selected business group, returning one row per parent-child position relationship and the version context under which that relationship was defined. Because the view joins the flattened descendant rows produced by HRBV_POSITION_DESCENDENTS against the position structure versions, it provides both the structural relationship and the effective dating of the hierarchy version, making it suitable for reporting on hierarchy composition at any point in time.

The view is read-only (defined WITH READ ONLY) and is secured at the business group level through the HR_BIS.GET_SEC_PROFILE_BG_ID security profile function, so query results are automatically filtered to the business groups the running user is permitted to see. In Oracle EBS 12.1.1 and 12.2.2 it is an APPS-owned, VALID database object and is typically surfaced through Oracle Business Intelligence, HRMS extracts, or ad hoc reporting where a caller needs to understand the position tree rather than just individual positions.

Underlying Base Objects

The view is defined over the following documented base objects:

• HRBV_POSITION_DESCENDENTS (VIEW) — supplies the flattened position hierarchy rows (POSITION_ID, PARENT_POSITION_ID, POS_LEVEL, BUSINESS_GROUP_ID, POS_STRUCTURE_VERSION_ID).
• PER_POS_STRUCTURE_VERSIONS (SYNONYM) — supplies version-level date ranges (DATE_FROM, DATE_TO), VERSION_NUMBER and POS_STRUCTURE_VERSION_ID.
• PER_POSITION_STRUCTURES (SYNONYM) — supplies the hierarchy name and its POSITION_STRUCTURE_ID.
• HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM) — supplies the translatable business group name (BGRT.NAME).
• HR_ALL_POSITIONS_F_TL (SYNONYM) — referenced by the position name lookups used to populate child and parent position names.
• HR_BIS (PACKAGE) — supplies HR_BIS.GET_SEC_PROFILE_BG_ID, the business group security filter applied in the WHERE clause.

The joins are keyed on POS_STRUCTURE_VERSION_ID, POSITION_STRUCTURE_ID, POSITION_ID, PARENT_POSITION_ID, and BUSINESS_GROUP_ID, ensuring that each descendant row is tied to the correct structure version and business group.

Key Columns

• BUSINESS_GROUP_NAME — translatable name of the business group (from HR_ALL_ORGANIZATION_UNITS_TL).
• POSITION_HIERARCHY_NAME — name of the position hierarchy/structure.
• CHILD_POSITION_NAME — position name prefixed by a dash-based indent derived from POS_LEVEL, giving visual depth.
• POSITION_HIERARCHY_LEVEL — numeric depth of the row within the hierarchy.
• PARENT_POSITION_NAME — the immediate parent position.
• HIERARCHY_VERSION_START_DATE / HIERARCHY_VERSION_END_DATE — the effective date range of the version (VER.DATE_FROM / VER.DATE_TO). This is the pair most often searched for, and it determines whether a hierarchy version is current.
• POSITION_HIERARCHY_VERSION — version number of the structure.
• BUSINESS_GROUP_ID, PARENT_POSITION_ID, CHILD_POSITION_ID, POSITION_HIERARCHY_ID, POS_HIERARCHY_VERSION_ID — surrogate keys for joining to other tables.

Common Use Cases and Queries

Typical uses include reporting the current position tree for a business group, identifying all children under a given parent, and resolving the effective version of a hierarchy for a given date.

SELECT BUSINESS_GROUP_NAME, POSITION_HIERARCHY_NAME,
       POSITION_HIERARCHY_LEVEL, CHILD_POSITION_NAME,
       PARENT_POSITION_NAME, POSITION_HIERARCHY_VERSION,
       HIERARCHY_VERSION_START_DATE, HIERARCHY_VERSION_END_DATE
FROM   APPS.HRFV_POSITION_HIERARCHIES
WHERE  TRUNC(SYSDATE)
         BETWEEN HIERARCHY_VERSION_START_DATE
         AND NVL(HIERARCHY_VERSION_END_DATE, SYSDATE)
ORDER BY POSITION_HIERARCHY_NAME, POSITION_HIERARCHY_LEVEL;

A second common pattern lists all children beneath a specific parent:

SELECT CHILD_POSITION_NAME, POSITION_HIERARCHY_LEVEL
FROM   APPS.HRFV_POSITION_HIERARCHIES
WHERE  PARENT_POSITION_ID = :parent_position_id
AND    POSITION_HIERARCHY_VERSION = :version_number;

Because results are automatically restricted by the HR security profile applied through HR_BIS, queries return only the business groups for which the session user has access, which is important when the view is used in multi-business-group reporting or integration extracts.