Results for “ams_web_plce_mp_tl”

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

Overview

AMS_WEB_PLCE_MP_TL is the translation table for web placement marketing content within the Oracle Marketing (AMS) module in Oracle E-Business Suite 12.1.1 and 12.2.2. The suffix _TL follows the standard EBS multilingual naming convention, indicating that this table stores language-specific translated attributes for a base entity. Its companion base table, AMS_WEB_PLCE_MP_B, holds the language-independent definition of a placement, while AMS_WEB_PLCE_MP_TL holds the user-facing, translatable text associated with that placement for each installed language.

From a Data Vault modeling perspective, the mined classification for this object is satellite. This is a natural fit: the table has a composite primary key consisting of PLACEMENT_MP_ID and LANGUAGE, which together resolve to a single descriptive record per placement per language. The satellite suggestion reflects that translatable attributes (such as the placement title) are functionally dependent on both the parent placement entity and the language context, rather than representing an independent business entity or an association between two entities.

Key Information Stored

The table contains eleven columns. The most significant are described below.

• PLACEMENT_MP_ID — The surrogate foreign key that identifies the parent placement record in the base table. Together with LANGUAGE, it forms the primary key constraint AWPMT_PK as well as the unique index AMS_WEB_PLCE_MP_TL_U1.
• LANGUAGE — The language code for the translated row. This is the second component of the composite primary key and the discriminator that makes this a translation table.
• SOURCE_LANG — Identifies the language of the source text from which the translation was derived, supporting the standard EBS translation workflow where a base-language record is seeded and then translated into additional languages.
• PLACEMENT_MP_TITLE — The translated display title for the placement. This is the primary business-facing text attribute demonstrating the purpose of the _TL table.
• SECURITY_GROUP_ID — References FND_SECURITY_GROUPS and governs row-level access control. In AMS, security groups are commonly mapped to operating units or marketing organizations.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Framework (OAF) and concurrent programs to detect update conflicts.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns (the WHO columns) recording creation and modification context.

The distinguishing structural feature is the separation between the surrogate key (PLACEMENT_MP_ID, shared with the base table) and the composite unique index AMS_WEB_PLCE_MP_TL_U1, which enforces one row per placement per language and serves as the true business-key candidate for this translation table.

Common Use Cases and Queries

The most frequent use case is retrieving a placement title in a specific language. A typical query joins the translation table to the base table on PLACEMENT_MP_ID and filters by LANGUAGE, often using the NLS session language:

• Language-specific lookup — SELECT t.placement_mp_title FROM ams.ams_web_plce_mp_tl t WHERE t.placement_mp_id = :placement_mp_id AND t.language = USERENV('LANG');
• Multi-language reporting — Retrieve all translations for a placement (for example, to audit which languages have been populated) by removing the LANGUAGE filter and grouping by language.
• Missing-translation detection — Left-join the base table to this table and filter on LANGUAGE values of interest to identify placements lacking a translated title.
• Security-filtered extracts — Join SECURITY_GROUP_ID to FND_SECURITY_GROUPS to restrict translated content to the caller's permitted organizations.
• Change auditing — Query on LAST_UPDATE_DATE and LAST_UPDATED_BY to track recent translation edits during a localization project.

Related Objects

• AMS_WEB_PLCE_MP_B — The base table holding language-independent placement data. Join on PLACEMENT_MP_ID.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID; join on SECURITY_GROUP_ID to resolve organizational access.
• FND_LANGUAGES — Provides the meaning of LANGUAGE and SOURCE_LANG codes via LANGUAGE_CODE.
• FND_APPLICATION / FND_PRODUCT_INSTALLATIONS — Contextual references for AMS marketing configuration during diagnostics.

Because the table is classified as standalone in the data vault heuristic (no outgoing foreign keys other than security group), its principal dependency chain is a straightforward parent-child relationship with the base placement table, with translations filtered by the active language context.