Search Results upload_header_id

Overview

The HR_DU_UPLOAD_HEADERS table is a core technical table within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically supporting the Data Upload (DU) functionality in releases 12.1.1 and 12.2.2. It functions as a control table that holds the master definition for each distinct batch of data submitted for processing via the HR Data Uploader or related APIs. Each record in this table represents a single, logical upload job, acting as a parent container for the individual data lines and associated metadata. Its primary role is to manage the lifecycle and integrity of bulk data upload operations, providing a key identifier that links all related data, descriptors, and any processing errors.

Key Information Stored

While the provided ETRM metadata does not list specific column names beyond key identifiers, the table's structure is defined by its relationships. The primary column is UPLOAD_HEADER_ID, which is the unique sequence-generated identifier for each upload batch and serves as the table's primary key (HR_DU_UPLOAD_HEADERS_PK). A critical foreign key column is UPLOAD_ID, which links the header to its parent control record in the HR_DU_UPLOADS table. Typically, this table would also store status information (e.g., PENDING, PROCESSING, COMPLETE, ERROR), a reference to the specific API or interface being used for the upload, the user who initiated the job, and timestamps for creation and last update. This metadata is essential for tracking, auditing, and managing the execution of bulk data loads.

Common Use Cases and Queries

This table is central to troubleshooting and monitoring batch data uploads. Common operational queries involve identifying stalled or failed upload jobs or analyzing upload history. For instance, to find all upload headers that have been in a processing state for an extended period, a query might join HR_DU_UPLOAD_HEADERS with HR_DU_UPLOADS on UPLOAD_ID and filter on status and creation date. Reporting on upload volumes by user or API typically requires grouping by relevant columns from this header table. Support and development personnel frequently query this table alongside HR_DU_UPLOAD_LINES and HR_DU_ERRORS to diagnose specific failures within an upload batch, using the UPLOAD_HEADER_ID as the join key to isolate all related records for a problematic job.

Related Objects

The HR_DU_UPLOAD_HEADERS table is a central node in the Data Upload schema, with defined foreign key relationships to several supporting tables.

• Referenced Foreign Key (Parent): HR_DU_UPLOAD_HEADERS.UPLOAD_ID references HR_DU_UPLOADS. This links the specific API upload batch to a higher-level upload session or request.
• Referencing Foreign Keys (Child Tables):
  • HR_DU_DESCRIPTORS.UPLOAD_HEADER_ID references this table. Descriptors hold additional metadata or context for the upload.
  • HR_DU_ERRORS.UPLOAD_HEADER_ID references this table. All processing errors generated for the upload batch are linked via this key.
  • HR_DU_UPLOAD_LINES.UPLOAD_HEADER_ID references this table. This is the most critical relationship, as all the actual data rows for the upload are stored in the lines table and tied to their header.