Search Results per_mm_valid_grades




Overview
Explore in AI Chat

Overview

The PER_MM_VALID_GRADES table is a transactional data object within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the Mass Move functionality. Its primary role is to serve as a staging and validation table during the process of moving multiple positions from one organization to another. The table defines the permissible target grades for each position involved in a mass move operation, ensuring that grade transitions comply with business rules before the move is executed. This object is integral to maintaining data integrity and enforcing organizational hierarchies during large-scale restructuring events.

Key Information Stored

The table's structure centers on three key columns that form its composite primary key. The MASS_MOVE_ID column links each record to a specific mass move transaction defined in the PER_MASS_MOVES table. The POSITION_ID identifies the individual position being moved, referencing PER_ALL_POSITIONS. The TARGET_GRADE_ID specifies the valid grade to which the position can be assigned in the target organization, referencing the PER_GRADES table. Together, these columns create a unique list of approved grade assignments for each position within a given mass move, preventing invalid or duplicate configurations.

Common Use Cases and Queries

The primary use case is the validation step within a mass move workflow. Before finalizing the move, the system references this table to confirm all designated position-grade mappings are permissible. A common reporting query would involve joining this table to related master data to review the planned moves. For example:

  • To list all valid grades for positions in a specific mass move: SELECT mmvg.position_id, pg.name target_grade FROM per_mm_valid_grades mmvg, per_grades pg WHERE mmvg.target_grade_id = pg.grade_id AND mmvg.mass_move_id = <MOVE_ID>;
  • To audit which positions have multiple valid target grades defined for a move.
  • To troubleshoot errors in the mass move process by verifying the existence of pre-defined valid grade records for a failing position.

Related Objects

PER_MM_VALID_GRADES is a central junction table with defined foreign key relationships to three core HRMS tables, as documented in the ETRM metadata.

  • PER_MASS_MOVES: The parent transaction table. Records are linked via PER_MM_VALID_GRADES.MASS_MOVE_ID = PER_MASS_MOVES.MASS_MOVE_ID.
  • PER_ALL_POSITIONS: The master table for positions. Records are linked via PER_MM_VALID_GRADES.POSITION_ID = PER_ALL_POSITIONS.POSITION_ID.
  • PER_GRADES: The master table for grades. Records are linked via PER_MM_VALID_GRADES.TARGET_GRADE_ID = PER_GRADES.GRADE_ID.

These relationships ensure referential integrity, tying the mass move's valid grade definitions directly to the core HRMS data model.