Search Results group_by_organization_name

Overview

APPS.HRFV_ORGANIZATION_ROLLUP is a Business Intelligence System (BIS) view in the Oracle E-Business Suite APPS schema, registered in FND Design Data under the product short name PER. It exposes the emulated rollup capabilities historically provided by BIS Reports, allowing organization hierarchy reporting to be driven from a standard relational view rather than from the legacy BIS folder structures. The view is documented as VALID and is owned by APPS.

Because the rollup behaviour is emulated, the view does not derive its result set dynamically from transactional data alone. The concurrent process "BIS Load Organization Hierarchy Table" must be executed before the view returns meaningful rows; the process materializes the organization hierarchy data that the view subsequently projects. This dependency makes HRFV_ORGANIZATION_ROLLUP a reporting and integration surface rather than a real-time operational object.

The view is primarily used by Oracle HRMS and related reporting layers to resolve organization rollup definitions, including the identification of a top organization within a hierarchy. This is directly relevant to the search term "top_organization_name", which is exposed as a first-class column on the view.

Underlying Base Objects

The view is defined over the following documented objects:

• HR_ALL_ORGANIZATION_UNITS_TL — supplies the translated organization unit names used for the name columns.
• PER_ORGANIZATION_STRUCTURES — supplies the hierarchy relationships between organization units.
• HRI_ORG_PARAMS and HRI_ORG_PARAM_LIST — supply the BIS parameter and parameter list definitions that drive rollup selection.
• HR_BIS — the HR BIS package that supplies the emulated rollup logic invoked by the view.

The dependent objects are referenced through APPS synonyms, and the view appears in the dependency chain below PUBLIC.HRFV_ORGANIZATION_ROLLUP. The documented query text is a straightforward projection of twelve columns from APPS.HRFV_ORGANIZATION_ROLLUP with no filter predicates, indicating that row selection and parameterisation are handled internally by the underlying BIS package and hierarchy table.

Key Columns

The view exposes twelve columns. The principal text columns are:

• BUSINESS_GROUP_NAME and BUSINESS_GROUP_ID — the business group context for the hierarchy.
• ORGANIZATION_HIERARCHY — the name of the organization hierarchy being reported.
• PRIMARY_FLAG — indicates whether the hierarchy is the primary hierarchy.
• TOP_ORGANIZATION_NAME and TOP_ORG_ID — the name and identifier of the top organization in the rollup, which is the object referenced by the "top_organization_name" search.
• GROUP_BY_ORGANIZATION_NAME — the organization used as the grouping level within the rollup.
• ORGANIZATION_NAME — the organization unit displayed at the reporting level.
• INCLUDE_SUBORDINATES and ROLLUP — flags controlling whether subordinate organizations are included and how the rollup is applied.
• ROLLUP_ORG_ID and ORG_ID — the identifiers of the rollup organization and the reported organization respectively.

Common Use Cases and Queries

Typical usage includes validating hierarchy rollup definitions, building HRMS reports that display organizations under a designated top organization, and integrating organization hierarchy data into downstream reporting or data warehouse loads. A basic query to retrieve top organization names by hierarchy is:

• SELECT ORGANIZATION_HIERARCHY, TOP_ORGANIZATION_NAME, ORGANIZATION_NAME FROM APPS.HRFV_ORGANIZATION_ROLLUP;
• SELECT TOP_ORG_ID, TOP_ORGANIZATION_NAME FROM APPS.HRFV_ORGANIZATION_ROLLUP WHERE PRIMARY_FLAG = 'Y';
• SELECT BUSINESS_GROUP_NAME, GROUP_BY_ORGANIZATION_NAME, ROLLUP FROM APPS.HRFV_ORGANIZATION_ROLLUP WHERE BUSINESS_GROUP_ID = :p_business_group_id;

Because the view returns unfiltered rows, queries should always be constrained by business group, hierarchy, or organization identifiers to avoid full materialized scans. Ensure the "BIS Load Organization Hierarchy Table" concurrent process has completed successfully before relying on the results.