Results for “amv_c_keywords_pk”

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

Overview

AMV_C_KEYWORDS is a table in the AMV (Marketing Encyclopedia System) product module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores all keywords associated with a specific channel that may be used as part of a matching criterion. In the Oracle Marketing and iStore context, channels represent groupings used to target, match, or route marketing content, and the keywords attached to each channel drive keyword-based matching logic. From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification, meaning the table primarily serves as a descriptive attribute container orbiting a parent hub-like entity (AMV_C_CHANNELS_B) rather than acting as an independent hub or an associative link.

Key Information Stored

The table contains 10 documented columns. The surrogate primary key is CHANNEL_KEYWORD_ID, defined by AMV_C_KEYWORDS_PK (and mirrored by unique index AMV_C_KEYWORDS_U1). The business-key candidate is the composite unique index AMV_C_KEYWORDS_UK1 / AMV_C_KEYWORDS_U2 on (CHANNEL_ID, KEYWORD), which enforces that a given keyword appears only once per channel.

• CHANNEL_KEYWORD_ID — Surrogate primary key uniquely identifying each keyword row.
• CHANNEL_ID — Foreign key to AMV_C_CHANNELS_B, tying the keyword to its parent channel.
• KEYWORD — The actual keyword text used in channel matching criteria.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling multi-org/security-group access.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF framework.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO columns capturing audit and user context.

Common Use Cases and Queries

Typical use cases include reporting on the keyword set assigned to each channel, validating that matching criteria are populated before campaign activation, and diagnosing why a channel fails to match intended content. A common query lists all keywords for a channel:

• SELECT k.keyword FROM amv.amv_c_keywords k WHERE k.channel_id = :channel_id;
• Joining to the channel base table to retrieve channel names alongside keywords: SELECT c.channel_id, c.name, k.keyword FROM amv.amv_c_keywords k JOIN amv.amv_c_channels_b c ON c.channel_id = k.channel_id;
• Identifying duplicate keyword assignments across channels via GROUP BY on KEYWORD.
• Security-group-filtered reporting for multi-org environments using SECURITY_GROUP_ID.

Related Objects

AMV_C_KEYWORDS depends on and is referenced by the following significant objects:

• AMV_C_CHANNELS_B — Parent table; joined via AMV_C_KEYWORDS.CHANNEL_ID = AMV_C_CHANNELS_B.CHANNEL_ID.
• AMV_C_CHANNELS_TL — Translated channel names for reporting.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for access control.
• FND_USER / FND_LOGINS — Implicitly referenced through the WHO columns (CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN).
• AMV channel and content matching APIs that consume keyword rows at runtime.

Together these objects support the marketing encyclopedia keyword matching framework, with AMV_C_KEYWORDS acting as the attribute satellite supplying match terms for each channel.