Search Results ams_deliverables_all_tl




Overview
Explore in AI Chat

Overview

The AMS_DELIVERABLES_ALL_TL table is a core translation table within the Oracle E-Business Suite Marketing (AMS) module for versions 12.1.1 and 12.2.2. It implements the Oracle Applications' standard multilingual architecture for the marketing deliverable definition entity. Its primary role is to store language-specific translations for user-facing descriptive columns of a deliverable, enabling the application to display deliverable information in a user's preferred language. This table is essential for global deployments where marketing campaigns and deliverables must be managed and presented in multiple languages.

Key Information Stored

The table stores translated text for columns that require localization, typically from the base table AMS_DELIVERABLES_ALL_B. The structure is defined by a primary key combining a source record identifier and a language code, along with the translated columns themselves. Based on standard Oracle EBS translation table patterns and the provided metadata, the critical columns include:

  • DELIVERABLE_ID: The unique identifier linking the translation row to its corresponding master record in AMS_DELIVERABLES_ALL_B.
  • LANGUAGE: The ISO code for the language of the translated data (e.g., 'US' for American English).
  • SOURCE_LANG: A column (implied by standard TL table design) indicating the original language of the source data.
  • Translatable descriptive columns, which commonly include DELIVERABLE_NAME and DESCRIPTION.

Common Use Cases and Queries

This table is primarily accessed by the application's runtime to fetch deliverable information in a user's session language. For reporting and data extraction, queries must join to this table to retrieve the correct translations. A standard pattern is to filter by the user's language preference or to retrieve all translations for a specific deliverable.

Sample Query to Retrieve Translated Deliverable Details:
SELECT b.deliverable_id, tl.deliverable_name, tl.description
FROM ams_deliverables_all_b b,
ams_deliverables_all_tl tl
WHERE b.deliverable_id = tl.deliverable_id
AND tl.language = USERENV('LANG')
AND b.deliverable_id = :p_deliverable_id;

Use Case for Data Migration: When loading deliverable definitions, data must be populated into both the base (B) and translation (TL) tables. The TL table requires one row per supported language for each deliverable, often seeded from a master language record.

Related Objects

The table has a direct, documented relationship with the base table for marketing deliverables, as indicated by the foreign key constraint.

  • AMS_DELIVERABLES_ALL_B: This is the primary base table containing the non-translatable columns for a deliverable definition. The relationship is established via the foreign key where AMS_DELIVERABLES_ALL_TL.DELIVERABLE_ID references AMS_DELIVERABLES_ALL_B.DELIVERABLE_ID. All translations are child records of a single master row in this base table.

In application logic, this table is accessed via Oracle's standard Multi-Language Support (MLS) views, which typically have names like AMS_DELIVERABLES_ALL_VL (V for View, L for Language). These views automatically handle the join between the base and translation tables based on the session language.