Search Results competence_kf_structure_id

Overview

APPS.HRFV_BUSINESS_GROUPS is a Business Intelligence System (BIS) view in Oracle E-Business Suite, owned by the APPS schema and registered under FND Design Data as PER.HRFV_BUSINESS_GROUPS. Its status is VALID in both EBS 12.1.1 and 12.2.2. The view exposes the definition of business groups configured within an enterprise. A business group is the highest organizational unit in Oracle HRMS and represents a legislative and reporting boundary; each business group may maintain its own set of internal organizations, grades, jobs, positions, payrolls, employees, applicants, and related configuration.

Because business group configuration drives number generation, default currency, legislation, and the key flexfield structures assigned to grades, jobs, positions, people groups, and cost allocation, this view is frequently used as a reference point in reporting and integration. It provides a denormalized, read-only presentation of the business group header together with its structural assignments, allowing report writers and interface developers to resolve business group attributes without joining the many underlying HR tables directly.

Underlying Base Objects

The documented base objects referenced by the view are FND_ID_FLEX_STRUCTURES_TL (SYNONYM), HR_ALL_ORGANIZATION_UNITS (SYNONYM), HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM), HR_ORGANIZATION_INFORMATION (SYNONYM), and the HR_BIS package. The business group is stored as an organization unit in HR_ALL_ORGANIZATION_UNITS, with its translated name and description held in HR_ALL_ORGANIZATION_UNITS_TL. Configuration attributes that are not held on the organization unit itself, such as number generation methods, default currency, and structure assignments, are stored as descriptive flexfield or organization information rows in HR_ORGANIZATION_INFORMATION. Key flexfield structure identifiers are resolved through FND_ID_FLEX_STRUCTURES_TL. The HR_BIS package supplies the business intelligence logic that assembles these rows into the flat structure presented by the view.

Key Columns

• BUSINESS_GROUP_ID – Primary surrogate key identifying the business group; joins to organization and HR tables.
• BUSINESS_GROUP_NAME / BUSINESS_GROUP_SHORT_NAME – Display name and short name of the business group.
• EMP_NUMBER_GENERATION_METHOD – Controls how employee numbers are generated (for example manual entry or automatic numbering) for the business group.
• APL_NUMBER_GENERATION_METHOD – Controls number generation for applicants.
• DATE_FROM / DATE_TO – Effective date range of the business group definition.
• DEFAULT_CURRENCY_CODE, LEGISLATION_CODE, ENABLED_FLAG – Default currency, legislative context, and active status.
• GRADE_STRUCTURE, JOB_STRUCTURE, POSITION_STRUCTURE, PEOPLE_GROUP_STRUCTURE, COST_ALLOCATION_STRUCTURE, COMPETENCE_STRUCTURE – Key flexfield structure names assigned to each business group entity.
• GRADE_KF_STRUCTURE_ID, JOB_KF_STRUCTURE_ID, POSITION_KF_STRUCTURE_ID, PEOPLE_GROUP_KF_STRUCTURE_ID, COSTING_KF_STRUCTURE_ID, COMPETENCE_KF_STRUCTURE_ID – Corresponding structure identifiers.
• DEFAULT_START_TIME / DEFAULT_END_TIME, WORKING_HOURS_AMOUNT, WORKING_HOURS_FREQUENCY – Default working time attributes.
• LOCATION_ID, INTERNAL_ADDRESS_LINE, COMMENTS – Location reference, internal address, and free-text comments.

Common Use Cases and Queries

A frequent requirement is to determine the employee number generation method configured for a business group, which the user searched for as emp_number_generation_method. The following query returns the business group, its number generation methods, currency, and legislation:

SELECT business_group_id,
      business_group_name,
      emp_number_generation_method,
      apl_number_generation_method,
      default_currency_code,
      legislation_code
FROM  apps.hrfv_business_groups
WHERE  enabled_flag = 'Y';

Other common scenarios include identifying the key flexfield structures assigned to a business group before loading grades, jobs, or positions, and validating the legislation code and default currency during data conversion or interface design. Reporting solutions frequently join BUSINESS_GROUP_ID to HR_ALL_ORGANIZATION_UNITS and PER_ALL_PEOPLE_F to aggregate headcount by business group, while integration scripts reference this view to confirm configuration before inserting number-controlled records. Because it is a BIS view, it should be treated as read-only and not used as a target for DML.