Search Results hierarchy_version_start_date




Overview
Explore in AI Chat

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:

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

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.