Search Results per_job_groups_uk1




Overview
Explore in AI Chat

Overview

The HR.PER_JOB_GROUPS table is a core reference data table within the Oracle E-Business Suite Human Capital Management (HCM) module, specifically for Oracle HRMS in releases 12.1.1 and 12.2.2. It serves as a master container for logically grouping job definitions, which are stored in the PER_JOBS table. Its primary role is to enforce data segregation and control the visibility and usage of jobs across the application. A critical function of this table is to define a mandatory 'Default HR Job Group' for each business group, which houses all jobs used within the HRMS system. Furthermore, it supports the creation of global job groups that can be shared across business groups when the relevant cross-business group profile option is enabled, facilitating enterprise-wide job standardization.

Key Information Stored

The table's structure is designed to manage job group metadata and its organizational context. The primary identifier is the system-generated JOB_GROUP_ID. The BUSINESS_GROUP_ID column links the group to a specific business group or is NULL for a global group. The LEGISLATION_CODE ties the group to a specific legislative environment for compliance. For application logic, the INTERNAL_NAME is a unique, non-updatable identifier used by the system, while the DISPLAYED_NAME is the user-facing, updatable label. Finally, the ID_FLEX_NUM column determines which key flexfield structure is used for jobs created within this group, linking to the underlying job definition framework (PER_JOB_DEFINITIONS).

Common Use Cases and Queries

A primary use case is identifying all job groups available within a specific business group or globally for reporting or data validation. Technical implementations often involve joining to PER_JOBS to list all jobs within a particular group. Administrators may query this table to verify the existence of the default HR job group. Common SQL patterns include finding job groups by name or business group, and listing jobs with their group context.

  • Find all job groups for business group 123: SELECT * FROM hr.per_job_groups WHERE business_group_id = 123;
  • List all jobs with their associated group display name: SELECT j.name, g.displayed_name FROM hr.per_jobs j, hr.per_job_groups g WHERE j.job_group_id = g.job_group_id;
  • Identify global job groups (cross-business group): SELECT * FROM hr.per_job_groups WHERE business_group_id IS NULL;

Related Objects

PER_JOB_GROUPS is central to the HCM job architecture, with defined relationships to several key tables. The primary key constraint PER_JOB_GROUPS_PK on JOB_GROUP_ID is referenced by foreign keys in child tables. Crucially, the PER_JOBS table links via JOB_GROUP_ID, making every job a member of a single job group. The PER_ROLES table also references this key for role definitions. For organizational context, a foreign key constraint (PER_JOB_GROUPS_FK1) links BUSINESS_GROUP_ID to HR_ALL_ORGANIZATION_UNITS. The unique key PER_JOB_GROUPS_UK1 on the combination of INTERNAL_NAME and BUSINESS_GROUP_ID ensures naming uniqueness within a business group context.