Search Results apps_ts_interface




Overview
Explore in AI Chat

Overview

The HR.GHR_MASS_REALIGNMENT table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the U.S. Federal Human Resources (GHR) module. It serves as the primary repository for defining and storing mass realignment criteria and target information. A mass realignment is a bulk operation used to transfer multiple employees or positions from one organizational unit to another, a critical function for managing large-scale reorganizations. The table's storage in the APPS_TS_INTERFACE tablespace indicates its role as a staging or processing area for transactional data before final application to core HR tables, aligning with the user's search context.

Key Information Stored

The table's structure is designed to capture the parameters of a realignment exercise. The primary identifier, MASS_REALIGNMENT_ID, is a system-generated sequence number. A unique NAME column allows for identification of each realignment set. The table stores key identifiers for the source (OLD_ORGANIZATION_ID, OLD_ORG_STRUCTURE_VERSION_ID, OLD_POS_STRUCTURE_VERSION_ID) and destination (NEW_ORGANIZATION_ID, TARGET_POSITION_ORG_ID) organizational contexts. It also links to personnel offices (PERSONNEL_OFFICE_ID, TARGET_PERSONNEL_OFFICE_ID) and integrates with the Personnel Action (PA) request process via the PA_REQUEST_ID foreign key to GHR_PA_REQUESTS. Metadata such as EFFECTIVE_DATE (inferred from column list) would govern when the realignment is applied.

Common Use Cases and Queries

This table is central to executing and auditing organizational restructuring. Administrators use it to define criteria for moving employees en masse during department mergers, splits, or re-organizations. Common reporting and validation SQL includes identifying pending realignments or verifying setup before submission. A typical query might join to organization tables to translate IDs into names:

  • SELECT mr.NAME, hou_old.NAME OLD_ORG, hou_new.NAME NEW_ORG FROM hr.ghr_mass_realignment mr, hr_all_organization_units hou_old, hr_all_organization_units hou_new WHERE mr.old_organization_id = hou_old.organization_id AND mr.new_organization_id = hou_new.organization_id;

Another critical use case involves tracing the status of a realignment by joining to GHR_PA_REQUESTS via PA_REQUEST_ID to check the associated request's approval stage.

Related Objects

The foreign key constraints explicitly document this table's integration within the EBS schema. Key related objects include:

  • GHR_PA_REQUESTS: Linked via PA_REQUEST_ID. This ties the mass realignment to the formal personnel action request workflow.
  • HR_ALL_ORGANIZATION_UNITS: Linked three times for OLD_ORGANIZATION_ID, NEW_ORGANIZATION_ID, and TARGET_POSITION_ORG_ID. This provides the descriptive names and attributes for the source and target organizations.
  • PER_ORG_STRUCTURE_VERSIONS: Linked via OLD_ORG_STRUCTURE_VERSION_ID, ensuring the realignment is executed within the correct historical version of the organization hierarchy.

These relationships ensure referential integrity and enable comprehensive reporting by joining to these master data tables.