Search Results pqp_hrtca_integration




Overview
Explore in AI Chat

Overview

APPS.PQP_HRTCA_INTEGRATION is a PL/SQL integration package within the Oracle E-Business Suite HR and Trading Community Architecture (TCA) modules. Its primary business function is to synchronize address and person-related data between the Oracle Human Resources (HR) datamodel and the TCA datamodel, which underpins Oracle Receivables, Order Management, and other customer-facing applications. Within Oracle EBS 12.1.1 and 12.2.2, a single enterprise may maintain address and person records in both PER tables (HR) and HZ tables (TCA). This package provides the bridge logic that keeps those two representations consistent, handling both directions of the flow: creating or updating TCA addresses from HR sources, and creating or updating HR addresses from TCA sources. It also manages the propagation of "extra information" (descriptive flexfield) data and person analyses between the two models, and integrates with OSS (Oracle Self-Service / iRecruitment style) passport, visa, and visit history data. The package is classified as OTHER in the ETRM metadata and is currently VALID in the APPS schema.

Key Procedures and Functions

The documented interface exposes twenty-one procedures and functions, grouped broadly as follows:

Tables Accessed

The package reads and writes the following documented tables (referenced through APPS synonyms):

Usage Notes

PQP_HRTCA_INTEGRATION is not typically invoked directly by end users. It is consumed by higher-level packages including PER_ADDRESSES_PKG, PQP_ADDRESS_SYNCHRONIZATION, PQP_HROSS_INTEGRATION, PQP_HROSS_INTEGRATION_SWI, PQP_HRTCA_SYNCHRONIZATION, and PQP_PERASGADD_RIW. These callers are triggered from HR and TCA forms, concurrent synchronization programs, and address maintenance flows. The package is also listed as referencing itself, reflecting internal procedure reuse. In 12.1.1 and 12.2.2 the same integration concerns apply, though 12.2.x introduces additional TCA and party model enhancements; the package continues to serve as the HR-to-TCA and TCA-to-HR adapter for address, extra information, and OSS identity document data. Customizations should call the documented procedures rather than performing direct DML against the underlying PER and HZ tables, because the package enforces flexfield validation and installation checks through the FND tables it references.