Results for “jtf_auth_domains_tl”

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

Overview

JTF_AUTH_DOMAINS_TL is a translation (language-specific) table residing in the JTF schema, owned by the CRM Foundation product module. In Oracle EBS 12.1.1 and 12.2.2, it stores the translatable descriptive text associated with authorization domains defined in the CRM Foundation security model. Authorization domains are the containers through which JTF-based access control is expressed, and this table preserves the MLS (Multi-Language Support) rendering of each domain's description so that the domain name and explanation are presented in the user's session language.

The object is documented as VALID in ETRM for both 12.1.1 and 12.2.2. It is a pure child of the base table JTF_AUTH_DOMAINS_B, linked by DOMAIN_DESC_ID, and its columns follow the standard Oracle Applications MLS pattern (DOMAIN_DESC, DESCRIPTION, TRANSLATED, LANGUAGE, SOURCE_LANG). Summarized heuristically, the Data Vault classification is satellite-leaning: the table depends entirely on its parent key and holds no independent business identity of its own.

Key Information Stored

The table contains 13 documented columns. The most significant are:

• DOMAIN_DESC_ID — surrogate primary key (JTF_AUTH_DOMAINS_TL_PK) and foreign key to JTF_AUTH_DOMAINS_B; ties each translation row to its parent authorization domain.
• DOMAIN_DESC — the translated display name/description of the authorization domain.
• DESCRIPTION — the longer translated descriptive text for the domain.
• LANGUAGE — the language code of the translated row.
• SOURCE_LANG — the source language from which the translation was derived, supporting MLS translation workflows.
• TRANSLATED — flag indicating whether the row has been translated.
• SECURITY_GROUP_ID — references FND_SECURITY_GROUPS and enforces data security at row level.
• ZD_EDITION_NAME — editioning column used in 12.2 online patching; participates in the unique index below.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.

The unique index JTF_AUTH_DOMAINS_TL_U1 (DOMAIN_DESC_ID, LANGUAGE, ZD_EDITION_NAME) is the business-key candidate; it guarantees one translation row per domain per language per edition, which is the natural uniqueness rule for an MLS satellite.

Common Use Cases and Queries

Typical usage is joining the translation to its base row to obtain a language-resolved label for an authorization domain. For example:

SELECT b.domain_id, t.domain_desc, t.description
FROM   jtf_auth_domains_b b,
       jtf_auth_domains_tl t
WHERE  b.domain_desc_id = t.domain_desc_id
AND    t.language = USERENV('LANG');

Reporting scenarios include auditing which domains have been translated into which languages, checking for missing translations (rows where TRANSLATED = 'N' or the target language is absent), and validating that only the current edition (ZD_EDITION_NAME) is being read during 12.2 online patching. Security reporting may filter by SECURITY_GROUP_ID to confirm which domain translations are visible to a given operating unit or responsibility.

Related Objects

• JTF_AUTH_DOMAINS_B — the base table; join on DOMAIN_DESC_ID. This is the primary parent and the source of the domain identity.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for row-level security.
• JTF_AUTH_DOMAINS_B.DOMAIN_DESC_ID — documented as referencing this table, confirming the tight parent/child relationship.
• JTF_AUTH_DOMAIN_MEMBERS and related JTF authorization objects — depend indirectly on the domain description resolved here for display in CRM Foundation security administration.
• JTF_AUTH_DOMAINS_VL — the typical MLS view that hides the language join and is used by forms and APIs.

Because this is a pure satellite, direct DML is rarely performed; translations are maintained through the CRM Foundation MLS mechanisms and read through the base/translation join or the VL view.