Search Results sy_text_tkn_tl




Overview
Explore in AI Chat

Overview

The SY_TEXT_TKN_TL table is a core data object within the Oracle Process Manufacturing (OPM) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Owned by the GMA (Process Manufacturing Systems) schema, it functions as a translation table (indicated by the "_TL" suffix) for text token definitions. Its primary role is to store language-specific textual content for predefined tokens or keys used throughout the OPM application. This enables the system to support multiple languages by maintaining translated versions of static text elements, labels, and messages, thereby facilitating international deployments and user localization.

Key Information Stored

The table stores the translated text associated with unique token identifiers. Its structure, as indicated by the primary and foreign key metadata, centers on a composite key and language information. The most critical columns include TEXT_KEY, which holds the unique identifier for a specific text token, and TEXT_CODE, which acts as a foreign key linking to the header table (SY_TEXT_HDR). The language-specific data is managed through LANG_CODE and LANGUAGE columns, which define the language of the stored translation. The table's primary purpose is to hold the actual translated string corresponding to the combination of TEXT_KEY and LANGUAGE.

Common Use Cases and Queries

The primary use case is retrieving application labels or messages in a user's preferred language for OPM forms, reports, and interfaces. A common query pattern involves joining SY_TEXT_TKN_TL with its header table to fetch all translations for a specific text code or to get a specific translation for a user session. For example, to retrieve all French translations for a set of tokens, a developer might use a query such as: SELECT t.text_key, t.text_code, tl.translated_text FROM sy_text_tkn t, sy_text_tkn_tl tl WHERE t.text_code = tl.text_code AND tl.lang_code = 'F'. This table is also critical for any custom reporting that must present OPM data with localized column headers or descriptive text.

Related Objects

SY_TEXT_TKN_TL has a direct and integral relationship with the SY_TEXT_HDR table, as defined by its foreign key on the TEXT_CODE column. This relationship suggests a master-detail structure where SY_TEXT_HDR contains the base definition of text tokens, and SY_TEXT_TKN_TL holds their multilingual translations. As a foundational translation table for the GMA module, it is referenced by various OPM forms, application program interfaces (APIs), and potentially by other tables or views that require localized text lookups. Its function is analogous to other EBS translation tables (like FND_DESCRIPTIVE_FLEXS_TL) but is specific to the Process Manufacturing domain.