Search Results per_job_groups

Overview

The PER_JOB_GROUPS table is a core data structure within the Oracle E-Business Suite Human Resources (PER) module, versions 12.1.1 and 12.2.2. It functions as the master repository for job group definitions. A job group is a logical classification mechanism used to aggregate related jobs, facilitating streamlined administration, reporting, and the application of common policies or rules across multiple job roles. Each job defined in the system (via the PER_JOBS table) must be associated with a single job group, establishing a mandatory hierarchical relationship. Furthermore, job groups can be optionally linked to a specific business group, allowing for enterprise-wide or business-group-specific groupings as required by the organization's operational model.

Key Information Stored

The table's primary identifier is the JOB_GROUP_ID (Primary Key: PER_JOB_GROUPS_PK). Each record is also uniquely identified by the combination of INTERNAL_NAME and BUSINESS_GROUP_ID (Unique Key: PER_JOB_GROUPS_UK1), ensuring name uniqueness within a business group context. The BUSINESS_GROUP_ID is a foreign key to HR_ALL_ORGANIZATION_UNITS, linking the job group to its controlling organizational entity. While the provided metadata specifies these core columns, typical implementations of this table would also include standard descriptive columns such as NAME, DESCRIPTION, and audit columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY.

Common Use Cases and Queries

Job groups are pivotal for configuring and reporting across HR and integrated financials. A primary use case is enforcing approval policies; the AP_POL_HEADERS table references a job group to define which approvers are valid for transactions initiated by holders of jobs within that group. In Oracle Projects, job groups are used to define billing and costing rules (via PA_PROJECTS_ALL and PA_PROJECT_TYPES_ALL) and for forecasting resource assignments. Common reporting queries involve listing all jobs within a specific group or identifying which policies and project setups reference a particular job group. A foundational query to retrieve job group details with associated jobs would be:

• SELECT pjg.internal_name, pjg.business_group_id, pj.name AS job_name FROM per_job_groups pjg, per_jobs pj WHERE pjg.job_group_id = pj.job_group_id ORDER BY pjg.internal_name, pj.name;

Related Objects

PER_JOB_GROUPS is a central reference point for numerous objects across the E-Business Suite. As documented, its primary relationship is with the PER_JOBS table, where each job is a member of a group. It is also referenced by PER_ROLES. Crucially, the table has significant integration points with the Oracle Payables (AP) and Projects (PA) modules. In AP, it links to approval policy headers (AP_POL_HEADERS). In Projects, it is referenced by project definitions (PA_PROJECTS_ALL for billing and costing groups), project assignments (PA_PROJECT_ASSIGNMENTS for forecasting), project types (PA_PROJECT_TYPES_ALL), resource breakdown structures (PA_RBS_VERSIONS_B), and resource lists (PA_RESOURCE_LISTS_ALL_BG). This extensive integration underscores its role in enforcing consistent HR-driven rules within financial and project management processes.