Search Results irc_global_remap_pkg




Overview
Explore in AI Chat

Overview

IRC_GLOBAL_REMAP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the iRecruitment (IRC) module's person and party data management. Its name reflects its core function: the global remapping of employee-related records across the Human Capital Management (HCM) data model. In the iRecruitment context, person records are created and maintained through the TCA (Trading Community Architecture) party model, with person identifiers (party_id, person_id) needing to remain synchronized across multiple dependent tables. The package addresses scenarios where an employee record must be reassigned or re-pointed to a different party or person identifier, propagating that change consistently across the associated HCM tables.

The package is classified as status VALID in the ETRM registry and depends on the SYS.STANDARD package, with no external library dependencies beyond standard PL/SQL constructs. This indicates a self-contained utility package rather than one built atop Oracle-provided HCM APIs.

Key Procedures and Functions

The documented interface exposes two callable units total. The principal documented procedure is REMAP_EMPLOYEE.

  • REMAP_EMPLOYEE — Orchestrates the remapping of an employee's person and party associations across the dependent HCM tables. When an employee's underlying party identifier changes (for example, following a merge, duplicate resolution, or data migration), the procedure updates or re-points the corresponding rows in the address, phone, person, qualification, previous employer, and establishment attendance records so that the employee's history remains intact and queryable under the new identifier.
  • Second documented unit — The metadata records two procedures/functions in total, with REMAP_EMPLOYEE being the named entry point. The remaining unit is an internal helper used during the remapping process. No parameter lists are documented, and none are inferred here.

Tables Accessed

The package reads and writes the following tables through APPS synonyms, all native to the Oracle HRMS person model:

  • PER_ALL_PEOPLE_F — the effective-dated master employee record, which anchors the person_id used throughout the remap.
  • PER_ADDRESSES — employee address records that must follow the remapped person identifier.
  • PER_PHONES — employee telephone records associated with the person being remapped.
  • PER_QUALIFICATIONS — recorded qualifications and credentials tied to the employee.
  • PER_PREVIOUS_EMPLOYERS — prior employment history captured for the employee.
  • PER_ESTABLISHMENT_ATTENDANCES — attendance records linked to the establishment and person.

Collectively these tables represent the full breadth of person-level descriptive data maintained by HRMS, confirming that REMAP_EMPLOYEE performs a coordinated update rather than a single-table change.

Usage Notes

IRC_GLOBAL_REMAP_PKG is referenced by one other package, IRC_PARTY_PERSON_UTL, which is the utility layer used by iRecruitment for party and person handling. This dependency confirms that the package is invoked from within the iRecruitment recruitment infrastructure rather than directly by end users. Typical invocation paths include iRecruitment concurrent programs, data-fix scripts, and custom remediation code executed during implementation or upgrade of Oracle EBS 12.1.1 and 12.2.2. Direct invocation is generally reserved for DBAs and technical consultants performing controlled employee-data remapping, since the procedure modifies effective-dated HRMS records across six related tables and must be run within a transaction whose consistency is verified before commit.