Search Results oe_transaction_types_tl

Overview

The OE_TRANSACTION_TYPES_TL table is a core multilingual support (MLS) table within the Oracle E-Business Suite (EBS) Order Management (ONT) module. Its primary role is to store translated, language-specific descriptions for the transaction types defined in the base table, OE_TRANSACTION_TYPES_ALL. This enables the Order Management application to display transaction type names and descriptions in the language of the user's session, supporting global deployments. The table is owned by the ONT schema and is valid for both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary key, which uniquely identifies each record through a combination of a transaction type identifier and a language code. The key columns and their relationships are as follows:

• TRANSACTION_TYPE_ID: This is the foreign key column linking directly to the OE_TRANSACTION_TYPES_ALL.TRANSACTION_TYPE_ID. It identifies the specific order transaction type for which the translation is provided.
• LANGUAGE: This column stores the language code (e.g., 'US' for American English, 'D' for German) and is a foreign key to the FND_LANGUAGES table, ensuring data integrity for supported application languages.
• NAME and DESCRIPTION: While not explicitly listed in the brief metadata, these are standard columns in Translation (TL) tables. They hold the translated, user-facing name and descriptive text for the transaction type in the specified LANGUAGE.

Common Use Cases and Queries

This table is essential for any reporting or data extraction that requires transaction type information in a specific language or across multiple languages. A common scenario is generating user-friendly order reports for international stakeholders. Developers also query this table when building custom interfaces or extensions that must respect the user's session language. A typical join to retrieve translated transaction type data would be:

• SELECT b.TRANSACTION_TYPE_ID, tl.NAME, tl.DESCRIPTION, tl.LANGUAGE
  FROM OE_TRANSACTION_TYPES_ALL b,
       OE_TRANSACTION_TYPES_TL tl
  WHERE b.TRANSACTION_TYPE_ID = tl.TRANSACTION_TYPE_ID
  AND tl.LANGUAGE = USERENV('LANG');

This query ensures the transaction type name and description are returned in the current application session's language.

Related Objects

OE_TRANSACTION_TYPES_TL has direct dependencies on two primary objects, as defined by its foreign keys:

• OE_TRANSACTION_TYPES_ALL: This is the base transactional table. The TL table exists solely to provide multilingual support for the records in this table. All transaction types must first be defined in OE_TRANSACTION_TYPES_ALL.
• FND_LANGUAGES: This Application Object Library (FND) table defines all languages installed and available within the EBS instance. The LANGUAGE column in OE_TRANSACTION_TYPES_TL is validated against this table.

In practice, application logic typically accesses this data through higher-level views or APIs, but the table itself is fundamental for storing the translated text.