Search Results ams_metrics_all_tl




Overview
Explore in AI Chat

Overview

The AMS_METRICS_ALL_TL table is a core data object within the Oracle E-Business Suite Marketing (AMS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual descriptions for flexible marketing metrics. This table is essential for enabling global deployments of Oracle EBS, as it allows metric definitions, names, and other descriptive attributes to be presented in a user's native language. It operates in conjunction with its base table, AMS_METRICS_ALL_B, which holds the language-independent, transactional data. The existence of this "_TL" (Translation) table is a standard Oracle application architecture pattern for supporting multiple languages within a single installation.

Key Information Stored

The table's primary purpose is to store translated text columns associated with a specific metric definition. Its structure is defined by a composite primary key consisting of METRIC_ID and LANGUAGE. The METRIC_ID column is a foreign key that uniquely links each translated record to its corresponding master record in the AMS_METRICS_ALL_B table. The LANGUAGE column holds the language code (e.g., 'US' for American English, 'KO' for Korean) for the translation. While the specific translated column names are not detailed in the provided metadata, typical "_TL" tables in Oracle EBS contain columns such as METRIC_NAME, DESCRIPTION, and SOURCE_LANG. These columns hold the translated text and a marker for the source language of the original data, respectively.

Common Use Cases and Queries

This table is primarily accessed by the Oracle Applications framework to dynamically serve translated content to users based on their session language settings. Common practical scenarios include generating localized reports, configuring multilingual dashboards within the Marketing module, and ensuring user interfaces display metric labels correctly. A typical query to retrieve translated metric information for a specific language would join this table with its base table. For example, to fetch active metric names in French, a developer might use:

  • SELECT b.METRIC_CODE, tl.METRIC_NAME
  • FROM AMS_METRICS_ALL_B b, AMS_METRICS_ALL_TL tl
  • WHERE b.METRIC_ID = tl.METRIC_ID
  • AND tl.LANGUAGE = 'F'
  • AND b.ENABLED_FLAG = 'Y';

Reporting and data extraction scripts must always include a filter on the LANGUAGE column or use the NLS-aware application views to ensure accurate, single-language results.

Related Objects

The AMS_METRICS_ALL_TL table has a direct and critical relationship with several other key objects in the AMS schema. Its primary foreign key constraint links it to the AMS_METRICS_ALL_B table via the METRIC_ID column, establishing a master-detail relationship. For most application development and reporting purposes, developers should query the corresponding application view, which is typically named AMS_METRICS_ALL_VL (where 'VL' stands for View, Localized). This view performs the necessary join between the '_B' and '_TL' tables and automatically filters translations based on the user's session language, providing a safer and more efficient access layer. The table is also integral to the underlying APIs and packages within the Marketing module that create, update, and manage metric definitions in a multilingual environment.