Search Results ota_user_groups_tl




Overview
Explore in AI Chat

Overview

OTA_USER_GROUPS_TL is the translation table for the Oracle Learning Management (OTA) user group entity in Oracle E-Business Suite 12.1.1 and 12.2.2. A user group in Learning Management is a named collection of learners used to control self-service enrollment eligibility, catalog visibility, and bulk assignment of learning activities. Because user group names and descriptions must be presented in the operating language of each user, Oracle stores the descriptive, language-sensitive attributes of a user group in this table while the language-independent attributes reside in the base table OTA_USER_GROUPS_B.

The table is owned by the OTA schema and, from a Data Vault modeling perspective, the ETRM relationship metadata classifies this object heuristically as a satellite. The classification is a modeling suggestion only: the table does not introduce its own business key but hangs descriptive, language-dependent attributes off the user group identifier defined in the base table. Its grain is one row per user group per installed language.

Key Information Stored

The physical schema documents ten columns for this table:

  • USER_GROUP_ID — the surrogate identifier of the user group, inherited from the base entity. It is the join key back to OTA_USER_GROUPS_B and, together with LANGUAGE, forms the unique key.
  • LANGUAGE — the language code of the translated row, drawn from FND_LANGUAGES. It combines with USER_GROUP_ID in the unique index OTA_USER_GROUPS_TL_UK1, making (LANGUAGE, USER_GROUP_ID) the composite business/primary key of this translation table.
  • USER_GROUP_NAME — the translatable, user-facing name of the user group. This is the primary descriptive attribute and the value most often surfaced in list-of-values queries and enrollment screens.
  • DESCRIPTION — the translatable long description of the user group, used to explain the group's purpose or membership scope to administrators and learners.
  • SOURCE_LANG — the language in which the row was originally entered; Oracle uses it to determine whether a translation is the "source" record or a derived one.
  • CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Oracle Applications WHO columns capturing audit and concurrency information for each translated row.

The surrogate/primary key is the composite OTA_USER_GROUPS_TL_UK1 over (LANGUAGE, USER_GROUP_ID). There is no separate single-column business key documented; USER_GROUP_ID alone is a foreign-key candidate referencing the base table, while LANGUAGE is the discriminating attribute for the translation.

Common Use Cases and Queries

Reporting and integration queries typically join this translation table to the base table and constrain by the session or requested language. A representative pattern for retrieving the display name of a user group is:

  • SELECT b.user_group_id, tl.user_group_name, tl.description FROM ota_user_groups_b b, ota_user_groups_tl tl WHERE b.user_group_id = tl.user_group_id AND tl.language = USERENV('LANG') — the classic translated-entity lookup.
  • Eligibility and catalog reports use the same join to render group names in the learner's language when populating enrollment or self-service pages.
  • Multi-language validation queries count rows per USER_GROUP_ID to detect groups missing translations in a required language, or use SOURCE_LANG to identify the originating row.
  • Audit extracts select the WHO columns to trace when a translation was created or last changed.

Related Objects

  • OTA_USER_GROUPS_B — the base table holding language-independent user group attributes; joined on USER_GROUP_ID.
  • OTA_USER_GROUP_MEMBERS — membership assignments linking learners to a user group via USER_GROUP_ID.
  • FND_LANGUAGES — the language reference validating the LANGUAGE column.
  • OTA_USER_GROUPS_VL — the commonly used translation-enabled view that unions the base and translation tables for reporting.
  • OTA_USER_GROUPS_TL synonyms and the OTA public APIs for user group maintenance, which write both the base and translation rows.