Search Results ams_event_headers_all_tl_pk

Overview

The AMS_EVENT_HEADERS_ALL_TL table resides in the AMS (Oracle Marketing) schema and serves as the translation repository for marketing event header records. Its documented purpose is to store all translated (multi-language) columns associated with event headers defined in Oracle EBS. In a multilingual implementation, descriptive text such as event names, marketing messages, and descriptions must be presented in each installed language, and this table provides that language-specific storage layer, keyed by both the parent event header identifier and a LANGUAGE code.

The table is registered as VALID in Oracle EBS 12.1.1 and 12.2.2 and is classified under the AMS - Marketing product family. From a Data Vault modeling perspective, the mined FK structure suggests a satellite-leaning classification: the table carries descriptive, language-dependent attributes hanging off the parent business entity rather than defining new relationships. It should be understood as an attribute satellite of the AMS_EVENT_HEADERS_ALL_B hub-like parent, not as a hub or link in its own right.

Key Information Stored

The physical schema documents 12 columns. The most operationally significant are:

• EVENT_HEADER_ID – Surrogate/foreign key linking each translated row to its parent event header in AMS_EVENT_HEADERS_ALL_B. Part of the composite primary key.
• LANGUAGE – The language code governing the translated content of the row. Part of the composite primary key.
• EVENT_HEADER_NAME – The translated name of the marketing event header.
• EVENT_MKTG_MESSAGE – The translated marketing message associated with the event.
• DESCRIPTION – The translated descriptive text for the event header.
• SOURCE_LANG – Identifies the source language from which the translation was derived, supporting the language-overlay pattern used throughout EBS _TL tables.
• SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security-group access control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – Standard EBS WHO columns used for audit tracking and concurrency control.

The primary key is AMS_EVENT_HEADERS_ALL_TL_PK on (EVENT_HEADER_ID, LANGUAGE). The unique index AMS_EVENT_HEADERS_ALL_TL_U1 is documented on the same (EVENT_HEADER_ID, LANGUAGE) pair, confirming that pair as the business-key candidate. No separate single-column surrogate beyond EVENT_HEADER_ID is defined.

Common Use Cases and Queries

Typical usage centers on retrieving the translated descriptive content for a marketing event in the session language, or enumerating all available translations for reporting and content-review purposes.

• Fetching a single translation: SELECT event_header_name, event_mktg_message, description FROM ams_event_headers_all_tl WHERE event_header_id = :id AND language = USERENV('LANG');
• Listing all translations of one event: SELECT language, event_header_name FROM ams_event_headers_all_tl WHERE event_header_id = :id;
• Joining the base and translation tables: SELECT b.event_header_id, t.event_header_name FROM ams_event_headers_all_b b, ams_event_headers_all_tl t WHERE b.event_header_id = t.event_header_id AND t.language = 'US';
• Localization audits: identifying events whose descriptions are missing for a required language, or comparing SOURCE_LANG against LANGUAGE to track translation coverage.

Because SECURITY_GROUP_ID participates, queries run under a specific security context should filter or join against FND_SECURITY_GROUPS to remain consistent with EBS access policies.

Related Objects

• AMS_EVENT_HEADERS_ALL_B – Parent base table; joined on EVENT_HEADER_ID.
• FND_SECURITY_GROUPS – Referenced via SECURITY_GROUP_ID for access control.
• AMS_EVENT_HEADERS_ALL_VL – The translated view typically layered over the _B and _TL tables, presenting language-appropriate content.
• AMS_EVENT_HEADERS_ALL_TL indexes – AMS_EVENT_HEADERS_ALL_TL_PK and AMS_EVENT_HEADERS_ALL_TL_U1.
• FND_LANGUAGES – Provides the valid LANGUAGE values stored here.