Search Results top_org_id

Overview

HRFV_ORGANIZATION_ROLLUP is an APPS-owned, VALID database view belonging to the Oracle Human Resources (PER) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Oracle documents it as a business view template from which the flexfield view is generated. In practice it exposes organization hierarchy and rollup information in a flattened, reporting-friendly form, allowing consumers to enumerate the organizations that participate in a given organization hierarchy along with flags describing whether a particular organization acts as a top organization, a group-by organization, or a subordinate organization, and whether subordinates are included or rolled up.

Because it is defined WITH READ ONLY, the view is intended strictly for query and reporting access, not for DML. It is commonly surfaced through Oracle Business Intelligence Applications, HRMS reporting extracts, and custom concurrent programs that need to traverse the organization hierarchy without manually joining the underlying HRMS hierarchy tables. The view decodes internal process codes into user-friendly Yes/No values via the HR_BIS package, and it honors the session language and the security profile of the connecting user, so results are naturally filtered to the accessible business group.

Underlying Base Objects

The documented view metadata lists the following referenced base objects: HRI_ORG_PARAMS (synonym), HRI_ORG_PARAM_LIST (synonym), HR_ALL_ORGANIZATION_UNITS_TL (synonym), HR_BIS (package), and PER_ORGANIZATION_STRUCTURES (synonym).

• PER_ORGANIZATION_STRUCTURES — supplies the organization hierarchy definition and links each structure to its business group.
• HRI_ORG_PARAMS — supplies the top organization and the organization_process code that drives the INCLUDE_SUBORDINATES and ROLLUP decode logic.
• HRI_ORG_PARAM_LIST — supplies the group (parent) and child organization identifiers that form each rollup pair.
• HR_ALL_ORGANIZATION_UNITS_TL — joined four times (aliases BGRT, ORGTOPT, ORGGROUPT, ORGSUBT) to resolve the translated names of the business group, top organization, group-by organization, and subordinate organization.
• HR_BIS — the packaged decode utility used to translate lookup values such as YES_NO and process codes into readable text, and to apply security profile filtering via GET_SEC_PROFILE_BG_ID.

Key Columns

• BUSINESS_GROUP_NAME / BUSINESS_GROUP_ID — the business group owning the hierarchy, filtered by the user's security profile.
• ORGANIZATION_HIERARCHY — the name of the organization structure (hierarchy) being queried.
• PRIMARY_FLAG — indicates whether the hierarchy is the primary structure for the business group.
• TOP_ORGANIZATION_NAME / TOP_ORG_ID — the top organization defined for the hierarchy.
• GROUP_BY_ORGANIZATION_NAME / ROLLUP_ORG_ID — the grouping organization within the rollup list.
• ORGANIZATION_NAME / ORG_ID — the subordinate (child) organization in the rollup.
• INCLUDE_SUBORDINATES / ROLLUP — decoded Yes/No flags derived from ORG_PROCESS in HRI_ORG_PARAMS, indicating how the organization participates in inclusion and rollup processing.

Common Use Cases and Queries

Typical scenarios include validating hierarchy rollups, driving security-aware org listings for reports, and reconciling organization structures during upgrades or conversions.

Example — list all rollup lines for a hierarchy:

SELECT organization_hierarchy
     , top_organization_name
     , group_by_organization_name
     , organization_name
     , include_subordinates
     , rollup
  FROM apps.hrfv_organization_rollup
 WHERE organization_hierarchy = :p_hierarchy;

Example — find subordinate organizations that roll up to a given group:

SELECT organization_name, org_id
  FROM apps.hrfv_organization_rollup
 WHERE group_by_organization_name = :p_group
   AND rollup = 'Yes';

Because the view already applies USERENV('LANG') and security profile filtering, results adapt automatically to the connecting user's language and accessible business group, making it suitable for direct use in concurrent programs and BI extracts without additional security predicates.