Search Results hr_de_org_link_types_mapping




Overview
Explore in AI Chat

Overview

The HR_DE_ORG_LINK_TYPES_MAPPING view is an APPS-owned database object within the PER (Human Resources) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. As its description indicates, this view exposes the structure of a German-specific user-defined table that maps German organizational classes (ORG_CLASS) to organizational link types (ORG_LINK_TYPE). The view is stored in the APPS schema with a status of VALID and is documented in the ETRM repository as a read-only presentation layer over the Oracle HR "User Tables" (also known as Descriptive Flexfield-style configurable tables) framework.

Rather than storing data directly in a conventional database table, the German localization for Oracle HR persists its mapping data through the generic PAY_USER_TABLES / PAY_USER_ROWS_F / PAY_USER_COLUMNS / PAY_USER_COLUMN_INSTANCES_F extensibility model. The view collapses that multi-table, attribute-value structure into a simple two-column result set, allowing reporting tools, integrations, and localization logic to read the mapping without understanding the underlying generic model. This makes the view particularly relevant to the user search term pay_user_columns, since the view is defined directly over that object.

Underlying Base Objects

The ETRM metadata documents the view as being defined over four base objects, all referenced through synonyms in the APPS schema:

  • PAY_USER_COLUMNS – Defines the named columns (attributes) that belong to each user-defined table; here it supplies the ORG_LINK_TYPE and ORG_CLASS column definitions.
  • PAY_USER_COLUMN_INSTANCES_F – Stores the actual instance values for each column on each row of the user table.
  • PAY_USER_ROWS_F – Identifies the individual row instances of the user-defined table.
  • PAY_USER_TABLES – Defines the user table itself, identified by USER_TABLE_NAME = 'HR_DE_LINK_TYPE_MAPPINGS'.

The view joins these four objects on USER_TABLE_ID, USER_ROW_ID, and USER_COLUMN_ID, performing two self-joins of PAY_USER_COLUMNS and PAY_USER_COLUMN_INSTANCES_F (aliased UC1/UC2 and UCI1/UCI2) to pivot the attribute-value rows into two side-by-side columns.

Key Columns

The view exposes exactly two columns:

  • ORG_LINK_TYPE – Sourced from the column instance whose USER_COLUMN_NAME is 'ORG_LINK_TYPE' (UCI1.VALUE). This represents the organizational link type used in the German HR organization model.
  • ORG_CLASS – Sourced from the column instance whose USER_COLUMN_NAME is 'ORG_CLASS' (UCI2.VALUE). This represents the German organizational classification being mapped.

Because both values are retrieved from the generic VALUE attribute of PAY_USER_COLUMN_INSTANCES_F, the columns are returned as character strings and no formal foreign-key constraints or data types are enforced at the database level.

Common Use Cases and Queries

Typical uses include validating German organization setups, auditing localization configuration, and feeding the mapping into downstream integrations or custom reports. Because the view returns a straightforward two-column result set, it is well suited to joins against organization or link-type descriptive tables.

  • Retrieve the full mapping for audit or migration purposes:
    SELECT org_class, org_link_type FROM apps.hr_de_org_link_types_mapping;
  • Find the link type associated with a specific organizational class:
    SELECT org_link_type FROM apps.hr_de_org_link_types_mapping WHERE org_class = :p_org_class;
  • Detect incomplete or orphaned mappings by checking for null values returned through the outer structure of the underlying user-column instances.

Administrators investigating the view's data should also query PAY_USER_TABLES for USER_TABLE_NAME = 'HR_DE_LINK_TYPE_MAPPINGS' and the related PAY_USER_COLUMNS rows, since corrections to the mapping are made through the Oracle HR user-table maintenance interface rather than by updating the view directly.