Search Results mass_transfer_id

Overview

The GHR_MASS_TRANSFERS table is a core data object within the US Federal Human Resources (GHR) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the master definition table for a mass transfer action, a specialized process used by US federal agencies to move multiple employees between organizational units, positions, or personnel systems in a single, controlled transaction. The table stores the foundational administrative and structural criteria that define the scope and parameters of the transfer, serving as the parent record to which detailed selection criteria are linked. Its existence is critical for supporting the complex organizational restructuring and workforce realignment requirements mandated in the federal sector.

Key Information Stored

The table's primary purpose is to define the "what" and "where" of a mass transfer. Key columns include the surrogate primary key, MASS_TRANSFER_ID, and a unique combination of NAME and TRANSFER_TYPE to ensure business rule integrity. It holds identifiers for the source organization (OLD_ORGANIZATION_ID), its associated structure versions (OLD_ORG_STRUCTURE_VERSION_ID, OLD_POS_STRUCTURE_VERSION_ID), and the target personnel office (PERSONNEL_OFFICE_ID). A critical link is established via the PA_REQUEST_ID foreign key to the GHR_PA_REQUESTS table, formally associating the mass transfer with a Personnel Action (PA) request, which is the central workflow object governing all personnel actions in GHR.

Common Use Cases and Queries

This table is primarily accessed during the execution and audit of mass transfer processes. Common operational scenarios include generating a list of all defined mass transfers for review, identifying transfers linked to a specific personnel action request, or querying transfers originating from a particular organization. A typical reporting query would join this table to related entities to provide a comprehensive view.

• Sample Query: Retrieving basic transfer information with related PA request details.
  SELECT gmt.NAME, gmt.TRANSFER_TYPE, gpr.PA_REQUEST_NUMBER
FROM HR.GHR_MASS_TRANSFERS gmt
JOIN HR.GHR_PA_REQUESTS gpr ON gmt.PA_REQUEST_ID = gpr.PA_REQUEST_ID
WHERE gmt.OLD_ORGANIZATION_ID = :org_id;
• Administrative Use Case: System administrators or HR specialists use this data to monitor pending mass actions, troubleshoot errors in the transfer setup, and ensure all structural prerequisites (organization versions) are correctly defined before execution.

Related Objects

The GHR_MASS_TRANSFERS table sits at the center of a defined object hierarchy. It is a child of the GHR_PA_REQUESTS table, inheriting its workflow status and approval path. It is also a parent table, with the GHR_MASS_TRANSFER_CRITERIA table storing the detailed employee selection rules (e.g., job, grade, location) that depend on its MASS_TRANSFER_ID. Furthermore, it maintains referential integrity with foundational HRMS structures through foreign keys to HR_ALL_ORGANIZATION_UNITS, PER_ORG_STRUCTURE_VERSIONS, and PER_POS_STRUCTURE_VERSIONS, ensuring transfers are built upon valid organizational snapshots.