Search Results min_proficiency_level_id

Overview

OTA_COMPETENCE_LANGUAGES is an Oracle Learning Management (OTA) table that defines the mapping between languages and competences. It resides in the OTA schema and is documented as VALID across Oracle EBS 12.1.1 and 12.2.2. Functionally, the table records which languages are associated with a given competence — for example, the languages in which a competence can be assessed, delivered, or required — and, through the MIN_PROFICIENCY_LEVEL_ID column, the minimum proficiency level expected for each language-competence pairing.

The table carries a surrogate primary key, OTA_COMPETENCE_LANGUAGES_PK, defined on COMPETENCE_LANGUAGE_ID, along with a business-key unique index, OTA_COMPETENCE_LANGUAGES_UK, defined on BUSINESS_GROUP_ID, COMPETENCE_ID, and LANGUAGE_ID. This composite unique constraint guarantees that a competence may be linked to a particular language only once within a business group. The documented physical schema contains 33 columns, of which the descriptive and key attributes are the most significant.

Regarding Data Vault modeling, the heuristic classification mined from the foreign-key structure is standalone. In Data Vault terms this suggests the object behaves primarily as a link (or an intersection) resolving the relationship between the competence and language hubs, rather than as a pure reference hub or a descriptive satellite.

Key Information Stored

The most important columns documented for this table include:

• COMPETENCE_LANGUAGE_ID — the surrogate primary key (OTA_COMPETENCE_LANGUAGES_PK) that uniquely identifies each mapping row.
• COMPETENCE_ID — foreign key to PER_COMPETENCES, identifying the competence being mapped; part of the UK.
• LANGUAGE_ID — foreign key to CSS_DEF_LANGUAGES_B, identifying the language; part of the UK.
• MIN_PROFICIENCY_LEVEL_ID — reference to the minimum proficiency level required for the language-competence combination.
• BUSINESS_GROUP_ID — the business group (operating unit) context; part of the UK.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OTA/HRMS framework.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns recording the last change.
• CREATED_BY, CREATION_DATE — the standard WHO columns recording row creation.
• OCL_INFORMATION_CATEGORY — the descriptive flexfield context (DDF) category.
• OCL_INFORMATION1 through OCL_INFORMATION20 — the descriptive flexfield (DFF) attribute columns (OCL is the flexfield context prefix).
• LANGUAGE_CODE — a denormalized or derived language code value associated with the mapping.

Columns such as COMPETENCE_LANGUAGE_ID and the two foreign keys carry referential meaning, whereas the OCL_INFORMATION* columns are reserved for customer-defined descriptive flexfield values, making the table extensible without structural changes.

Common Use Cases and Queries

Typical usage involves reporting which competences are language-sensitive and what minimum proficiency is required. A basic join to resolve competence names and language descriptions:

• Joining OTA_COMPETENCE_LANGUAGES to PER_COMPETENCES on COMPETENCE_ID and to CSS_DEF_LANGUAGES_B on LANGUAGE_ID.
• Filtering by BUSINESS_GROUP_ID for multi-org reporting.
• Selecting MIN_PROFICIENCY_LEVEL_ID to derive proficiency requirements.
• Querying OCL_INFORMATION* columns when the descriptive flexfield has been configured.

Example pattern: SELECT ocl.competence_language_id, ocl.competence_id, ocl.language_id, ocl.min_proficiency_level_id FROM ota.ota_competence_languages ocl WHERE ocl.business_group_id = :p_bg_id; This underpins learning-management configuration reports verifying that each competence has the required language mappings.

Related Objects

The most significant related objects, based on documented foreign-key relationships, include:

• PER_COMPETENCES — referenced via COMPETENCE_ID; the parent competence definition.
• CSS_DEF_LANGUAGES_B — referenced via LANGUAGE_ID; the language definition base table.
• OTA_COMPETENCE_LANGUAGES_PK — the primary key index on COMPETENCE_LANGUAGE_ID.
• OTA_COMPETENCE_LANGUAGES_UK — the unique index on BUSINESS_GROUP_ID, COMPETENCE_ID, LANGUAGE_ID.
• CSS_DEF_LANGUAGES_TL — the translatable language definitions typically joined for display.

These relationships make OTA_COMPETENCE_LANGUAGES a supporting link object in the Learning Management competence model.