Search Results hr_pump_batch_lines

Overview

The HR_PUMP_BATCH_LINES table is a core technical table within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the HR Data Pump (HRI/HRDP) framework in releases 12.1.1 and 12.2.2. It functions as the execution queue for data loading and migration processes. Each row in this table encapsulates the complete set of information required to make a single, discrete API call to the HRMS application programming interfaces. Its primary role is to stage inbound data, manage the sequence of API executions, and store the output parameter values returned by those APIs after processing, thereby enabling batch-oriented, auditable data integration.

Key Information Stored

Each record in HR_PUMP_BATCH_LINES represents a pending or completed API transaction. The table's structure is designed to hold both input parameters for the API call and the results from its execution. The critical identifier is the BATCH_LINE_ID, which serves as the table's primary key. The BATCH_ID column links the line to its parent batch container in the HR_PUMP_BATCH_HEADERS table, grouping related transactions. The API_MODULE_ID column is a foreign key to HR_API_MODULES, defining precisely which HRMS API procedure is to be invoked (e.g., for creating a person or an assignment). Other significant columns, implied by its function, would store the actual data payload for the API parameters and the returned OUT parameter values, status flags, and error messages post-execution.

Common Use Cases and Queries

This table is central to HR Data Pump operations, such as bulk loading employee records, assignments, or salary information from legacy systems or external files. Administrators commonly query it to monitor the status and troubleshoot errors in data load batches. A typical diagnostic query would join to batch headers and API modules to identify failed lines.

• Monitoring Batch Status: SELECT h.batch_name, l.batch_line_id, l.status, l.error_message FROM hr_pump_batch_lines l, hr_pump_batch_headers h WHERE l.batch_id = h.batch_id AND h.batch_name = '&BATCH_NAME';
• Investigating API Errors: SELECT l.*, m.module_name FROM hr_pump_batch_lines l, hr_api_modules m WHERE l.api_module_id = m.api_module_id AND l.status = 'ERROR' ORDER BY l.batch_id, l.batch_line_id;
• Data Audit Reporting: Generating reports on the volume and success rate of data loads over time by joining batch lines to headers and filtering on creation dates.

Related Objects

The HR_PUMP_BATCH_LINES table is a central node in the HR Data Pump schema, with defined relationships to several key supporting tables.

• Parent Reference (HR_PUMP_BATCH_HEADERS): Linked via HR_PUMP_BATCH_LINES.BATCH_ID = HR_PUMP_BATCH_HEADERS.BATCH_ID. This relationship groups individual API calls into a logical batch job.
• Parent Reference (HR_API_MODULES): Linked via HR_PUMP_BATCH_LINES.API_MODULE_ID = HR_API_MODULES.API_MODULE_ID. This defines the specific HRMS API procedure to be executed for the line.
• Child Reference (HR_PUMP_BATCH_LINE_USER_KEYS): Linked via HR_PUMP_BATCH_LINE_USER_KEYS.BATCH_LINE_ID = HR_PUMP_BATCH_LINES.BATCH_LINE_ID. This table stores user-defined unique identifiers for the batch line, facilitating mapping and reconciliation with source systems.