Search Results hr_document_types_v




Overview
Explore in AI Chat

Overview

HR_DOCUMENT_TYPES_V is a translated database view owned by the APPS schema in Oracle E-Business Suite, belonging to the PER (Human Resources) product family. It exposes the definition of document types maintained within Oracle HRMS, presenting them in the session language of the querying user. The view is documented as valid in both EBS 12.1.1 and 12.2.2, and its structure is consistent across these releases.

The view's primary role is to provide a language-aware, foreign-key-resolved projection of document type configuration. Rather than requiring report developers and integrators to join the base and translation tables manually, HR_DOCUMENT_TYPES_V resolves translatable text, lookup meanings, and shared-type names in a single object. This makes it suitable for reporting, concurrent program sources, and inbound/outbound integration queries where human-readable document type labels and category names are required.

Underlying Base Objects

The view is defined over the following documented objects:

The join predicates enforce that HR_DOCUMENT_TYPES_TL.DOCUMENT_TYPE_ID equals HR_DOCUMENT_TYPES.DOCUMENT_TYPE_ID, and that the translation row matches the user's session language via HDTTL.LANGUAGE = USERENV('LANG'). Category resolution joins CATEGORY_CODE to HR_LOOKUPS.LOOKUP_CODE filtered by LOOKUP_TYPE = 'DOCUMENT_CATEGORY', while sub-category resolution joins SUB_CATEGORY_CODE to PER_SHARED_TYPES_VL.SHARED_TYPE_CODE.

Key Columns

Common Use Cases and Queries

The view is commonly used to populate LOVs, validate configuration, and drive HR document tracking reports. Because it resolves translated text automatically, it is preferred over joining the base tables directly. A typical query listing active document types for a category is:

  • SELECT document_type_id, document_type, category_name, sub_category_name, active_inactive_flag FROM hr_document_types_v WHERE category_code = :p_category AND active_inactive_flag = 'Y' ORDER BY document_type;
  • SELECT document_type_id, document_type, description, legislation_code, warning_period FROM hr_document_types_v WHERE legislation_code = :p_legislation;
  • SELECT category_name, COUNT(*) FROM hr_document_types_v GROUP BY category_name;

Integrations may additionally use DOCUMENT_TYPE_ID as the foreign key when inserting or querying person or assignment document records, ensuring the correct translated label is presented to end users.