Search Results jtf_grid_cols_tl_pk

Overview

JTF_GRID_COLS_TL is the translation (language-specific) table for JTF_GRID_COLS_B within the JTF — CRM Foundation product module of Oracle E-Business Suite. It stores the multilingual display attributes for configurable grid columns that drive the Oracle CRM Technology Foundation (JTF) grid rendering framework. Every grid column defined in the base table is paired here with one or more language rows, enabling the same application grid to render localized column labels for each installed language in an EBS instance.

The object resides in the JTF schema and is documented as VALID. Based on the foreign-key structure provided in the ETRM metadata, this table suggests a satellite-leaning Data Vault classification, as its identity is derived entirely from its parent (JTF_GRID_COLS_B) plus a language discriminator, with descriptive label text attached. In 12.1.1 and 12.2.2, the table additionally carries the ZD_EDITION_NAME column associated with the Online Patching (Editioning) architecture introduced in 12.2.

Key Information Stored

The table contains 12 documented columns. The primary key, JTF_GRID_COLS_TL_PK, is composed of GRID_DATASOURCE_NAME, GRID_COL_ALIAS, and LANGUAGE — the composite business identity of a translated grid column. Two additional unique indexes refine the business-key candidates: JTF_GRID_COLS_TL_U1 (GRID_DATASOURCE_NAME, GRID_COL_ALIAS, LANGUAGE, ZD_EDITION_NAME) and JTF_GRID_COLS_TL_U2 (GRID_DATASOURCE_NAME, LANGUAGE, LABEL_TEXT, ZD_EDITION_NAME).

• GRID_DATASOURCE_NAME — identifies the grid data source the column belongs to; part of the primary key.
• GRID_COL_ALIAS — the internal alias of the grid column; part of the primary key.
• LANGUAGE — the installed language code; part of the primary key and the translation discriminator.
• SOURCE_LANG — indicates the source language for the translation entry.
• LABEL_TEXT — the localized display label shown on the column header; the core translated payload.
• ZD_EDITION_NAME — the editioning discriminator supporting Online Patching in 12.2.
• SECURITY_GROUP_ID — the security group identifier referencing FND_SECURITY_GROUPS for multi-org/data security.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns (WHO columns).

Common Use Cases and Queries

Typical use cases include verifying that grid column labels are translated for a target language, auditing missing translations, and reporting on localization coverage for a given data source.

• Querying labels for a specific grid and language:

  SELECT grid_datasource_name, grid_col_alias, label_text
  FROM   jtf_grid_cols_tl
  WHERE  language = 'US'
  AND    grid_datasource_name = :ds_name;

• Finding columns with no translation for a required language by comparing JTF_GRID_COLS_B against the TL table via a LEFT JOIN on GRID_DATASOURCE_NAME and GRID_COL_ALIAS.
• Reporting translation coverage across languages using GROUP BY on GRID_DATASOURCE_NAME and LANGUAGE.
• Auditing last-updated translation rows via the WHO columns for change tracking.

Because the table is editioning-aware, queries run through the standard EBS database connection should reference the editioned synonyms or explicitly filter on the active ZD_EDITION_NAME where relevant.

Related Objects

The following objects are significant to JTF_GRID_COLS_TL based on documented FK/PK relationships and the JTF grid framework:

• JTF_GRID_COLS_B — the base (non-translated) grid column definition table; joined on GRID_DATASOURCE_NAME and GRID_COL_ALIAS.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for security group assignment.
• JTF_GRID_COLS_TL_PK / _U1 / _U2 — the primary key and unique indexes enforcing column identity and translation uniqueness.
• FND_LANGUAGES — source of valid LANGUAGE values used in the translation key.
• Related JTF grid metadata tables (such as base and translation counterparts for grid definitions and data sources) that share the GRID_DATASOURCE_NAME namespace and drive grid rendering at runtime.