Search Results hrfv_business_groups




Overview
Explore in AI Chat

Overview

HRFV_BUSY_BUSINESS_GROUPS is a business view template registered in the APPS schema under the PER – Human Resources product family. In Oracle EBS 12.1.1 and 12.2.2 it functions as the source definition from which a generated flexfield view is produced; the "HRFV" prefix denotes the Human Resources Flexfield View generation convention. The view consolidates a Business Group organization unit with its descriptive flexfield (DFF) attributes and the identity flexfield structures associated with that group. For reporting and integration purposes it presents a single denormalized row per Business Group, exposing both standard organization attributes and the configuration stored in the HR_ORGANIZATION_INFORMATION DFF segments.

The view is particularly relevant to users searching for default_currency_code, because that value is sourced from the Business Group DFF and is exposed here as a named column rather than as a generic ORG_INFORMATIONn segment. This makes the view a convenient read-only interface for reporting on Business Group-level defaults without decoding the underlying key flexfield segment positions.

Underlying Base Objects

The view is defined over the following documented base objects:

  • HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL – the organization unit header and its translated name/description.
  • HR_ORGANIZATION_INFORMATION – the DFF store that holds Business Group attributes; joined multiple times (aliased O2, O3, O4) to separate information types such as Business Group, Business Group Information, and related configuration.
  • FND_ID_FLEX_STRUCTURES_TL – joined six times (F1–F6) to resolve the names of the Grade, People Group, Job, Cost Allocation, Position, and Competence key flexfield structures.
  • HR_BIS – a PL/SQL package supplying BIS_DECODE_LOOKUP, used to translate coded DFF values into readable lookup meanings.

Each join keys on ORGANIZATION_ID (and organization_id/ID_FLEX_STRUCTURE_ID for the flexfield structures), so the view remains consistent with the Business Group definition held in HR_ALL_ORGANIZATION_UNITS.

Key Columns

Common Use Cases and Queries

Typical uses include validating Business Group configuration, driving downstream reporting, and confirming the default currency assigned to a group.

  • Listing all Business Groups with their default currency and legislation.
  • Auditing working-time and numbering defaults across groups.
  • Resolving flexfield structure names used by a Business Group.

For example:

SELECT business_group_id, business_group_name, default_currency_code, legislation_code FROM apps.hrfv_business_groups;

Or, filtering to a specific currency:

SELECT business_group_name, default_currency_code FROM apps.hrfv_business_groups WHERE default_currency_code = 'USD';

Because HRFV_BUSINESS_GROUPS is a template-driven view, its exact column list is regenerated against the installed Business Group flexfield definition; implementers should therefore confirm the view text in their instance rather than assuming a fixed column set.