Search Results ota_learning_paths_tl_pk

Overview

OTA_LEARNING_PATHS_TL is the language translation (TL) table for Learning Paths within the Oracle E-Business Suite Learning Management module (OTA). In the Oracle EBS multilanguage architecture, every translatable entity is represented by a pair of tables: a base ("B" or non-TL) table that stores language-independent attributes and a "_TL" table that stores the language-dependent descriptive attributes. OTA_LEARNING_PATHS_TL holds the translated textual content of a Learning Path — its name, description, objectives, purpose, and keywords — for each installed language.

The table is owned by the OTA schema and is documented in ETRM 12.2.2 as a standalone, valid database object with 13 columns. Its primary key is OTA_LEARNING_PATHS_TL_PK, defined on the composite of LEARNING_PATH_ID and LANGUAGE. From a Data Vault modeling perspective, the mined relationship structure suggests classifying this object as a standalone construct; heuristically it behaves as a satellite attached to the Learning Path hub (the base OTA_LEARNING_PATHS table), since it carries descriptive, language-variant attributes keyed back to the parent entity. This classification is a modeling suggestion rather than a documented fact.

Key Information Stored

The 13 documented columns fall into three functional groups: identity keys, translated content, and audit metadata.

• LEARNING_PATH_ID — Surrogate/foreign key identifying the parent Learning Path. It is the first component of the composite primary key and joins to the base Learning Path definition.
• LANGUAGE — The language code for the row's translations. It is the second component of OTA_LEARNING_PATHS_TL_PK and determines which locale the content describes.
• NAME — The translated display name of the Learning Path.
• DESCRIPTION — The translated long description of the Learning Path.
• OBJECTIVES — The translated learning objectives associated with the path.
• PURPOSE — The translated purpose or business rationale for the path.
• KEYWORDS — Translated search keywords used for catalog discovery.
• SOURCE_LANG — The source language from which the translation was derived, supporting the Oracle translations framework.
• CREATED_BY — The application user who created the translation row.
• CREATION_DATE — The timestamp when the translation row was created.
• LAST_UPDATE_DATE — The timestamp of the most recent modification.
• LAST_UPDATED_BY — The user who last modified the row.
• LAST_UPDATE_LOGIN — The login identifier associated with the last update.

The PK (LEARNING_PATH_ID, LANGUAGE) is the surrogate identity, and the unique index OTA_LEARNING_PATHS_TL_PK also serves as the business-key candidate: one translation row per path per language. The audit columns (CREATED_BY through LAST_UPDATE_LOGIN) follow the standard Oracle EBS "Who" column conventions.

Common Use Cases and Queries

The primary use case is rendering Learning Path content in the user's session language, and reporting on translated catalog content across locales. A typical multilingual lookup joins the TL row for the desired language:

• List all Learning Path names in a specific language: SELECT learning_path_id, name FROM ota_learning_paths_tl WHERE language = :p_lang.
• Search by translated keyword: SELECT learning_path_id, name FROM ota_learning_paths_tl WHERE language = :p_lang AND UPPER(keywords) LIKE '%SAFETY%'.
• Detect missing translations by comparing the base table against the TL table per language, using a NOT EXISTS predicate on (LEARNING_PATH_ID, LANGUAGE).
• Identify stale translations by inspecting LAST_UPDATE_DATE, LAST_UPDATED_BY, and the audit columns for a given path and language.
• Analyze translation coverage: group counts by LANGUAGE to report how many paths are translated into each installed language.

Related Objects

Because this table is a translation satellite, the most significant related objects are its base entity and the language/framework tables that govern its keys.

• OTA_LEARNING_PATHS — The base (language-independent) Learning Path table. Join on LEARNING_PATH_ID to combine structural attributes with translated text.
• OTA_LEARNING_PATHS_TL itself is referenced by the framework through the composite key columns LEARNING_PATH_ID and LANGUAGE.
• FND_LANGUAGES — The installed-language definition table. Join OTA_LEARNING_PATHS_TL.LANGUAGE to FND_LANGUAGES.LANGUAGE_CODE to resolve language names and flags.
• OTA_LEARNING_PATH_ITEMS / related OTA path structures — The child objects that define the ordered contents of a path; they reference the parent via LEARNING_PATH_ID.
• FND_TERRITORIES and the ML framework views — Support the session language selection that determines which LANGUAGE row is displayed.
• Standard Oracle "Who" columns — CREATED_BY and LAST_UPDATED_BY commonly join to FND_USER for audit reporting.

These relationships reflect the documented PK structure and standard OTA/FND module design.