Search Results per_people_x




Overview
Explore in AI Chat

Overview

HRIBV_SUPV_HRCHY_X is a read-only view owned by the APPS schema within the HRI (Human Resources Intelligence) product family of Oracle E-Business Suite. It presents the flattened supervisor-to-subordinate hierarchy across business groups, combining the pre-aggregated supervisory hierarchy summary with multilingual organization and person name lookups. Its purpose is to expose denormalized hierarchy reporting data — supervisor and subordinate names, organizational context, hierarchy levels, and assignment identifiers — so that downstream reporting tools, dashboards, and analytic extracts within the HR Intelligence module can traverse the management chain without navigating the recursive structures in the base HR tables. The view is defined WITH READ ONLY, confirming that it is intended strictly for query and reporting consumption and not for DML. Because it surfaces person-level hierarchy data, access is subject to HR Security enforcement through the HR_SECURITY package referenced in its dependency chain. The documented status is VALID in both 12.1.1 and 12.2.2.

Underlying Base Objects

The view selects from four directly referenced objects. HRI_SUPV_HRCHY_SUMMARY (documented as HRI_CS_SUPH_X_V at the 12.2.2 metadata level) supplies the pre-computed supervisory hierarchy: business group, person, and assignment identifiers for both supervisor and subordinate, together with the level values and the subordinate primary-assignment flag. HR_ALL_ORGANIZATION_UNITS_TL (exposed through a synonym) supplies the translated business group name, joined on SUPV_BUSINESS_GROUP_ID with the outer-join (+) syntax and constrained to the session language via USERENV('LANG'). Two aliased instances of PER_PEOPLE_X — PER and PER2 — are joined on PERSON_ID to resolve the supervisor full name and the subordinate full name respectively. The package HR_GENERAL is invoked to decode the YES_NO lookup value for the subordinate primary-assignment flag, while HR_PERSON_NAME and HR_SECURITY are documented dependencies that govern name formatting and row-level security enforcement.

Key Columns

Common Use Cases and Queries

Typical uses include management-chain reporting, span-of-control analysis, and extraction of supervisor/subordinate pairs into external BI repositories. A basic hierarchy listing might be:

  • SELECT SUPERVISOR_PERSON_NAME, SUBORDINATE_PERSON_NAME, SUPERVISOR_LEVEL, SUBORDINATE_LEVEL FROM APPS.HRIBV_SUPV_HRCHY_X WHERE SUPERVISOR_LEVEL < 3;
  • SELECT SUPERVISOR_BUSINESS_GROUP, COUNT(*) FROM APPS.HRIBV_SUPV_HRCHY_X GROUP BY SUPERVISOR_BUSINESS_GROUP;
  • SELECT * FROM APPS.HRIBV_SUPV_HRCHY_X WHERE SUPERVISOR_PERSON_ID = :person_id AND SUBORDINATE_PRIMARY_ASG_FLAG = 'Yes';

Users arriving from a search for PER_PEOPLE_X should note that this view is a reporting projection of that person view rather than a substitute for it; the person identifiers returned can be used to join back to PER_PEOPLE_X for additional attributes.