Search Results method_of_generation_apl_num

Overview

PER_BUSINESS_GROUPS_PERF is an APPS-owned performance view in the Oracle E-Business Suite Human Resources (PER) product. It presents business group definitions stored as organization units, denormalizing the descriptive flexfield segments that hold business group attributes into named, query-friendly columns. The view is designated a performance view because it is intended to support high-volume reporting and integration access against business group data without requiring callers to join the organization information table repeatedly or to know flexfield segment numbering.

In EBS 12.1.1 and 12.2.2 the view has the same purpose: it exposes one row per business group organization, filtered to organizations classified as HR_BG. Because business groups govern enterprise-wide HR configuration — including employee number generation, grade and job structures, and cost allocation structures — the view is a common source for configuration reporting, data migration scripts, and cross-product integration logic that must resolve a business group's setup parameters programmatically.

Underlying Base Objects

The view is defined over two documented base objects, referenced through APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS — aliased as O, supplying the organization identity and descriptive attributes such as name, effective dates, internal address line, location, and comments.
• HR_ORGANIZATION_INFORMATION — referenced twice, as O3 and O4, through a self-join on ORGANIZATION_ID.

The O3 alias is filtered by ORG_INFORMATION_CONTEXT = 'BUSINESS GROUP INFORMATION' and provides the business group flexfield segments, mapped positionally to columns such as SHORT_NAME, METHOD_OF_GENERATION_EMP_NUM, GRADE_STRUCTURE, and LEGISLATION_CODE. The O4 alias is filtered by ORG_INFORMATION_CONTEXT = 'CLASS' with ORG_INFORMATION1 = 'HR_BG' and ORG_INFORMATION2 = 'Y', restricting the result set to active business group classifications. The join is therefore a three-way equijoin on ORGANIZATION_ID, and a business group will not appear unless both the business group information context and the qualifying class row exist.

Key Columns

The exposed columns map directly to the select list of the view definition and to the business group flexfield segments. The most significant include:

• BUSINESS_GROUP_ID — the organization identifier of the business group; the primary key for practical purposes.
• NAME, SHORT_NAME, DATE_FROM, DATE_TO, INTERNAL_ADDRESS_LINE, LOCATION_ID, COMMENTS — organization-level descriptive attributes from HR_ALL_ORGANIZATION_UNITS.
• METHOD_OF_GENERATION_EMP_NUM — the business group's method for generating employee numbers, one of the configuration values most frequently queried from this view. Parallel columns exist for applicant numbers (METHOD_OF_GENERATION_APL_NUM) and contingent worker numbers (METHOD_OF_GENERATION_CWK_NUM).
• GRADE_STRUCTURE, PEOPLE_GROUP_STRUCTURE, JOB_STRUCTURE, COST_ALLOCATION_STRUCTURE, POSITION_STRUCTURE, COMPETENCE_STRUCTURE — the structure identifiers that define the business group's key flexfield and configuration context.
• LEGISLATION_CODE, CURRENCY_CODE, ENABLED_FLAG — legislative, currency, and enablement attributes.
• SECURITY_GROUP_ID — the security group associated with the row, relevant for multi-tenant and data-security filtering.

Common Use Cases and Queries

The view is typically used to resolve a business group's configuration without navigating the flexfield tables directly, to drive employee number generation audits, and to seed setup data during implementations or migrations. A representative query retrieving employee number generation methods across all business groups follows:

• SELECT business_group_id, name, short_name, method_of_generation_emp_num, method_of_generation_apl_num, method_of_generation_cwk_num FROM apps.per_business_groups_perf ORDER BY name;

To inspect structure and legislative configuration for a specific business group:

• SELECT name, grade_structure, job_structure, position_structure, cost_allocation_structure, legislation_code, currency_code, enabled_flag FROM apps.per_business_groups_perf WHERE business_group_id = :p_business_group_id;

Because the view is filtered to HR_BG classifications, it is the appropriate source whenever the question concerns business groups specifically rather than the broader set of organization units. Callers should note that the view joins organization information rows, so any business group lacking a complete BUSINESS GROUP INFORMATION or CLASS context row will be excluded from results.