Search Results jtf_nav_tree_roots_tl




Overview
Explore in AI Chat

Overview

The JTF_NAV_TREE_ROOTS_TL table resides in the JTF schema (CRM Foundation) and serves as the translation table for tree root definitions in the Oracle E-Business Suite navigational framework. In EBS 12.1.1 and 12.2.2, JTF_NAV_TREE_ROOTS_B stores the base, language-independent definition of navigational tree roots, while JTF_NAV_TREE_ROOTS_TL stores the language-dependent label text that is displayed to the end user at the root node of a navigational tree structure. This separation of base and translation rows follows the standard EBS multilingual ("_B" / "_TL") pattern, which allows a single logical root definition to carry distinct display strings for each installed language.

Under the heuristic Data Vault classification mined from the foreign-key structure, this table is satellite-leaning. It holds descriptive, language-dependent attributes (principally the root label) that change independently of the parent hub or link entity represented by JTF_NAV_TREE_ROOTS_B.

Key Information Stored

The documented physical schema comprises eleven columns. The most significant are:

  • TREE_ROOT_ID — Surrogate identifier of the navigational root. Part of the composite primary key and the foreign key to JTF_NAV_TREE_ROOTS_B.
  • LANGUAGE — The language code for which the translated label applies. Part of the composite primary key.
  • ROOT_LABEL — The translatable display text rendered at the root of the navigational tree; the central payload column of this table.
  • SOURCE_LANG — Indicates the source language from which the translation was derived, supporting the standard EBS translation workflow.
  • ZD_EDITION_NAME — Editioning column used in 12.2 online patching; participates in the unique index JTF_NAV_TREE_ROOTS_TL_U1.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant data partitioning.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns capturing the audit trail of row creation and modification.

The primary key is JTF_NAV_TREE_ROOTS_TL_PK, defined on (TREE_ROOT_ID, LANGUAGE). A unique index, JTF_NAV_TREE_ROOTS_TL_U1, is defined on (TREE_ROOT_ID, LANGUAGE, ZD_EDITION_NAME) and serves as the documented business-key candidate, since the surrogate TREE_ROOT_ID combined with LANGUAGE uniquely identifies a translation row.

Common Use Cases and Queries

The table is most commonly accessed when resolving the display label for a navigational root in a specific language. A typical reporting query joins the translation table to its base table to produce language-specific navigation reporting:

  • Retrieving a label for a given root and language: SELECT ROOT_LABEL FROM JTF.JTF_NAV_TREE_ROOTS_TL WHERE TREE_ROOT_ID = :id AND LANGUAGE = USERENV('LANG');
  • Auditing translations across all languages: join JTF_NAV_TREE_ROOTS_B to JTF_NAV_TREE_ROOTS_TL on TREE_ROOT_ID to compare ROOT_LABEL values by LANGUAGE.
  • Detecting missing translations: outer-join the base table to the translation table and filter where ROOT_LABEL is null.
  • Security Group validation: joining SECURITY_GROUP_ID to FND_SECURITY_GROUPS to confirm the root's tenant assignment.

Because the label drives user-facing navigation, the table is also relevant to localization testing and content migration scripts within CRM Foundation implementations.

Related Objects

  • JTF_NAV_TREE_ROOTS_B — The base table holding language-independent root attributes; joined on TREE_ROOT_ID. This is the primary parent object referenced by the foreign key.
  • FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID to enforce multi-tenant visibility of the translated label.
  • JTF_NAV_TREE_NODES_B / JTF_NAV_TREE_NODES_TL — Sibling base/translation tables for child nodes; used alongside tree roots to reconstruct complete navigational hierarchies.
  • JTF_NAV_WINDOWS / JTF_NAV_TREE_STRUCTURES — Navigation configuration objects that reference root definitions to assemble menu structures.
  • FND_LANGUAGES — Validates the LANGUAGE codes stored in translation rows.
  • FND_APPLICATION / JTF menu APIs — Consumer components that read root labels at runtime to render the CRM Foundation navigation tree.