Search Results hribv_org_hrchy




Overview
Explore in AI Chat

Overview

HRIBV_ORG_HRCHY is an APPS-owned read-only view in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, shipped under the HRI – Human Resources Intelligence product family. HRI is now marked obsolete in current EBS releases, and the view is retained for backward compatibility with legacy HR reporting extracts, Discoverer workbooks, and pre-OBIEE HR analytics. The view presents a flattened, report-ready hierarchy of organization structures and the organizations and sub-organizations that participate in each version of a hierarchy. Because the view joins structure versions to organization-unit translations and decodes the primary-structure flag through the HR_BIS package, it delivers business-user-facing names rather than raw IDs.

The search term "sub_organization_level" corresponds to a real column on this view. It exposes the level at which a sub-organization occupies its node within the parent hierarchy, complementing the ORGANIZATION_LEVEL column that describes the level of the parent organization node. The column carries a NOT NULL semantic in the view text, meaning every summary row reflects a defined depth within the structure.

Underlying Base Objects

Per ETRM metadata, the view is defined over five referenced objects:

Key Columns

Common Use Cases and Queries

Typical uses include hierarchy-level flattening for headcount rollups, validation of sub-organization placement across structure versions, and extraction of dated hierarchy reports for downstream BI. Because the view is WITH READ ONLY, it is strictly a reporting object.

Filtering by sub-organization level:

  • SELECT HIERARCHY_NAME, ORGANIZATION_NAME, SUB_ORGANIZATION_NAME, SUB_ORGANIZATION_LEVEL FROM APPS.HRIBV_ORG_HRCHY WHERE SUB_ORGANIZATION_LEVEL = 2;

Listing all versions of a named hierarchy:

  • SELECT HIERARCHY_NAME, HIERARCHY_VERSION, HRCHY_VERSION_DATE_TO_NN FROM APPS.HRIBV_ORG_HRCHY WHERE HIERARCHY_NAME = '&hier';

Restricting to the primary structure for a business group:

  • SELECT ORGANIZATION_NAME, SUB_ORGANIZATION_NAME FROM APPS.HRIBV_ORG_HRCHY WHERE HRCHY_PRIMARY_FLAG = 'Y' AND HRCHY_BUSINESS_GROUP_NAME = '&bg';

Given HRI obsolescence, new development should consider PER_ORGANIZATION_STRUCTURES and PER_ORG_STRUCTURE_VERSIONS directly, but HRIBV_ORG_HRCHY remains a convenient, pre-joined reporting shortcut.