Results for “people_group_kf_structure_id”

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

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

• BUSINESS_GROUP_ID – the organization_id of the Business Group.
• BUSINESS_GROUP_NAME / BUSINESS_GROUP_SHORT_NAME – organization name and the DFF-supplied short name.
• DEFAULT_CURRENCY_CODE – sourced from ORG_INFORMATION10 of the Business Group information record; the currency default applied to the Business Group.
• DEFAULT_START_TIME, DEFAULT_END_TIME, WORKING_HOURS_AMOUNT, WORKING_HOURS_FREQUENCY – the group's standard working time definitions.
• EMP_NUMBER_GENERATION_METHOD, APL_NUMBER_GENERATION_METHOD – decoded lookup meanings for employee and applicant numbering.
• LEGISLATION_CODE, ENABLED_FLAG – legislative context and enablement status.
• GRADE_STRUCTURE, PEOPLE_GROUP_STRUCTURE, JOB_STRUCTURE, COST_ALLOCATION_STRUCTURE, POSITION_STRUCTURE, COMPETENCE_STRUCTURE – flexfield structure names.
• DATE_FROM, DATE_TO, INTERNAL_ADDRESS_LINE, COMMENTS, LOCATION_ID – organization descriptive attributes.

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.