Search Results pqh_copy_entity_contexts_pk

Overview

The PQH_COPY_ENTITY_CONTEXTS table is a core configuration table within the Oracle E-Business Suite Public Sector HR (PQH) module. It functions as a master repository for defining distinct contexts that control the behavior and visibility of data copying and transaction processing features. These contexts are dynamically adjusted based on the user's application environment, legislation, and responsibility, enabling a highly configurable and multi-tenant system architecture. The table's primary role is to serve as a parent entity, providing a unique context identifier that is referenced by numerous child entities governing specific functions, transactions, and special attributes within the copy entity framework.

Key Information Stored

The table's structure is designed to uniquely identify a runtime context through a combination of key columns. The primary identifier is the CONTEXT column, which is the sole component of the primary key (PQH_COPY_ENTITY_CONTEXTS_PK). For business rule enforcement, a unique key constraint (PQH_COPY_ENTITY_CONTEXTS_UK) is defined on three critical columns: APPLICATION_SHORT_NAME, LEGISLATION_CODE, and RESPONSIBILITY_KEY. This combination ensures that context definitions are scoped appropriately for a specific application module (e.g., HRMS), a legal jurisdiction, and a user's responsibility or role, thereby facilitating precise control over which copying rules and attributes are applicable in any given session.

Common Use Cases and Queries

A primary use case involves system administrators querying and maintaining context definitions to support implementation across different legislations or to troubleshoot user access issues. For instance, identifying all contexts available for a specific HR responsibility in the US legislation is a common administrative task. Sample SQL to retrieve this information would leverage the unique key columns:

• SELECT context, application_short_name, responsibility_key FROM hr.pqh_copy_entity_contexts WHERE legislation_code = 'US';

Furthermore, the CONTEXT value is frequently used as a foreign key in join operations to retrieve the specific functions or transaction definitions tied to a particular user environment. In reporting scenarios, analysts may join this table to its child entities to understand the full suite of copying rules enabled for a given operational context.

Related Objects

The PQH_COPY_ENTITY_CONTEXTS table is a central parent table with several critical dependencies, as documented by its foreign key relationships. The CONTEXT column is referenced as a foreign key in the following tables:

• PQH_COPY_ENTITY_FUNCTIONS: Links via the CONTEXT column to define the specific copying functions available within a given context.
• PQH_COPY_ENTITY_TXNS: Links via the CONTEXT column to associate data transaction rules with a specific context.
• PQH_SPECIAL_ATTRIBUTES: Links via the CONTEXT column to manage special attribute mappings that are context-sensitive.

These relationships establish that PQH_COPY_ENTITY_CONTEXTS provides the controlling context key for a significant portion of the Public Sector HR data copying configuration.