Results for “ams_media_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The AMS_MEDIA_TL table resides in the AMS (Marketing) schema of Oracle E-Business Suite and stores all translated columns for the media entity used throughout the Oracle Marketing module. In Oracle EBS, media represent the channels through which marketing campaigns and activities are delivered — for example print publications, broadcast outlets, web portals, or other advertising vehicles. Because media names and descriptions must be presented in multiple languages for global deployments, the translatable attributes are separated into this translation table (the "_TL" suffix denotes a translation table) while language-independent attributes remain in the base table AMS_MEDIA_B.

The table follows the standard Oracle EBS multilingual architecture: each translatable row is keyed by the combination of the entity identifier and the language code, with a SOURCE_LANG column indicating the base language from which translations were derived. Under the heuristic Data Vault classification supplied in the metadata, AMS_MEDIA_TL is described as satellite-leaning. In Data Vault modeling terms, this suggests treating the table as a satellite structure attached to a hub or link keyed by MEDIA_ID, holding descriptive, language-dependent attributes with change history. This classification should be regarded as a modeling suggestion rather than a physical constraint.

Key Information Stored

The table contains twelve documented columns. The most significant are:

• MEDIA_ID — Surrogate identifier for the media entity. This column forms part of the composite primary key AMS_MEDIA_TL_PK and is the foreign key linking back to AMS_MEDIA_B.
• LANGUAGE — The language code for the translated row; the second component of the primary key.
• MEDIA_NAME — The translated name of the media, a core business-facing attribute.
• DESCRIPTION — The translated long description of the media.
• SOURCE_LANG — Identifies the source language of the row, supporting the language-derivation logic used by the translation framework.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, used to partition data by security group for multi-organization access control.
• ZD_EDITION_NAME — Editioning column introduced in the 12.2 online patching architecture; it participates in both unique indexes.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide standard EBS who-column auditing.

Two unique indexes act as business-key candidates. AMS_MEDIA_TL_U1 covers (MEDIA_ID, LANGUAGE, ZD_EDITION_NAME), while AMS_MEDIA_TL_U2 covers (LANGUAGE, MEDIA_NAME, ZD_EDITION_NAME), enforcing uniqueness of the media name within a language per edition.

Common Use Cases and Queries

The most frequent access pattern is joining the translation table to the base table to retrieve media names in the user's session language:

• Reporting on available marketing media by language, selecting MEDIA_NAME and DESCRIPTION filtered by a specific LANGUAGE value.
• Identifying media records that lack a translation for a required language by comparing the base table against AMS_MEDIA_TL.
• Auditing translation maintenance activity using CREATED_BY, LAST_UPDATED_BY, and their associated date columns.
• Language fallback queries that use SOURCE_LANG to display the base-language value when a localized row is absent.

A representative query joins AMS_MEDIA_B to AMS_MEDIA_TL on MEDIA_ID and filters by LANGUAGE and, in 12.2 environments, by ZD_EDITION_NAME to restrict to the run edition.

Related Objects

• AMS_MEDIA_B — The base (non-translated) media table; joined via MEDIA_ID and the parent of the foreign key relationship.
• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID to enforce security group partitioning.
• FND_LANGUAGES — Supplies the installed language definitions used to interpret the LANGUAGE column.
• AMS_MEDIA_TL_PK — The primary key constraint (MEDIA_ID, LANGUAGE) that governs row uniqueness.
• AMS_MEDIA_TL_U1 and AMS_MEDIA_TL_U2 — Unique indexes serving as business-key candidates for media name and ID lookups.
• AMS_CAMPAIGNS_ALL / AMS_ACTIVITIES_ALL — Marketing entities that reference media during campaign and activity setup.