Results for “jtf_task_priorities_tl”

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

Overview

JTF_TASK_PRIORITIES_TL is the translation (language) table for task priority definitions within the Oracle E-Business Suite CRM Foundation module (JTF). In Oracle EBS 12.1.1 and 12.2.2, this table stores the multilingual, language-dependent attributes of task priorities — specifically the user-facing NAME and DESCRIPTION values — while the language-independent attributes reside in the corresponding base table. Its documented purpose is to hold all columns and data required for Multi-Language Support (MLS), enabling a single task priority to be presented in the language of the current session.

The table is owned by the JTF schema and is classified as VALID. In terms of a heuristic Data Vault classification, the metadata describes this object as standalone, with no downstream tables referencing it via foreign keys; it therefore behaves conceptually as a reference satellite attached to the base priority entity rather than as a hub or link. The presence of the SECURITY_GROUP_ID column and the ZD_EDITION_NAME column reflects the multi-tenant security model and, in 12.2.2, the Editioning architecture used in the AD/TXK editioning framework.

Key Information Stored

The table is a standard MLS pattern table with 12 documented columns. The most significant are:

• TASK_PRIORITY_ID — the surrogate identifier that links each translation row back to the base task priority record; it is the first component of the composite primary key.
• LANGUAGE — the language/locale code (for example, US for American English) that determines which translation row is returned; combined with TASK_PRIORITY_ID, it forms the primary key JTF_TASK_PRIORITIES_TL_PK.
• SOURCE_LANG — the language in which the NAME and DESCRIPTION were originally authored, used by the MLS runtime to decide whether translation is required.
• NAME — the translated display name of the task priority (for example, "High", "Low", "Critical").
• DESCRIPTION — the translated explanatory text describing the priority level.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS that enforces row-level security and data isolation across operating units or business groups.
• ZD_EDITION_NAME — the editioning column used by the 12.2.x online patching/Editioning feature to segregate edition-specific data.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, standard Oracle EBS WHO columns that track record provenance and change history.

The surrogate primary key is JTF_TASK_PRIORITIES_TL_PK (TASK_PRIORITY_ID, LANGUAGE). A unique index, JTF_TASK_PRIORITIES_TL_U1 (TASK_PRIORITY_ID, LANGUAGE, ZD_EDITION_NAME), represents a business-key candidate that extends the primary key with the editioning attribute.

Common Use Cases and Queries

Typical scenarios include retrieving a task priority's display name in a specific language, building bilingual or multilingual lookup reports, and joining priority definitions to task records. A representative query joining translations to the base table would be:

• SELECT b.TASK_PRIORITY_ID, t.NAME, t.DESCRIPTION FROM JTF_TASKS_B b, JTF_TASK_PRIORITIES_TL t WHERE b.TASK_PRIORITY_ID = t.TASK_PRIORITY_ID AND t.LANGUAGE = USERENV('LANG');
• Reporting on priorities where a translation is missing by comparing against SOURCE_LANG.
• Data migration or seed-data validation scripts that verify every base priority has a corresponding US-language row.
• Security-scoped extracts filtered by SECURITY_GROUP_ID, particularly in multi-org or shared-services deployments.

Related Objects

The following objects are most significant to JTF_TASK_PRIORITIES_TL:

• JTF_TASKS_B — the base (non-translated) task table referenced in the ETRM description; its priority records are the parents of the rows in this table.
• FND_SECURITY_GROUPS — referenced through the documented foreign key on SECURITY_GROUP_ID; governs which security group owns each translation row.
• FND_LANGUAGES — supplies the valid LANGUAGE and SOURCE_LANG codes used throughout the table.
• JTF_TASK_PRIORITIES_B — the language-independent base table that mirrors this translation table by TASK_PRIORITY_ID.
• Oracle EBS MLS runtime/API — the framework that resolves USERENV('LANG') against this table to render localized names in CRM task pages.