Search Results per_career_paths




Overview
Explore in AI Chat

Overview

The PER_CAREER_PATHS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module. It serves as the master repository for defining and storing career path structures within an organization. A career path represents a predefined sequence or hierarchy of jobs that outlines potential progression routes for employees, facilitating succession planning and career development. This table is fundamental for configuring and managing these organizational frameworks, which are integral to talent management processes in Oracle EBS versions 12.1.1 and 12.2.2.

Key Information Stored

The table stores the essential metadata for each unique career path definition. Its primary columns, as indicated by the provided metadata, include the CAREER_PATH_ID, which is the unique system-generated identifier and primary key. The NAME column holds the descriptive title of the career path. Crucially, each record is scoped to a specific BUSINESS_GROUP_ID, which links the career path to a particular operating company or division within the multi-organization architecture of Oracle HRMS. This business group context is enforced by a foreign key relationship to the HR_ALL_ORGANIZATION_UNITS table and a unique key constraint (PER_CAREER_PATHS_UK2) on the combination of NAME and BUSINESS_GROUP_ID, ensuring path names are unique within a business group.

Common Use Cases and Queries

This table is primarily accessed for administrative setup, reporting, and integration. Common scenarios include generating a list of all career paths within a business group for review or maintenance, and identifying the specific jobs that constitute a career path by joining to related tables. A typical query would retrieve the foundational path information.

  • Listing Career Paths by Business Group: SELECT CAREER_PATH_ID, NAME FROM HR.PER_CAREER_PATHS WHERE BUSINESS_GROUP_ID = &BUSINESS_GROUP_ID ORDER BY NAME;
  • Identifying Paths for a Specific Job: Career path structure details are stored in the PER_CAREER_PATH_ELEMENTS table. To find all paths containing a specific job, one would join PER_CAREER_PATHS to PER_CAREER_PATH_ELEMENTS on CAREER_PATH_ID and filter by the JOB_ID.

Related Objects

The PER_CAREER_PATHS table has defined relationships with several other key HR objects, forming the backbone of the career path functionality.

  • HR_ALL_ORGANIZATION_UNITS: A foreign key from PER_CAREER_PATHS.BUSINESS_GROUP_ID to this table establishes the business group context for the career path.
  • PER_CAREER_PATH_ELEMENTS: This is the primary child table. A foreign key from PER_CAREER_PATH_ELEMENTS.CAREER_PATH_ID to PER_CAREER_PATHS.CAREER_PATH_ID links the path definition to its constituent job elements, sequences, and levels, defining the actual structure of the career progression.