Search Results jtf_task_statuses_tl_u1

Overview

JTF.JTF_TASK_STATUSES_TL is the translation (multi-language support) table for JTF_TASK_STATUSES_B within the Oracle E-Business Suite 12.1.1 and 12.2.2 releases. It resides in the JTF schema, is registered as FND Design Data under the same name, and has a documented status of VALID. The table is stored in the APPS_TS_SEED tablespace, which reflects its role as a seeded reference object populated during install and patching rather than an end-user transactional table. Its purpose is to hold the translated NAME and DESCRIPTION text for each task status record defined in the base table, one row per installed language.

Under a heuristic Data Vault classification, this object is best modeled as a satellite attached to the task status hub. The business key of the hub is TASK_STATUS_ID, while this table adds descriptive, language-dependent attributes (NAME, DESCRIPTION) plus the LANGUAGE discriminator that qualifies the satellite grain. It is not a link table because it does not resolve a many-to-many relationship between two business entities.

Key Information Stored

The table's columns fall into three groups: the composite key, the translatable attributes, and the standard audit columns.

• TASK_STATUS_ID (NUMBER, mandatory) — the unique task status identifier; the surrogate key inherited from JTF_TASK_STATUSES_B.
• LANGUAGE (VARCHAR2, mandatory) — the language into which the text is translated; it is part of the composite primary key.
• SOURCE_LANG (VARCHAR2) — the language from which the text was translated, typically the base language (US) of the seed row.
• NAME (VARCHAR2, length 30) — the translated display name of the task status.
• DESCRIPTION (VARCHAR2, length 240) — the translated description of the task status.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns, with foreign keys to FND_USER.USER_ID and FND_LOGINS.LOGIN_ID.
• SECURITY_GROUP_ID (NUMBER) — used in hosted environments; documented as referencing FND_SECURITY_GROUPS.

The documented primary key is JTF_TASK_STATUSES_TL_PK (TASK_STATUS_ID, LANGUAGE). Index JTF_TASK_STATUSES_TL_U1 is a NORMAL UNIQUE index on (TASK_STATUS_ID, LANGUAGE) in APPS_TS_SEED, making it the primary business-key candidate. ETRM 12.2.2 documentation lists a second candidate, JTF_TASK_STATUSES_TL_U1 (TASK_STATUS_ID, LANGUAGE, ZD_EDITION_NAME), reflecting the ZD_EDITION_NAME column introduced for edition-based redefinition support.

Common Use Cases and Queries

The most common pattern is joining the translation table to the base table and filtering by the session language to return status text in the user's locale. Because the base table cannot be queried directly for display names, any form, concurrent program, or report that presents task status labels must resolve text through this table.

• Resolve display values for a user session: SELECT TASK_STATUS_ID, NAME, DESCRIPTION FROM JTF.JTF_TASK_STATUSES_TL WHERE LANGUAGE = USERENV('LANG');
• Join base to translation: select b.TASK_STATUS_ID and t.NAME from JTF_TASK_STATUSES_B b inner join JTF_TASK_STATUSES_TL t on b.TASK_STATUS_ID = t.TASK_STATUS_ID where t.LANGUAGE = USERENV('LANG').
• Translation coverage audit: compare counts grouped by LANGUAGE against the installed languages in FND_LANGUAGES to identify missing or incomplete translations.
• Seed data validation after patching: verify that SOURCE_LANG and LANGUAGE pairs are consistent and that no duplicate (TASK_STATUS_ID, LANGUAGE) rows exist — a uniqueness check enforced by JTF_TASK_STATUSES_TL_U1.
• Reports and extracts: build multilingual reference listings for status-driven task or resource dashboards.

The recommended query text provided in the metadata selects all twelve documented columns directly from JTF.JTF_TASK_STATUSES_TL, with TASK_STATUS_ID as the leading driver column.

Related Objects

The following objects are most significant to this table's operation, based on the documented relationships:

• JTF.JTF_TASK_STATUSES_B — the base table holding the language-independent status definition; joined on TASK_STATUS_ID and the logical parent of this translation table.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for hosted (multi-tenant) environments.
• FND_USER — referenced by CREATED_BY and LAST_UPDATED_BY for WHO column integrity.
• FND_LOGINS — referenced by LAST_UPDATE_LOGIN.
• JTF_TASK_STATUSES_TL (APPS synonym/view) — the APPS-layer object through which applications typically query this data.
• FND_LANGUAGES — the reference source for valid LANGUAGE values used in translation coverage checks.

No database object is referenced by this table other than the foreign keys noted above, and it is itself referenced by the APPS synonym JTF_TASK_STATUSES_TL. Downstream task, resource, and scheduling modules that present status picklists therefore depend on this object for locale-correct text.