Search Results o_mgr

Overview

APPS.HRI_CL_ORG_CC_MGR_SUPH_V is a reporting view within the Oracle E-Business Suite (EBS) Human Resources Intelligence (HRMSi / HR Analytics) product family. It is one of the seeded objects delivered under the HRI_ prefix, which identifies the HR Intelligence and data warehouse components used for organizational and workforce analytics. The view is designed to resolve the relationship between an organization cost center and the supervisory hierarchy of persons assigned to that organization, exposing both the cost center identity and the manager-to-subordinate supervisory chain in a single flattened result set.

Because it consolidates cost center context with supervisory hierarchy attributes, the view is typically consumed by operational reporting, dashboards, and integration extracts that need to correlate a general ledger cost center (CC) with the people who manage or report within that organization. It is not a transactional entity view; it is a read-only, query-oriented projection intended for reporting and downstream ETL, and as such it carries no update capability.

Underlying Base Objects

The view is defined over three referenced objects, as shown in the documented view text:

• HRI_CL_ORG_CC_V — the cost center organization view, aliased as CL_CC, which supplies the organization cost center identifier and value.
• HR_ORGANIZATION_INFORMATION — the base HR table storing organization descriptive and alias information, aliased as O_MGR. The view filters this table on ORG_INFORMATION_CONTEXT = 'Organization Name Alias'.
• HRI_CS_SUPH_V — the supervisory hierarchy view, aliased as CS_SUP, which supplies the effective-dated supervisory relationships between managers and subordinates.

The join logic links CL_CC.ID to O_MGR.ORGANIZATION_ID, and O_MGR.ORG_INFORMATION2 to CS_SUP.SUB_PERSON_ID. This means the alias value held in ORG_INFORMATION2 must match the subordinate person identifier in the supervisory hierarchy. The result is a cost-center-to-supervisor-hierarchy bridge keyed on the person alias stored against the organization record. No additional base tables beyond these three are documented for this view.

Key Columns

• ID — the organization/cost center identifier derived from HRI_CL_ORG_CC_V.ID.
• VALUE — the cost center value or name associated with that identifier.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date range during which the supervisory relationship is valid, sourced from HRI_CS_SUPH_V.
• SUP_PERSON_ID — the person identifier of the supervisor (the manager) in the relationship.
• SUB_PERSON_ID — the person identifier of the subordinate, which is the column matched against the organization alias.
• SUB_RELATIVE_LEVEL — the relative depth of the subordinate within the supervisory hierarchy.
• SUB_ABSOLUTE_LEVEL — the absolute level of the subordinate within the full hierarchy tree.

Common Use Cases and Queries

Typical scenarios include identifying the managers associated with a given cost center, listing subordinates reporting into a cost center's supervisory chain, and feeding hierarchy-aware datasets into workforce analytics.

Basic listing of cost center supervisory relationships:

• SELECT ID, VALUE, SUP_PERSON_ID, SUB_PERSON_ID, SUB_RELATIVE_LEVEL FROM APPS.HRI_CL_ORG_CC_MGR_SUPH_V;

Filtering to current effective relationships for a specific cost center:

• SELECT ID, VALUE, SUP_PERSON_ID, SUB_PERSON_ID, SUB_ABSOLUTE_LEVEL FROM APPS.HRI_CL_ORG_CC_MGR_SUPH_V WHERE VALUE = :p_cost_center AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Ordering subordinates by hierarchy depth for a manager:

• SELECT SUB_PERSON_ID, SUB_RELATIVE_LEVEL, SUB_ABSOLUTE_LEVEL FROM APPS.HRI_CL_ORG_CC_MGR_SUPH_V WHERE SUP_PERSON_ID = :p_manager_id ORDER BY SUB_ABSOLUTE_LEVEL;

Note that references to "cs_sup" in the search correspond to the CS_SUP alias of HRI_CS_SUPH_V in the view definition. As with other HR Intelligence views, appropriate HRMS security and the correct reporting responsibility should be applied to ensure row-level access compliance.