Results for “placement_name”

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

Overview

AMS_WEB_PLACEMENTS_TL is the translation (TL) table for web placements in the Oracle Marketing (AMS) module, owned by the AMS schema. In Oracle EBS 12.1.1 and 12.2.2, R12 introduced the multilingual ("MLS") architecture in which a base (B) table holds language-independent attributes and one or more translation (TL) tables hold the language-dependent, user-entered descriptive text. This object stores the translated columns for web placements — the placement name and description as displayed in a given language.

The table is a standard MLS child. Its primary key, AWPT_PK, is a composite of PLACEMENT_ID and LANGUAGE, meaning there is exactly one translated row per placement per installed language. From a Data Vault modeling perspective, the metadata heuristic classifies AMS_WEB_PLACEMENTS_TL as satellite-leaning: it is a descriptive satellite hanging off the AMS_WEB_PLACEMENTS_B base table (its parent hub/entity), carrying language-qualified descriptive attributes rather than its own business identity. Treating it as a satellite keyed by (PLACEMENT_ID, LANGUAGE) is the natural reading of the FK structure.

Key Information Stored

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

• PLACEMENT_ID — Surrogate foreign key to AMS_WEB_PLACEMENTS_B. Together with LANGUAGE it forms the composite primary key AWPT_PK and identifies which web placement the translated row describes.
• LANGUAGE — The language code of the translated text (for example US, FR, DE). It is the second component of the primary key and enforces one row per language per placement.
• PLACEMENT_NAME — The translated display name of the placement. Because it participates in unique index AMS_WEB_PLACEMENTS_TL_U2 (PLACEMENT_NAME, LANGUAGE), it is a business-key candidate: placement names must be unique within a language.
• DESCRIPTION — The translated long description of the placement.
• SOURCE_LANG — The source language from which this translation was derived (the MLS "source language" column).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS "Who" audit columns recording the user, timestamp, and login session that created and last modified each translated row.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications Framework (OAF) and the marketing APIs to detect concurrent updates.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, used by the Marketing (AMS) security model for data/function access partitioning.

Note the distinct unique indexes: AMS_WEB_PLACEMENTS_TL_U1 (LANGUAGE, PLACEMENT_ID) supports the primary key, while AMS_WEB_PLACEMENTS_TL_U2 (PLACEMENT_NAME, LANGUAGE) enforces translated-name uniqueness. The surrogate key is the composite (PLACEMENT_ID, LANGUAGE); the business key candidate is (PLACEMENT_NAME, LANGUAGE).

Common Use Cases and Queries

The most frequent query pattern is a language-filtered join to the base table to retrieve names and descriptions for reporting on or extracting placement data used by web campaigns, banners, and interactive marketing offers.

• Retrieve a placement in a specific language: join AMS_WEB_PLACEMENTS_B b to AMS_WEB_PLACEMENTS_TL t on t.PLACEMENT_ID = b.PLACEMENT_ID and t.LANGUAGE = USERENV('LANG') (or an explicit language code such as 'US').
• Multilingual reporting: pivot across LANGUAGE to compare placement naming conventions across regions.
• Translation-gap auditing: left-join languages in FND_LANGUAGES against PLACEMENT_ID to detect placements lacking a translation for a given language.
• Security-scoped extraction: filter by SECURITY_GROUP_ID to comply with AMS data-access partitioning.

A representative statement is: SELECT t.PLACEMENT_NAME, t.DESCRIPTION FROM AMS.AMS_WEB_PLACEMENTS_TL t WHERE t.LANGUAGE = 'US' AND t.SECURITY_GROUP_ID = :p_security_group_id.

Related Objects

• AMS_WEB_PLACEMENTS_B — Base (language-independent) table; joined on PLACEMENT_ID. TL rows require a corresponding B row.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID; drives Marketing security partitioning.
• FND_LANGUAGES — Source of valid LANGUAGE codes for translation completeness checks.
• AMS_WEB_PLACEMENTS_VL — MLS view that presents base and translated columns together; typical reporting interface.
• AMS_WEB_PLACEMENTS_V / related AMS marketing views — convenience objects exposing placement data to campaigns and offers.
• AMS Campaign / Offer objects — Web placements are attached to campaigns and interactive offers, which read placement text through this table.
• AMS Web Placement public APIs — AMS_PLACEMENT APIs that insert, update, and translate placement records, enforcing OBJECT_VERSION_NUMBER and the Who columns.

Together these objects form the standard EBS MLS pair, with AMS_WEB_PLACEMENTS_TL providing the translatable text layer for web placements in Oracle Marketing.