Results for “hr_du_descriptors”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HR_DU_DESCRIPTORS is a Human Resources (PER) module table in the Oracle E-Business Suite HR schema. It stores the descriptor details associated with each API that is uploaded through the Data Upload (DU) framework. In practical terms, the table acts as the attribute-level repository that defines how individual upload records are described, keyed, and interpreted during the data upload process. Each row represents a single descriptor entry tied to a specific upload and upload header, providing the granular descriptive metadata that the upload engine requires when processing bulk HR API operations.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure suggests this object behaves as a link entity. It resolves relationships between upload definitions and their descriptive attributes, and it also carries a reference to an application security group. The presence of multiple foreign keys to distinct parent tables — HR_DU_UPLOADS, HR_DU_UPLOAD_HEADERS, and FND_SECURITY_GROUPS — supports this link interpretation.

Key Information Stored

The table contains twelve documented columns. The most significant are summarized below.

• DESCRIPTOR_ID — The surrogate primary key, enforced by the unique index HR_DU_DESCRIPTORS_PK. This is the sole business-key candidate documented for the table.
• UPLOAD_ID — Foreign key referencing HR_DU_UPLOADS, identifying the parent upload definition this descriptor belongs to.
• UPLOAD_HEADER_ID — Foreign key referencing HR_DU_UPLOAD_HEADERS, linking the descriptor to a specific upload header record.
• DESCRIPTOR — The name or label of the descriptor being defined.
• VALUE — The value assigned to the descriptor for the given upload context.
• DESCRIPTOR_TYPE — Classifies the descriptor, allowing the upload framework to interpret the value appropriately.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-organization and security group data partitioning.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide standard Oracle EBS who-did-what-and-when tracking.

The surrogate key DESCRIPTOR_ID is distinct from any business-key candidate; HR_DU_DESCRIPTORS_PK is the only unique index documented, so no alternate unique business key is defined beyond the primary key.

Common Use Cases and Queries

Typical usage centers on diagnosing, auditing, and reporting on data upload activity. Developers and support analysts query this table to determine which descriptors were configured for a given upload and to verify the values applied.

A common pattern joins descriptors to their parent upload and header records:

• Selecting all descriptors for a specific upload: SELECT d.DESCRIPTOR_ID, d.DESCRIPTOR, d.VALUE, d.DESCRIPTOR_TYPE FROM HR_DU_DESCRIPTORS d WHERE d.UPLOAD_ID = :upload_id;
• Joining to header context: ... FROM HR_DU_DESCRIPTORS d, HR_DU_UPLOAD_HEADERS h WHERE d.UPLOAD_HEADER_ID = h.UPLOAD_HEADER_ID;
• Filtering by security group for multi-org reporting using SECURITY_GROUP_ID.
• Audit reporting on CREATED_BY and CREATION_DATE to trace when descriptors were introduced.

Related Objects

The following objects are the most significant related to HR_DU_DESCRIPTORS based on documented relationships.

• HR_DU_UPLOADS — Parent table joined via HR_DU_DESCRIPTORS.UPLOAD_ID.
• HR_DU_UPLOAD_HEADERS — Parent table joined via HR_DU_DESCRIPTORS.UPLOAD_HEADER_ID.
• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID, controlling data access partitioning.
• HR_DU_DESCRIPTOR_PK — The unique index enforcing the primary key on DESCRIPTOR_ID.

These relationships make HR_DU_DESCRIPTORS a central link in the Data Upload framework, connecting upload definitions, headers, and security context within the HR schema.