Search Results descriptor_id

Overview

The HR_DU_DESCRIPTORS table is a core data structure within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the Data Upload (DU) functionality in releases 12.1.1 and 12.2.2. It serves as a transactional repository for the descriptor details associated with each API call initiated through the Data Upload process. This table is integral to the batch data loading framework, acting as a child table that stores granular metadata and parameters required to execute and validate individual data upload operations for entities such as employees, assignments, or personal information.

Key Information Stored

The table's primary purpose is to hold the specific details for an API upload. While the full column list is not detailed in the provided metadata, its structure is defined by key identifiers and relationships. The primary key column, DESCRIPTOR_ID, uniquely identifies each descriptor record. Two critical foreign key columns establish its operational context: UPLOAD_ID links the descriptor to its parent upload job in the HR_DU_UPLOADS table, while UPLOAD_HEADER_ID links it to a specific upload header or batch within that job in the HR_DU_UPLOAD_HEADERS table. Additional columns would typically store data such as the API name, descriptor type, sequence number, and the actual parameter values or data mappings to be passed to the target HR API.

Common Use Cases and Queries

This table is primarily accessed for troubleshooting and auditing Data Upload processes. Common scenarios include diagnosing failed uploads by examining the descriptor details for a specific job or generating reports on historical data loads. A typical query would join to parent tables to provide context. For example, to list all descriptors for a specific upload, one might use:

• SELECT d.* FROM hr.hr_du_descriptors d, hr.hr_du_uploads u WHERE d.upload_id = u.upload_id AND u.upload_name = '&UPLOAD_NAME';

Another common pattern is to trace the progression of data by joining through the header to the actual staging tables, helping to pinpoint where in the multi-step process an error occurred based on the descriptor's parameters and sequence.

Related Objects

The HR_DU_DESCRIPTORS table has defined dependencies within the Data Upload schema, as documented by its foreign key relationships. It is a child table to two primary upload control tables:

• HR_DU_UPLOADS: Linked via the HR_DU_DESCRIPTORS.UPLOAD_ID column. This table defines the overall upload job or process.
• HR_DU_UPLOAD_HEADERS: Linked via the HR_DU_DESCRIPTORS.UPLOAD_HEADER_ID column. This table typically represents a batch or logical group of records within the larger upload job.

These relationships ensure data integrity, cascading deletions, and provide the necessary hierarchy from the master upload definition (HR_DU_UPLOADS) down to the individual API parameters (HR_DU_DESCRIPTORS).