Results for “action_param_code_meaning”

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

Overview

AMS_CLIK_THRU_ACT_PARAMS_TL is a translation table within the Oracle Marketing (AMS) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the repository for translated metadata that describes Click Thru Action Parameters — the configurable attributes attached to click-through actions used in marketing campaigns, one-to-one marketing executions, and interactive web activities. The "_TL" suffix is the standard Oracle convention for a translation (language) table: it stores language-dependent descriptive text for a base ("_B") entity row. The base table, AMS_CLIK_THRU_ACT_PARAMS_B, holds the language-independent definition of each action parameter, while this table stores the human-readable text associated with each parameter in each installed language. The table resides in the AMS schema and is classified as VALID.

From a Data Vault modeling perspective, the FK structure mined from the documentation suggests a satellite-leaning classification. The presence of a foreign key from ACTION_PARAM_ID back to AMS_CLIK_THRU_ACT_PARAMS_B, combined with the composite primary key of ACTION_PARAM_ID and LANGUAGE, is consistent with a descriptive satellite attached to a hub-style parent. This is a heuristic suggestion only; in the delivered EBS data model the object is a straightforward translation table.

Key Information Stored

The table contains 12 documented columns. The most significant are grouped below.

• ACTION_PARAM_ID — Surrogate identifier of the parent click-through action parameter. This participates in the primary key and is also the foreign key to AMS_CLIK_THRU_ACT_PARAMS_B.
• LANGUAGE — The installed language code for the translated row (for example, US for American English, or a language such as FR or DE). Along with ACTION_PARAM_ID, it forms the primary key AMS_CLIK_THRU_ACT_PARAMS_TL_PK.
• SOURCE_LANG — The language in which the source text was originally authored, used by the translation framework to track the origin of the text.
• ACTION_PARAM_CODE_MEANING — The translated meaning or display label of the action parameter code shown to end users.
• DESCRIPTION — The translated long description of the action parameter.
• ZD_EDITION_NAME — Editioning column introduced for Online Patching in EBS 12.2.x; it participates in the unique index AMS_CLIK_THRU_ACT_PARAMS_TL_U1.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting the Multi-Organization Access Control (MOAC) security model.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN record standard "Who" audit information for each row.

The surrogate primary key is the composite (ACTION_PARAM_ID, LANGUAGE). The unique index AMS_CLIK_THRU_ACT_PARAMS_TL_U1 on (ACTION_PARAM_ID, LANGUAGE, ZD_EDITION_NAME) is the business-key candidate that enforces one translated row per parameter per language per edition, which is required for 12.2.x online patching.

Common Use Cases and Queries

Report developers joining action parameter definitions to their translations use this table to display localized labels. A typical pattern joins the base table to the translation table filtered on the runtime language:

• Retrieve translated labels for a given parameter code.
• Identify parameters that have no translation for an installed language.
• Audit which parameters were translated in a given source language.
• Report on security group partitioning of translated parameter metadata.

A representative query pattern is: select the code meaning and description from AMS_CLIK_THRU_ACT_PARAMS_TL where ACTION_PARAM_ID equals a supplied identifier and LANGUAGE equals the session language, joining to AMS_CLIK_THRU_ACT_PARAMS_B on ACTION_PARAM_ID to retrieve language-independent attributes. For 12.2.x reporting, add ZD_EDITION_NAME = 'ORA$BASE' to restrict results to the run edition. Translation completeness checks typically use a left outer join from the base table to the translation table and filter where the translation key is null.

Related Objects

The most significant related objects, based on the documented relationships, are:

• AMS_CLIK_THRU_ACT_PARAMS_B — The base table holding language-independent parameter metadata. Joined on ACTION_PARAM_ID via the foreign key AMS_CLIK_THRU_ACT_PARAMS_TL.ACTION_PARAM_ID → AMS_CLIK_THRU_ACT_PARAMS_B.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID, providing the security group definition used for MOAC row filtering.
• FND_LANGUAGES — The standard language reference table used to validate and display the LANGUAGE and SOURCE_LANG values, though not listed as an explicit FK in the metadata.
• AMS_CLIK_THRU_ACT_PARAMS_TL_PK — The primary key constraint enforcing uniqueness of (ACTION_PARAM_ID, LANGUAGE).
• AMS_CLIK_THRU_ACT_PARAMS_TL_U1 — The unique index on (ACTION_PARAM_ID, LANGUAGE, ZD_EDITION_NAME) supporting edition-aware access.

These relationships make this table a dependent satellite of the base action parameter entity and a participant in the standard EBS language and security frameworks.