Search Results per_competences_tl_pk

Overview

PER_COMPETENCES_TL is the language translation table for the Competence repository within the Oracle E-Business Suite Human Resources (PER) module. It resides in the HR schema and is classified as VALID in Oracle EBS 12.1.1 and 12.2.2. In the Oracle EBS multi-language architecture, tables ending in the "_TL" suffix hold the translated, user-facing text attributes for a corresponding base entity table (PER_COMPETENCES_B). Each row in PER_COMPETENCES_TL represents the language-specific rendering of a single competence record, keyed by the combination of COMPETENCE_ID and LANGUAGE.

The ETRM metadata classifies this object, by heuristic Data Vault analysis, as standing alone — that is, a non-hub, non-link, non-satellite structure where no FK relationships were mined. In Data Vault modeling terms, this object is best understood as a language-dependent descriptive satellite of the competence entity, storing the translatable attributes (NAME, DESCRIPTION, BEHAVIOURAL_INDICATOR) partitioned by LANGUAGE. Because no foreign keys are enforced at the database level, the link to the base table is implemented through the shared COMPETENCE_ID column rather than a declared constraint.

Key Information Stored

The table contains 12 documented columns. The composite primary key PER_COMPETENCES_TL_PK is defined on (COMPETENCE_ID, LANGUAGE), making these two columns the surrogate-primary-key components. COMPETENCE_ID identifies the base competence record in PER_COMPETENCES_B, while LANGUAGE identifies the ISO language code of the translation (for example, US for US English or FR for French).

• COMPETENCE_ID — Surrogate key component linking the translation to its parent competence.
• LANGUAGE — Language code qualifying the translation row; second PK component.
• SOURCE_LANG — The source language from which the translation was derived.
• NAME — The translated name of the competence, the principal display attribute.
• COMPETENCE_ALIAS — An alternative or short name for the competence in the given language.
• BEHAVIOURAL_INDICATOR — The translated behavioural indicator text describing observable competence behaviours.
• DESCRIPTION — The translated long description of the competence.
• CREATED_BY, CREATION_DATE — Standard WHO audit columns recording row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the last modification and the login session.

Common Use Cases and Queries

The primary use case is multi-language presentation of the competence catalogue. Reporting and integration queries almost always join the translation table to the base table and filter by LANGUAGE to retrieve the appropriate display text. A typical pattern retrieves the translated name for a given language:

SELECT c.competence_id, t.name, t.description
FROM per_competences_b c, per_competences_tl t
WHERE c.competence_id = t.competence_id
AND t.language = USERENV('LANG');

Common scenarios include building competence dictionaries for iRecruitment and Talent Management, extracting translated descriptions for learning and appraisal configuration, and generating multilingual competence reports. Administrators frequently query for a specific competence across all languages to audit translation completeness, using GROUP BY competence_id with a count of LANGUAGE values.

Related Objects

Because the metadata documents no enforced foreign keys, relationships are logical and keyed on COMPETENCE_ID. The most significant related objects are:

• PER_COMPETENCES_B — The base table holding language-independent competence data; joined via COMPETENCE_ID.
• PER_COMPETENCES_VL — The translated view layered over the base and _TL tables, typically exposing NAME and DESCRIPTION in the session language.
• PER_COMPETENCE_REQUIREMENTS — Competences assigned to jobs and positions, referencing COMPETENCE_ID.
• PER_COMPETENCE_ELEMENTS — Elements associated with a competence.
• PER_PERSON_COMPETENCES — Person-level competence records that resolve to translated names for display.
• PER_COMPETENCE_LEVELS / PER_RATING_LEVELS — Proficiency definitions reported alongside translated competence text.

In summary, PER_COMPETENCES_TL is the multilingual text satellite for the competence repository, and any report or interface presenting competence names and descriptions should resolve these attributes through this table using the COMPETENCE_ID and LANGUAGE key.