Search Results pqh_copy_entity_txns

Overview

The PQH_COPY_ENTITY_TXNS table is a core data structure within the Oracle E-Business Suite Public Sector HR (PQH) module, specifically for releases 12.1.1 and 12.2.2. It functions as the master repository for batch details pertaining to mass data processes. These processes, often referred to as "Copy Entity" operations, are designed for the bulk copying or mass updating of HR-related data, such as position or grade structures, across different organizational contexts or business groups. The table serves as the central transactional header, recording each unique batch execution instance and linking it to the specific process configuration, organizational context, and resulting output.

Key Information Stored

The table's primary purpose is to define and track a mass process batch. Its key columns, as indicated by its constraints, include the surrogate primary key COPY_ENTITY_TXN_ID. The unique key constraint highlights critical business identifiers: TRANSACTION_CATEGORY_ID (linking to the type of mass process), CONTEXT_BUSINESS_GROUP_ID (identifying the target organization), and DISPLAY_NAME (the user-defined batch name). Other significant foreign key columns are TXN_CATEGORY_ATTRIBUTE_ID, which points to the specific attribute set or template used for the copy operation, and CONTEXT, which defines the operational scope or data view. The WF_TRANSACTION_CATEGORY_ID links to a workflow definition, enabling automated approval or notification processes for the batch.

Common Use Cases and Queries

This table is central to auditing, reporting, and troubleshooting mass HR data operations. A common use case involves generating a report of all mass copy batches executed within a specific business group and time period. Administrators may query this table to identify failed or in-progress processes by joining it to the related results table. A typical diagnostic query would join PQH_COPY_ENTITY_TXNS to PQH_COPY_ENTITY_RESULTS to analyze the outcome of a specific batch.

• Sample Query (Batch Summary): SELECT cet.display_name, cet.context_business_group_id, tc.name, COUNT(cer.result_code) FROM pqh_copy_entity_txns cet JOIN pqh_transaction_categories tc ON cet.transaction_category_id = tc.transaction_category_id LEFT JOIN pqh_copy_entity_results cer ON cet.copy_entity_txn_id = cer.copy_entity_txn_id WHERE cet.context_business_group_id = :p_bg_id GROUP BY cet.display_name, cet.context_business_group_id, tc.name;

Related Objects

The table maintains integral relationships with several other PQH objects, forming the backbone of the mass process architecture. It references the following tables via foreign keys:

• PQH_TRANSACTION_CATEGORIES (via TRANSACTION_CATEGORY_ID and WF_TRANSACTION_CATEGORY_ID): Defines the type of mass process.
• PQH_TXN_CATEGORY_ATTRIBUTES (via TXN_CATEGORY_ATTRIBUTE_ID): Specifies the attribute mapping template.
• PQH_COPY_ENTITY_CONTEXTS (via CONTEXT): Defines the data context for the operation.
• HR_ALL_ORGANIZATION_UNITS (via CONTEXT_BUSINESS_GROUP_ID): Identifies the target business group.

Conversely, the following tables use PQH_COPY_ENTITY_TXNS as a parent table, storing detailed data for each batch:

• PQH_COPY_ENTITY_ATTRIBS (via COPY_ENTITY_TXN_ID): Stores specific attribute-level preferences or overrides for the batch.
• PQH_COPY_ENTITY_PREFS (via COPY_ENTITY_TXN_ID): Holds user preferences for the batch execution.
• PQH_COPY_ENTITY_RESULTS (via COPY_ENTITY_TXN_ID): Contains the detailed outcome records (success, error) for each entity processed in the batch.