Results for “okl_context_groups_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL.OKL_CONTEXT_GROUPS_TL is the translation (MLS) table for the base table OKL_CONTEXT_GROUPS_B within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 Leasing and Finance Management (OKL) module. Following Oracle's Multi-Language Support (MLS) standard, the _B table holds language-independent attributes, while the _TL table stores the translated, language-sensitive columns keyed by LANGUAGE. The object is owned by the OKL schema and is documented as VALID in the ETRM 12.2.2 data model. Context groups define logical groupings that drive various leasing and financing processes, and this table preserves the user-facing descriptive text of those groups in each installed language. The heuristic Data Vault classification returned by the mined FK structure is standalone. In Data Vault terms, this table is best modeled as a satellite attached to the context-group hub built from OKL_CONTEXT_GROUPS_B, since it carries descriptive, language-dependent attributes rather than relationships between entities.

Key Information Stored

The table contains eleven documented columns. The most significant are:

• ID — surrogate foreign key referencing the parent context group in OKL_CONTEXT_GROUPS_B; first component of the primary key OKL_CONTEXT_GROUPS_TL_PK.
• LANGUAGE — the language code qualifying the translated row; second component of the primary key.
• DESCRIPTION — the translated descriptive text for the context group, and the principal business attribute of this table.
• SOURCE_LANG — the language of the source record at creation time, used by MLS to track translation provenance.
• SFWT_FLAG — the "Seed/Force/Whatever/Translate" flag that controls whether the row is eligible for automatic translation seeding.
• ZD_EDITION_NAME — the edition/version column supporting Oracle's Edition-Based Redefinition (EBR); participates in the unique index OKL_CONTEXT_GROUPS_TL_U1.
• CREATED_BY, CREATION_DATE — standard WHO audit columns capturing row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns capturing the last modification.

The primary key is defined on (ID, LANGUAGE). The unique index OKL_CONTEXT_GROUPS_TL_U1 (ID, LANGUAGE, ZD_EDITION_NAME) serves as the edition-aware business-key candidate, ensuring one translated row per context group, per language, per edition.

Common Use Cases and Queries

The table is primarily read through MLS views that join _B and _TL rows and filter by the session language. Typical reporting scenarios include listing all context groups with their localized descriptions, auditing missing translations, and resolving a context group description in a specific language.

• List context groups in a chosen language:

  SELECT b.id, t.description
  FROM   okl.okl_context_groups_b b,
         okl.okl_context_groups_tl t
  WHERE  b.id = t.id
  AND    t.language = USERENV('LANG');

• Find context groups lacking a translation in a target language:

  SELECT b.id
  FROM   okl.okl_context_groups_b b
  WHERE  NOT EXISTS
         (SELECT 1 FROM okl.okl_context_groups_tl t
          WHERE  t.id = b.id AND t.language = 'FR');

• Audit translation maintenance activity by editor and timestamp using LAST_UPDATED_BY and LAST_UPDATE_DATE.
• Edition-aware queries may filter on ZD_EDITION_NAME when running under EBR-enabled sessions.

These queries support multi-language rollout validation, data-conversion reconciliation, and localization reporting for leasing implementations.

Related Objects

• OKL.OKL_CONTEXT_GROUPS_B — the base table; joined on ID, supplying language-independent context group attributes.
• OKL.OKL_CONTEXT_GROUPS_VL — the MLS view that unions base and translation columns for application queries.
• OKL.OKL_CONTEXT_GROUPS_TL_PK — the primary-key constraint enforcing uniqueness of (ID, LANGUAGE).
• OKL.OKL_CONTEXT_GROUPS_TL_U1 — the unique index incorporating ZD_EDITION_NAME.
• FND_LANGUAGES — the reference table validating the LANGUAGE value.
• OKL setup and context-group definition concurrent programs, which populate and maintain both the _B and _TL rows.