Search Results jtf_grid_datasources_tl_pk

Overview

The table JTF.JTF_GRID_DATASOURCES_TL is the translation (language) table associated with JTF_GRID_DATASOURCES_B, the base table that defines grid data sources for the CRM Foundation (JTF) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Grid data sources describe the queryable data sets and metadata that populate configurable grid regions in CRM and related HTML-based user interfaces. The _TL suffix indicates that this table stores the translatable, language-dependent attributes of each data source, allowing the same logical grid data source to be presented in multiple installed languages.

From a Data Vault modeling perspective, the ETRM relationship metadata classifies this object as satellite-leaning: it hangs off the base table via a foreign key and carries descriptive, language-dependent attributes keyed by the parent business key plus a language discriminator, which is the classic pattern of a satellite table. This is a heuristic suggestion rather than a mandatory schema design rule.

Key Information Stored

The table is owned by the JTF schema and contains 11 documented columns. The most significant are listed below.

• GRID_DATASOURCE_NAME — the business identifier of the grid data source. It is the column users search for when locating a data source by name. It forms part of both the primary key and the foreign key back to JTF_GRID_DATASOURCES_B.
• LANGUAGE — the language code for the translated row. Together with GRID_DATASOURCE_NAME it comprises the primary key JTF_GRID_DATASOURCES_TL_PK.
• SOURCE_LANG — the language from which the current translation was derived, supporting the standard EBS translation workflow.
• TITLE_TEXT — the translated display title shown to users for the grid data source; this is the principal language-dependent descriptive attribute.
• ZD_EDITION_NAME — the edition name used by the EBS online patching / editioning mechanism, present in 12.2.x deployments. It participates in the unique index JTF_GRID_DATASOURCES_TL_U1.
• SECURITY_GROUP_ID — the security group reference used for multi-org / data security filtering; it is a foreign key to FND_SECURITY_GROUPS.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO columns capturing insert and update audit information.

The documented business-key candidate is the unique index JTF_GRID_DATASOURCES_TL_U1 over (GRID_DATASOURCE_NAME, LANGUAGE, ZD_EDITION_NAME). The surrogate primary key JTF_GRID_DATASOURCES_TL_PK covers (GRID_DATASOURCE_NAME, LANGUAGE).

Common Use Cases and Queries

Typical usage resolves the translated title of a grid data source for a specific language, or lists all translations defined for a data source. A representative query joining the translation and base tables is:

SELECT tl.grid_datasource_name,
       tl.language,
       tl.title_text
FROM   jtf.jtf_grid_datasources_tl tl,
       jtf.jtf_grid_datasources_b  b
WHERE  tl.grid_datasource_name = b.grid_datasource_name
AND    tl.language              = USERENV('LANG');

A lookup by the searched business key is equally common:

SELECT grid_datasource_name,
       language,
       title_text,
       source_lang,
       last_update_date
FROM   jtf.jtf_grid_datasources_tl
WHERE  grid_datasource_name = :p_grid_datasource_name;

Reporting scenarios include auditing which data sources have translations missing for a given language, verifying translation currency via SOURCE_LANG, and exposing the title text through custom CRM pages or BI Publisher reports. Extract routines should respect SECURITY_GROUP_ID and, in 12.2.x, the active ZD_EDITION_NAME.

Related Objects

• JTF_GRID_DATASOURCES_B — the base table holding language-independent attributes; joined on GRID_DATASOURCE_NAME.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for data security.
• JTF_GRID_DATASOURCES_VL — the likely translated view exposing combined base and translated columns.
• JTF_GRID_DATASOURCES_TL translation maintenance via the standard EBS translation (TL) APIs and the Application Object Library language utilities.
• FND_LANGUAGES — supplies language definitions for the LANGUAGE column.

These relationships make JTF_GRID_DATASOURCES_TL a satellite of the grid data source entity, consumed by CRM grid rendering and translation workflows.