Results for “ams_clik_thru_act_params_b”

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

Overview

The AMS_CLIK_THRU_ACT_PARAMS_B table is a Marketing (AMS) module base table that stores metadata describing the parameters associated with Click Through Destination Actions. Within Oracle E-Business Suite 12.1.1 and 12.2.2, it functions as the master definition table for configurable parameters that determine how a user's click-through interaction is captured, routed, and recorded when an email campaign recipient acts on a link. Each row represents a distinct action parameter that can be attached to a marketing action, providing the structural attributes (such as tracking, enablement, and mandatory flags) that drive downstream execution and reporting.

From a Data Vault modeling perspective, the mined relationship structure classifies this table as hub-leaning. This is a heuristic suggestion: because the table carries a single surrogate primary key and serves as the referenced parent for multiple child tables, it behaves much like a hub of business keys, with descriptive attributes distributed to satellite-like child objects.

Key Information Stored

The table is defined with 17 documented columns. The most significant of these are summarized below.

• ACTION_PARAM_ID — Surrogate primary key (constraint AMS_CLIK_THRU_ACT_PARAMS_B_PK). Uniquely identifies each click-through action parameter record.
• ACTION_ID — Identifies the parent marketing action to which the parameter belongs.
• ACTION_CODE — Business-meaningful code describing the action type.
• ACTION_PARAM_CODE — The parameter's business code, used to distinguish parameter roles within an action.
• TRACK_FLAG — Indicates whether click-through activity for this parameter is tracked.
• ENABLED_FLAG — Controls whether the parameter is active and available for use.
• MANDATORY_FLAG — Specifies whether a value must be supplied for the parameter.
• ENCRYPT_FLAG — Determines whether the captured parameter value is subject to encryption.
• LOV — Stores the definition of the list of values used when a user selects this parameter.
• SECURITY_GROUP_ID — Enforces multi-org/security-group data partitioning; it carries a foreign key to FND_SECURITY_GROUPS.
• ZD_EDITION_NAME — The editioning column introduced for Online Patching (ADOP) in Release 12.2, used alongside the primary key in the unique index AMS_CLIK_THRU_ACT_PARAMS_B_U1 (ACTION_PARAM_ID, ZD_EDITION_NAME).

Standard EBS audit columns are also present: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER, which support concurrency control and change tracking.

Common Use Cases and Queries

The table is primarily consulted during campaign execution and configuration, particularly when determining how a click-through action should behave. Typical uses include validating which parameters are enabled or mandatory, driving form/list-of-values behavior at runtime, and auditing the tracking and encryption posture of an action. A representative query joining to the translation table is shown below:

• Lookup of enabled parameters for a given action: SELECT action_param_id, action_id, action_param_code, enabled_flag FROM ams.ams_clik_thru_act_params_b WHERE action_id = :action_id AND enabled_flag = 'Y';
• Retrieving translatable descriptions via a join to AMS_CLIK_THRU_ACT_PARAMS_TL on ACTION_PARAM_ID.
• Reporting on parameter value capture by joining to AMS_CTD_PARAM_VALUES on ACTION_PARAM_ID, useful for analytics on captured click-through data.
• Security partition queries filtering by SECURITY_GROUP_ID for multi-org access control.

In Release 12.2, queries should generally filter or be aware of ZD_EDITION_NAME to respect editioning semantics during online patching cycles.

Related Objects

The following objects are most closely related to AMS_CLIK_THRU_ACT_PARAMS_B through documented foreign key relationships.

• AMS_CLIK_THRU_ACT_PARAMS_TL — The translation (TL) table. Joins on ACTION_PARAM_ID; holds language-specific parameter text.
• AMS_CTD_PARAM_VALUES — Child table storing captured parameter values. Joins on ACTION_PARAM_ID.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for security partitioning of parameter records.

Together these objects form the metadata, translation, and value-capture boundary of the Click Through Destination Action Parameter feature within the Oracle Marketing module.