Search Results pqh_copy_entity_contexts_uk




Overview
Explore in AI Chat

Overview

The HR.PQH_COPY_ENTITY_CONTEXTS table is a core configuration table within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically for versions 12.1.1 and 12.2.2. It functions as a master reference for defining unique operational contexts within the system's data copy or migration framework. The table's primary role is to establish and enforce a specific combination of application, legislation, and responsibility that defines a valid environment for executing entity copy transactions. This ensures that data replication processes are correctly scoped and secured according to the organization's multi-org and legislative structure.

Key Information Stored

The table stores context-defining parameters alongside standard audit columns. The most critical columns are those comprising its unique and primary keys, which enforce data integrity rules. The primary key is the CONTEXT column, a 27-character identifier for the context record. The unique key, PQH_COPY_ENTITY_CONTEXTS_UK, is a composite key on APPLICATION_SHORT_NAME, LEGISLATION_CODE, and RESPONSIBILITY_KEY. This structure guarantees that no duplicate context is defined for the same combination of application, legal jurisdiction, and user responsibility. The TRANSACTION_SHORT_NAME column identifies the specific transaction or process within the defined context. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and OBJECT_VERSION_NUMBER for optimistic locking support complete the record.

Common Use Cases and Queries

This table is primarily accessed during the setup and execution of data copy processes, such as copying position or grade structures across business groups or legislative boundaries. Administrators query it to verify existing context configurations or to troubleshoot copy process failures. A common diagnostic query is to list all configured contexts with their full definition:

  • SELECT context, application_short_name, legislation_code, responsibility_key, transaction_short_name FROM hr.pqh_copy_entity_contexts ORDER BY 1;

Another frequent use case is validating the uniqueness of a new context combination before insertion, leveraging the PQH_COPY_ENTITY_CONTEXTS_UK constraint. The table is also central to reports auditing the setup of the copy framework, often joined with related transaction and function tables to provide a complete mapping of enabled processes.

Related Objects

HR.PQH_COPY_ENTITY_CONTEXTS serves as a parent table to several key entities in the copy framework, as defined by its foreign key relationships. The CONTEXT column is referenced as a foreign key in the following tables:

  • PQH_COPY_ENTITY_FUNCTIONS: Links context to the specific copy functions or operations that are permitted within it (Join Column: CONTEXT).
  • PQH_COPY_ENTITY_TXNS: Associates context with the detailed transaction definitions that can be executed (Join Column: CONTEXT).
  • PQH_SPECIAL_ATTRIBUTES: Ties context to any special attribute rules or overrides that apply during the copy process (Join Column: CONTEXT).

These relationships indicate that the context defined in PQH_COPY_ENTITY_CONTEXTS acts as a controlling node for a hierarchy of configuration data governing the entity copy functionality.