Search Results context_business_group_id




Overview
Explore in AI Chat

Overview

The HR.PQH_COPY_ENTITY_TXNS table is a core transactional data store within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle HRMS (Human Resources Management System) module. It functions as the master table for batch or mass data copy processes, often related to the management of position hierarchies, element entries, or other HR entities. The table stores metadata and control information for each distinct copy operation, acting as a parent record for detailed attribute preferences, results, and audit trails. Its design supports multi-organization security through the CONTEXT_BUSINESS_GROUP_ID, ensuring data isolation and process execution within the correct business group context.

Key Information Stored

The table's columns capture the essential parameters and status of a copy transaction. The primary identifier is COPY_ENTITY_TXN_ID, a system-generated sequence number. Key transactional metadata includes the TRANSACTION_CATEGORY_ID, which defines the type of HR data being copied (e.g., positions, grades), and the ACTION_DATE, which serves as the transaction's effective date. The CONTEXT and CONTEXT_BUSINESS_GROUP_ID columns work in tandem to define the security and operational scope of the batch process. The DISPLAY_NAME provides a user-defined label for the batch. Operational columns like REPLACEMENT_TYPE_CD and START_WITH control how source data is transformed during the copy, such as applying prefixes or suffixes to copied records. The SRC_EFFECTIVE_DATE indicates the point-in-time from which source data is queried.

Common Use Cases and Queries

This table is central to batch operations where HR configurations are replicated or mass-updated. A primary use case is copying position hierarchies from one business group or department to another, or replicating element link setups. Administrators often query this table to monitor batch process history or troubleshoot errors. A typical query to find all copy transactions for a specific business group and transaction category would be:

  • SELECT display_name, action_date, created_by FROM hr.pqh_copy_entity_txns WHERE context_business_group_id = &business_group_id AND transaction_category_id = &txn_cat_id ORDER BY action_date DESC;

For reporting, this table is frequently joined with its child tables (PQH_COPY_ENTITY_RESULTS, PQH_COPY_ENTITY_ATTRIBS) to generate detailed audit reports on the success, failure, and specific changes made by each batch job. The presence of the WF_TRANSACTION_CATEGORY_ID suggests integration with Oracle Workflow for process orchestration and notifications.

Related Objects

The HR.PQH_COPY_ENTITY_TXNS table maintains defined relationships with several key HRMS objects, as documented in the ETRM metadata. As a parent table, it is referenced by the following child tables via the COPY_ENTITY_TXN_ID foreign key:

  • PQH_COPY_ENTITY_ATTRIBS: Stores specific attribute-level preferences for the copy transaction.
  • PQH_COPY_ENTITY_PREFS: Holds user preferences for the copy operation.
  • PQH_COPY_ENTITY_RESULTS: Logs the detailed outcome and any errors for each record processed in the batch.

As a child table, it references these master and setup tables: