Search Results per_information1




Overview
Explore in AI Chat

Overview

GHR_MT_PEOPLE_F_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the GHR product family, US Federal Human Resources, and is documented with a status of VALID. The view exists specifically to support the Mass Transfer in and out processes, which perform data transfer operations for person and assignment records. In this role the view acts as a staging or mapping layer that normalises records held in the GHR interface so that the mass transfer routines can read, validate, and move employee and applicant data consistently across business groups.

From a reporting and integration perspective, the view is not a general-purpose HR reporting source. It exposes the contents of the GHR interface table in a column-aliased, positional format that the mass transfer concurrent programs expect. Developers and technical consultants examining the object usually encounter it when diagnosing mass transfer errors, tracing interface rows, or extending the federal HR data movement logic.

Underlying Base Objects

The documented base object referenced by the view is GHR_INTERFACE, accessed through a synonym. The view statement selects from this interface table and renames the generic INFORMATION columns into descriptive aliases such as MT_NAME, MT_PERSON_ID, PERSON_ID, and FAST_PATH_EMPLOYEE. This renaming is the principal function of the view: it converts the flexible, position-based structure of GHR_INTERFACE into a stable, semantically labelled interface for the mass transfer in and out programs.

The leading column, INTERFACE_ID, is aliased as GHR_INTERFACE_ID and provides the primary linkage back to the interface row. SOURCE_NAME and PROCESS_DATE identify the originating process and the run date of the transfer.

Key Columns

Common Use Cases and Queries

The primary use case is troubleshooting and inspection of mass transfer interface rows. A typical query retrieves the mapped descriptive columns for a given interface run:

  • SELECT GHR_INTERFACE_ID, MT_PROCESS_DATE, MT_SOURCE, MT_PERSON_ID, PERSON_ID, BUSINESS_GROUP_ID, FAST_PATH_EMPLOYEE FROM APPS.GHR_MT_PEOPLE_F_V WHERE MT_PROCESS_DATE = :run_date;
  • SELECT GHR_INTERFACE_ID, PERSON_ID, EMPLOYEE_NUMBER, LAST_NAME, CURRENT_EMPLOYEE_FLAG FROM APPS.GHR_MT_PEOPLE_F_V WHERE PERSON_ID = :person_id;
  • SELECT COUNT(*) FROM APPS.GHR_MT_PEOPLE_F_V WHERE MT_INTER_BG_TRANSFER = 'Y';

These queries are commonly used to confirm that rows staged for a mass transfer carry the expected person identifiers, business group, and FastPath Employee flag before the in or out process is executed.