Results for “ams_clik_thru_actions_tl”

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

Overview

AMS_CLIK_THRU_ACTIONS_TL is the translation (TL) companion table in the Oracle Marketing (AMS) module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It serves as the repository for translated metadata describing Click Thru Actions — the interactive actions launched when a recipient clicks a tracked link within a marketing campaign, event, or one-to-one marketing deliverable. Because marketing content is frequently deployed across multiple languages, Oracle EBS separates language-independent attributes into the base table AMS_CLIK_THRU_ACTIONS_B and stores the language-dependent descriptive text in this _TL table, one row per installed language per action.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table hangs directly off the base entity AMS_CLIK_THRU_ACTIONS_B through ACTION_ID, carrying descriptive and linguistic attributes rather than acting as an independent hub or a many-to-many link. This is consistent with the standard Oracle EBS _TL pattern, where the _B table acts as the durable business key holder and the _TL table records translated context keyed by language.

Key Information Stored

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

• ACTION_ID — Surrogate identifier linking the translation row to its parent in AMS_CLIK_THRU_ACTIONS_B; part of the composite primary key.
• LANGUAGE — The NLS language code for the translated text; the second component of the primary key and the unique index.
• ACTION_CODE_MEANING — The translated meaning/display label for the click-through action code, presented to end users in the selected language.
• DESCRIPTION — The translated long description of the action, used in setup and reporting screens.
• SOURCE_LANG — The language in which the row was originally authored, supporting the translation workflow.
• ZD_EDITION_NAME — Editioning column introduced in 12.2.x for online patching (Edition-Based Redefinition); it is included in the unique index AMS_CLIK_THRU_ACTIONS_TL_U1.
• SECURITY_GROUP_ID — Multi-org security grouping, with a foreign key to FND_SECURITY_GROUPS.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard audit trail columns tracking who created and last modified each translation row.

The primary key is AMS_CLIK_THRU_ACTIONS_TL_PK (ACTION_ID, LANGUAGE). The unique index AMS_CLIK_THRU_ACTIONS_TL_U1 (ACTION_ID, LANGUAGE, ZD_EDITION_NAME) serves as the business-key candidate and accommodates editioning in 12.2.x environments.

Common Use Cases and Queries

Typical uses include:

• Retrieving translated action labels for a marketing execution in a user's session language.
• Auditing which click-through actions have translations missing for a target language.
• Administration of multi-language campaign setup through the Marketing responsibility.

Sample query joining base and translation, filtered by language with a fallback to the source language:

SELECT b.action_id, t.language, t.action_code_meaning, t.description
FROM ams.ams_clik_thru_actions_b b, ams.ams_clik_thru_actions_tl t
WHERE b.action_id = t.action_id
AND t.language = USERENV('LANG');

Coverage check for missing translations:

SELECT b.action_id FROM ams.ams_clik_thru_actions_b b
WHERE NOT EXISTS (SELECT 1 FROM ams.ams_clik_thru_actions_tl t
WHERE t.action_id = b.action_id AND t.language = 'FR');

Related Objects

• AMS_CLIK_THRU_ACTIONS_B — Base table; join on ACTION_ID.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for multi-org security.
• FND_LANGUAGES — Provides installed languages validated against LANGUAGE.
• FND_APPLICATION / FND_TERRITORIES — Supporting NLS lookups.
• AMS_CLIK_THRU_ACTIONS_TL_PK / AMS_CLIK_THRU_ACTIONS_TL_U1 — Primary key and unique index enforcing row identity and translation uniqueness.