Search Results hr_pump_batch_line_user_keys

Overview

The HR_PUMP_BATCH_LINE_USER_KEYS table is a core data structure within the Oracle E-Business Suite Human Resources (PER) module, specifically designed to support the HRI (Human Resources Intelligence) Data Pump and other batch data loading processes. Its primary role is to store and manage user-defined key values that uniquely identify entities, such as assignments or persons, during their creation or update via batch interfaces. This table acts as a critical linkage point, enabling the system to correlate incoming batch data with the correct database records by maintaining a mapping between user-supplied identifiers and the system-generated internal keys.

Key Information Stored

The table's central purpose is to persist user key information. While the full column list is not detailed in the provided metadata, its structure is defined by its relationships and purpose. The primary key column, USER_KEY_VALUE, holds the unique identifier supplied by the user in the batch data. A crucial foreign key column, BATCH_LINE_ID, links each user key record directly to a corresponding entry in the HR_PUMP_BATCH_LINES table. This relationship ties the user key to the specific line of batch data from which it originated. Additional columns likely store metadata such as the entity type being referenced (e.g., 'ASSIGNMENT', 'PERSON'), the associated batch process identifier, and timestamps for creation.

Common Use Cases and Queries

This table is predominantly used in scenarios involving the batch loading of HR data, such as mass hires or data migrations via the HRI Data Pump. A common operational query involves tracing a batch load issue by finding the system-generated ID for a record created with a known user key. For example:

• Troubleshooting Batch Loads: SELECT bl.* FROM hr_pump_batch_lines bl, hr_pump_batch_line_user_keys uk WHERE uk.user_key_value = '&USER_KEY' AND uk.batch_line_id = bl.batch_line_id;
• Data Validation Reporting: Generating reports to reconcile counts between user keys submitted in a batch file and the entities successfully created in the system, often joining to HR_PUMP_BATCH_HEADERS for context.
• Integration Support: Serving as a lookup reference for downstream integrations that rely on the original user-supplied keys to identify newly created records, rather than internal surrogate keys.

Related Objects

The HR_PUMP_BATCH_LINE_USER_KEYS table exists within a tightly coupled schema for batch processing. Its most direct dependency is the HR_PUMP_BATCH_LINES table, to which it is linked via the foreign key on BATCH_LINE_ID. This places it within the broader hierarchy of batch interface tables, which typically includes HR_PUMP_BATCH_HEADERS. The table is integral to the functioning of the underlying HRI Data Pump APIs and packages, which manage the population and consumption of this data. It is not typically a table for direct transactional reporting but is essential for auditing and diagnosing the batch data load processes in Oracle EBS HRMS.