Results for “sub_organization_id”

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

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:

• HRI_ORG_HRCHY_SUMMARY (synonym) – the driving summary table containing ORG_STRUCTURE_VERSION_ID, ORGANIZATION_ID, SUB_ORGANIZATION_ID, ORGANIZATION_LEVEL, and SUB_ORGANIZATION_LEVEL.
• PER_ORGANIZATION_STRUCTURES (synonym) – supplies the hierarchy name (NAME), PRIMARY_STRUCTURE_FLAG, and ORGANIZATION_STRUCTURE_ID.
• PER_ORG_STRUCTURE_VERSIONS (synonym) – supplies VERSION_NUMBER, DATE_FROM, and DATE_TO for each dated hierarchy version.
• HR_ALL_ORGANIZATION_UNITS_TL (synonym, used three times) – resolves the translated names of the business group, the organization, and the sub-organization, restricted to USERENV('LANG').
• HR_BIS (package) – used to decode PRIMARY_STRUCTURE_FLAG into the YES/NO lookup display value.
• HR_GENERAL (package) – provides END_OF_TIME, used through NVL to produce a non-null version end date.

Key Columns

• HIERARCHY_NAME / HIERARCHY_VERSION / HIERARCHY_VERSION_DATE_FROM / HIERARCHY_VERSION_DATE_TO – identity and effective dating of the organization structure version.
• HRCHY_PRIMARY_FLAG / HRCHY_PRIMARY_FLAG_CODE – decoded YES/NO display value versus the underlying flag.
• HRCHY_BUSINESS_GROUP_NAME – the business group that owns the hierarchy.
• ORGANIZATION_NAME / ORGANIZATION_LEVEL – the parent organization node and its level in the hierarchy.
• SUB_ORGANIZATION_NAME / SUB_ORGANIZATION_LEVEL – the child sub-organization and the level at which it sits; SUB_ORGANIZATION_LEVEL is documented as NOT NULL.
• HRCHY_VERSION_DATE_TO_NN – NVL(DATE_TO, END_OF_TIME) for open-ended versions.
• ID columns – ORG_HIERARCHY_ID, ORG_HRCHY_BUSINESS_GROUP_ID, ORG_HRCHY_VERSION_ID, ORG_BUSINESS_GROUP_ID, ORGANIZATION_ID, SUB_ORG_BUSINESS_GROUP_ID, SUB_ORGANIZATION_ID, supporting drill-down joins back to PER and HR base tables.

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.