Search Results per_mass_moves




Overview
Explore in AI Chat

Overview

The PER_MASS_MOVES table is a core data structure within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master definition table for a "mass move" operation. A mass move is a high-level administrative process used to transfer multiple employees, positions, or jobs from one organizational unit to another in a single, coordinated transaction. This table stores the top-level metadata and control parameters for such an operation, acting as the parent record for all associated details. Its existence is critical for managing large-scale organizational restructures, departmental consolidations, or business unit realignments efficiently within the system.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships reveal its essential structure. The table's primary key is MASS_MOVE_ID, a unique identifier for each mass move definition. A critical foreign key is BUSINESS_GROUP_ID, which links to HR_ALL_ORGANIZATION_UNITS. This enforces that every mass move is scoped to a specific business group, a fundamental security and data partitioning concept in Oracle HRMS. Other columns, inferred from its purpose, would typically store information such as the move's name, description, status (e.g., 'ENTERED', 'PROCESSED', 'CANCELLED'), effective date, source and destination organization units, and the user who initiated the request.

Common Use Cases and Queries

The primary use case is the execution and audit of bulk organizational changes. Administrators use the Mass Move functionality via the Oracle HRMS application interface to define and run these operations. From a reporting and technical perspective, common queries involve tracking the history and status of mass moves. A sample SQL pattern to retrieve basic move information might be:

  • SELECT mass_move_id, name, effective_date, status FROM hr.per_mass_moves WHERE business_group_id = :p_bg_id AND status = 'PROCESSED' ORDER BY effective_date DESC;

Technical consultants may also query this table to diagnose data issues or validate the success of a move by joining it to its child detail tables to see the count of assignments or positions affected.

Related Objects

As documented in the foreign key relationships, PER_MASS_MOVES is the central parent table for several detail tables that store the specific elements being moved. These relationships are:

  • PER_MM_ASSIGNMENTS: Links via MASS_MOVE_ID. This table holds the individual employee assignments included in the mass move.
  • PER_MM_POSITIONS: Links via MASS_MOVE_ID. This table stores the positions that are part of the move operation.
  • PER_MM_JOB_REQUIREMENTS: Links via MASS_MOVE_ID. This table contains job requirement records associated with the move.
  • PER_MM_VALID_GRADES: Links via MASS_MOVE_ID. This table manages valid grade information relevant to the move context.

Furthermore, the table references HR_ALL_ORGANIZATION_UNITS via the BUSINESS_GROUP_ID column, anchoring the mass move within the organizational hierarchy.