Results for “act_script_used_by_id”

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

Overview

AMS_ACT_SCRIPTS is a table in the AMS (Marketing) schema of Oracle E-Business Suite, documented as VALID in both the 12.1.1 and 12.2.2 releases. It stores the scripts — both inbound and outbound — that are used by a marketing activity. In the Oracle Marketing module, scripts drive the interaction flow for campaign activities, such as call center telemarketing scripts or inbound response guidance presented to agents. The table therefore acts as the association layer between a marketing activity and the deployed script content it consumes.

The ETRM metadata's heuristic Data Vault classification for this object is link. This classification is consistent with the table's structure: AMS_ACT_SCRIPTS principally joins an activity context to a deployed script definition rather than carrying descriptive attribute payload for a single business entity. When modeling this object in a Data Vault context, it may be treated as a link table recording the relationship between activities, campaign usage context, and script versions.

Key Information Stored

The table contains 28 documented columns. The most significant are summarized below.

• ACTIVITY_SCRIPT_ID — The surrogate primary key, enforced by AMS_ACT_SCRIPTS_PK. It is also documented as the sole business-key candidate via unique index AMS_ACT_SCRIPTS_U1, meaning the unique identifier and the unique business key coincide here.
• ACT_SCRIPT_USED_BY_ID — Identifies the source entity that uses the script. Per the documented foreign keys, this column resolves to both AMS_CAMPAIGNS_ALL_B and AMS_CAMPAIGN_SCHEDULES, indicating the script may be attached at campaign or schedule granularity.
• ARC_ACT_SCRIPT_USED_BY — An "arc" (archive/architecture) companion column that disambiguates which parent table ACT_SCRIPT_USED_BY_ID refers to; a standard AMS pattern for polymorphic references.
• DSCRIPT_ID — Foreign key to IES_DEPLOYED_SCRIPTS, identifying the specific deployed script version used by the activity.
• ENABLED_FLAG — Indicates whether the script association is active for the activity.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS controlling row-level access.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Framework.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each row.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — The standard Oracle DFF (Descriptive Flexfield) column set for extensible, customer-defined attributes.

Common Use Cases and Queries

The principal use cases involve determining which scripts are attached to a given campaign or activity, reporting inbound versus outbound script coverage, and auditing script usage against deployed script versions.

To list all scripts for a campaign:

• SELECT a.ACTIVITY_SCRIPT_ID, a.DSCRIPT_ID, a.ENABLED_FLAG FROM AMS.AMS_ACT_SCRIPTS a WHERE a.ACT_SCRIPT_USED_BY_ID = :campaign_id AND a.ARC_ACT_SCRIPT_USED_BY = 'CAMP';

To join scripts to their deployed definitions:

• SELECT a.ACTIVITY_SCRIPT_ID, d.* FROM AMS.AMS_ACT_SCRIPTS a, IES.IES_DEPLOYED_SCRIPTS d WHERE a.DSCRIPT_ID = d.DSCRIPT_ID;

Because security is governed by SECURITY_GROUP_ID, operational queries should generally include a security predicate, or be executed through the application's secured views.

Related Objects

The following objects are documented as directly related to AMS_ACT_SCRIPTS.

• AMS_CAMPAIGNS_ALL_B — joined on AMS_ACT_SCRIPTS.ACT_SCRIPT_USED_BY_ID; the campaign base table.
• AMS_CAMPAIGN_SCHEDULES — joined on AMS_ACT_SCRIPTS.ACT_SCRIPT_USED_BY_ID; the alternate parent granularity.
• IES_DEPLOYED_SCRIPTS — joined on AMS_ACT_SCRIPTS.DSCRIPT_ID; the source of deployed script definitions.
• FND_SECURITY_GROUPS — joined on AMS_ACT_SCRIPTS.SECURITY_GROUP_ID; enforces row-level security.
• AMS_ACT_SCRIPTS_PK and AMS_ACT_SCRIPTS_U1 — the primary key constraint and unique index supporting retrieval by ACTIVITY_SCRIPT_ID.