Search Results jtf_auth_domains_tl




Overview
Explore in AI Chat

Overview

The JTF_AUTH_DOMAINS_TL table is a core translation table within the Oracle E-Business Suite (EBS) CRM Foundation (JTF) module. It is a child table to the base table JTF_AUTH_DOMAINS_B, implementing the standard Oracle Applications Multi-Language Support (MLS) architecture. Its primary role is to store translated, language-specific descriptions for authorization domains, enabling the CRM application to present user-facing domain names and descriptions in the language of the user's session. This table is essential for the internationalization and localization of security and access control components within the EBS CRM framework.

Key Information Stored

As a translation table, JTF_AUTH_DOMAINS_TL stores the linguistic equivalents of the data held in its base table. Its structure is defined by a primary key and foreign key relationship, along with standard MLS columns. The most critical columns include:

  • DOMAIN_DESC_ID: The primary key column, which is also a foreign key referencing JTF_AUTH_DOMAINS_B.DOMAIN_DESC_ID. This column uniquely identifies the specific authorization domain description being translated.
  • LANGUAGE: A standard MLS column storing the language code (e.g., 'US' for American English, 'KO' for Korean) for the translated row.
  • SOURCE_LANG: A standard MLS column indicating the original language in which the data was entered.
  • DOMAIN_DESC: The translated, user-facing description of the authorization domain for the specified language.

Common Use Cases and Queries

This table is primarily accessed indirectly by the application's MLS engine to retrieve locale-appropriate text. Common operational and reporting scenarios include verifying translation completeness and querying domain descriptions for a specific language. A typical query to retrieve all translated domain descriptions for a French-language session would be:

SELECT b.DOMAIN_NAME, tl.DOMAIN_DESC
FROM JTF_AUTH_DOMAINS_B b, JTF_AUTH_DOMAINS_TL tl
WHERE b.DOMAIN_DESC_ID = tl.DOMAIN_DESC_ID
AND tl.LANGUAGE = userenv('LANG');

Administrators may also query to identify domains missing translations for a target language or to audit all available translations by joining to the FND_LANGUAGES table.

Related Objects

The JTF_AUTH_DOMAINS_TL table has a direct, documented dependency on the JTF_AUTH_DOMAINS_B base table. The relationship is enforced by a foreign key constraint where JTF_AUTH_DOMAINS_TL.DOMAIN_DESC_ID references JTF_AUTH_DOMAINS_B.DOMAIN_DESC_ID. This is a strict one-to-many relationship, where one row in the base table can have multiple corresponding translation rows in the TL table, one for each supported language. The table is integral to the CRM Foundation's security model and is referenced by any API or user interface component that displays authorization domain information in a multi-lingual context.