Search Results ghr_mre_pkg




Overview
Explore in AI Chat

Overview

The concurrent program SUBMIT_MASS_REALIGNMENT (user-facing name: Process Mass Realignment) belongs to the Oracle E-Business Suite product GHR — US Federal Human Resources. It is documented and enabled in ETRM for release 12.2.2, with equivalent behavior in 12.1.1. Its business purpose is to initiate the Mass Realignment Process, a federal HR utility used to restructure a group of positions, organizations, or employees in a single administrative action rather than through individual transaction entries. Mass realignment is typically applied when an agency reorganizes reporting lines, redistributes supervisory assignments, or shifts a population of employees between organizational units while preserving position and grade integrity. The program is the batch entry point that drives the realignment engine; it processes the realignment criteria and applies the resulting updates across the affected HR records.

Execution Details

The ETRM metadata records the following execution characteristics:

  • Execution Method: PL/SQL Stored Procedure
  • Argument Method: Standard
  • Executable: GHR_MRE_PKG
  • Execution Filename: ghr_mre_pkg.execute_mre
  • User Name (Executable): GHR_MRE_PKG — "Start Mass Realignment"
  • Subroutine Name: Not specified
  • Enabled: Yes

The program therefore invokes the packaged procedure ghr_mre_pkg.execute_mre at run time. Because the execution method is a stored procedure rather than a host-language executable, submission occurs within the database session and no external program or shell script is involved. The subroutine argument is passed using the standard argument method, meaning parameters are supplied through the concurrent program's defined argument list rather than by token substitution in an execution string.

How to Run

Users submit the program through the standard Submit Request (SRS) window, selecting "Process Mass Realignment" from the list of available concurrent programs. Administrators can also schedule it through the Concurrent Programs and Requests forms or submit it programmatically via FND_REQUEST.SUBMIT_REQUEST, supplying the executable short name and argument values. Because the argument method is Standard, parameters defined against the concurrent program are passed positionally to ghr_mre_pkg.execute_mre.

Practical guidance includes verifying that the realignment data has been staged and validated before submission, confirming that the requesting user holds the appropriate HR security and responsibility, and retaining the concurrent request ID for audit and reconciliation. Federal HR processing frequently requires the request to run during a controlled window to avoid conflicting personnel actions. If the request terminates in error, the concurrent manager log and the package's error handling output should be reviewed; the program returns status through the standard completion codes.

Related Objects

The program is closely associated with the following GHR / Oracle HRMS objects:

  • GHR_MRE_PKG — the executable package containing execute_mre.
  • Mass realignment staging and interface tables used to hold the pending realignment criteria prior to processing.
  • The GHR Mass Realignment setup and validation forms used to define and preview the realignment population.
  • Standard HRMS concurrent programs such as the Mass Update and organizational hierarchy processes, which share the same batch-processing framework.
  • Concurrent manager and request log tables (FND_CONCURRENT_REQUESTS, FND_CONCURRENT_PROGRAMS) for submission and monitoring.

Users searching for ghr_mre_pkg should understand that this package is the implementation behind the SUBMIT_MASS_REALIGNMENT concurrent program and that its execute_mre entry point is the documented target of the request.