Search Results okc_k_groups_tl




Overview
Explore in AI Chat

Overview

OKC_K_GROUPS_TL is the translatable (multi-language) child table of OKC_K_GROUPS_B within the OKC – Contracts Core module of Oracle E-Business Suite. It stores the language-dependent descriptive attributes of contract groups — such as the group NAME and SHORT_DESCRIPTION — one row per installed language. The table follows Oracle Multi-Lingual Support (MLS) standards, meaning it is populated with a row for every language into which a contract group has been translated, keyed by language code. The base table, OKC_K_GROUPS_B, holds language-independent columns, while OKC_K_GROUPS_TL holds the translated text.

Contract groups are used in the Contracts Core (formerly OKC/Contracts) architecture to logically group contract documents and templates for organizational, security, or reporting purposes. Because group names are user-visible across locales, translation is handled through this MLS table rather than the base table. According to the heuristic Data Vault classification mined from its foreign-key structure, the table is best modeled as a standalone satellite around the OKC_K_GROUPS hub entity (the base table acting as the hub). This classification is a modeling suggestion only; in EBS the table is simply an MLS child of OKC_K_GROUPS_B.

Key Information Stored

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

  • ID — Surrogate identifier of the contract group; the language-independent key inherited from OKC_K_GROUPS_B.
  • LANGUAGE — The installed language code (from FND_LANGUAGES) identifying the translation of this row.
  • SOURCE_LANG — The language in which the source text was originally authored, used by MLS to indicate the base language.
  • NAME — The translated, user-visible name of the contract group.
  • SHORT_DESCRIPTION — The translated short description of the group.
  • SFWT_FLAG — Software Flag (MLS internal column) indicating the row's language-installation status.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording who created and last modified the row and when.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security-group access control.
  • ZD_EDITION_NAME — Edition-based redefinition column used by Online Patching (adop) in EBS 12.2.

The primary key is OKC_K_GROUPS_TL_PK on (ID, LANGUAGE). A unique index, OKC_K_GROUPS_TL_U1, covers (ID, LANGUAGE, ZD_EDITION_NAME) and serves as a business-key candidate for the edition-aware key. The surrogate primary key is (ID, LANGUAGE), while the human-meaningful business keys are ID plus LANGUAGE (with ZD_EDITION_NAME in 12.2).

Common Use Cases and Queries

Typical usage retrieves translated group names for display or reporting, joined back to the language-independent base.

  • List groups in the current language:
    SELECT t.id, t.name, t.short_description FROM okc_k_groups_tl t WHERE t.language = USERENV('LANG');
  • Join base and translation:
    SELECT b.id, t.name FROM okc_k_groups_b b, okc_k_groups_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
  • Find untranslated groups: compare installed languages (FND_LANGUAGES) against rows in OKC_K_GROUPS_TL for a given ID to identify missing translations.
  • Reporting: expose group names to BI Publisher or OBIEE, filtering on LANGUAGE to guarantee consistent locale output.

Because the table is MLS, applications should always constrain LANGUAGE (or rely on MLS views) to avoid returning multiple language rows per group.

Related Objects

  • OKC_K_GROUPS_B — Base (language-independent) parent table; joins on ID = ID.
  • OKC_K_GROUPS_VL — MLS view joining base and TL for a single-language view; join on ID.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for access control.
  • FND_LANGUAGES — Provides valid LANGUAGE codes and installed-language metadata.
  • OKC_K_GROUP_RELS / OKC_K_LINES — Group hierarchy and line-level memberships referencing the group by ID.
  • OKC_CONTRACT_GROUPS and related OKC contract group APIs — consume these names for UI and processing.