Search Results upload_id

Overview

The HR_DU_UPLOADS table is a core data repository within the Oracle E-Business Suite Human Resources (PER) module, specifically for the Data Upload (DU) utility. It functions as the master control table for all data upload processes initiated from external source files. Each row in this table represents a single, distinct upload session, containing metadata that tracks the source, status, and processing context of the uploaded data. Its primary role is to provide a unique identifier (UPLOAD_ID) for each upload batch, enabling the system to link and manage all associated data records, validation errors, and processing headers throughout the upload lifecycle.

Key Information Stored

The table's structure is designed to catalog the essential attributes of an upload session. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its critical components. The UPLOAD_ID column is the primary key, serving as the unique sequence identifier for every upload. The MODULE_ID is a foreign key linking to the HR_DU_MODULES table, which identifies the specific HR sub-module (e.g., People, Assignments, Salary Basis) for which the data is intended. Other typical columns in such a control table, inferred from standard practice, would include status flags (e.g., PROCESS_STATUS), timestamps for creation and last update, the name of the source file, and the user who initiated the upload.

Common Use Cases and Queries

This table is central to auditing, troubleshooting, and reporting on data upload activities. Common operational scenarios include tracking the progress of bulk data loads, identifying failed upload batches for re-processing, and generating upload history reports. A fundamental query involves joining with related tables to get a complete upload summary:

• Finding Recent Uploads with Errors: SELECT upl.upload_id, upl.file_name, COUNT(err.error_id) AS error_count FROM hr_du_uploads upl JOIN hr_du_errors err ON upl.upload_id = err.upload_id WHERE upl.process_status = 'ERROR' GROUP BY upl.upload_id, upl.file_name;
• Identifying Uploads for a Specific Module: SELECT upl.* FROM hr_du_uploads upl WHERE upl.module_id = (SELECT module_id FROM hr_du_modules WHERE module_name = 'People');

Related Objects

The HR_DU_UPLOADS table sits at the center of the Data Upload utility's schema, with defined relationships to several key supporting tables, as documented in the provided metadata.

• Referenced Foreign Key (Outbound): The table references HR_DU_MODULES via the MODULE_ID column to determine the target application area for the uploaded data.
• Referencing Foreign Keys (Inbound): Three child tables use the UPLOAD_ID as a foreign key to associate their records with a specific upload session:
  • HR_DU_DESCRIPTORS: Likely stores descriptive flexfield or contextual data for the upload.
  • HR_DU_ERRORS: Contains all validation and processing errors generated for the upload batch.
  • HR_DU_UPLOAD_HEADERS: Presumably holds header-level information or control totals for the data within the upload file.