Results for “event_offer_name”

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

Overview

The AMS.AMS_EVENT_OFFERS_ALL_TL table is a translation (TL) table within the Oracle Marketing (AMS) module of Oracle E-Business Suite. It stores all translated (multi-language) columns for event offer records maintained in the base table AMS_EVENT_OFFERS_ALL_B. In Oracle EBS, TL tables follow a standard pattern in which language-neutral or language-independent attributes reside in a "_B" table, while user-facing descriptive text is stored, one row per installed language, in the corresponding "_TL" table. This design enables multi-lingual deployments in which the same event offer can carry distinct name, description, and marketing text in each supported language.

From a Data Vault modeling perspective, the mined foreign key structure suggests this object is satellite-leaning: it hangs off the base entity AMS_EVENT_OFFERS_ALL_B via the EVENT_OFFER_ID foreign key, capturing descriptive, time-variant attributes rather than introducing new business relationships. It should therefore be modeled as a satellite attached to the event offer hub/link derived from the "_B" table, with LANGUAGE contributing to the satellite's composite key.

Key Information Stored

The table is documented with 12 physical columns. The most significant are:

• EVENT_OFFER_ID — Surrogate identifier of the parent event offer; part of the composite primary key and the FK to AMS_EVENT_OFFERS_ALL_B.
• LANGUAGE — The language code for the translated text; the second component of the composite primary key.
• SOURCE_LANG — Indicates the source language from which the translation was derived (the base language of the record).
• EVENT_OFFER_NAME — The translated display name of the event offer.
• DESCRIPTION — The translated long description.
• EVENT_MKTG_MESSAGE — The translated marketing message presented with the event offer.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling multi-org/security-group access to the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO-column audit attributes tracking creation and modification.

The surrogate primary key is AMS_EVENT_OFFERS_ALL_TL_PK (EVENT_OFFER_ID, LANGUAGE). A unique index, AMS_EVENT_OFFERS_ALL_TL_U1 (EVENT_OFFER_ID, LANGUAGE), mirrors this and confirms the business-key candidate: for a given event offer, exactly one row exists per language.

Common Use Cases and Queries

Typical reporting and integration scenarios include:

• Resolving translated offer text — joining the base entity to the TL table filtered by the session or reporting language:

  SELECT b.event_offer_id, t.event_offer_name, t.description
  FROM   ams_event_offers_all_b b,
         ams_event_offers_all_tl t
  WHERE  b.event_offer_id = t.event_offer_id
  AND    t.language = USERENV('LANG');

• Translation completeness audits — identifying offers lacking text in a required language by comparing base rows against TL rows per LANGUAGE.
• Security-group scoped extracts — filtering on SECURITY_GROUP_ID to produce language-specific offer catalogs for a given operating unit.
• Marketing content reporting — extracting EVENT_MKTG_MESSAGE for campaign and offer collateral review.

Related Objects

• AMS.AMS_EVENT_OFFERS_ALL_B — base table; joined via EVENT_OFFER_ID. Supplies language-independent attributes.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for row-level security.
• AMS_EVENT_OFFERS_ALL_TL_PK — the primary key constraint enforcing uniqueness of (EVENT_OFFER_ID, LANGUAGE).
• AMS_EVENT_OFFERS_ALL_TL_U1 — unique index supporting the business key.
• AMS_EVENT_OFFERS_ALL_VL — the common view pattern unioning base and translated columns for user-facing queries.
• Standard EBS concurrency/audit programs and the FND_LANGUAGES table, which governs valid LANGUAGE values.