Search Results amv_c_channels_b




Overview
Explore in AI Chat

Overview

AMV_C_CHANNELS_B is the base table of the Marketing Encyclopedia System (product code AMV) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the master definition of every channel that exists in the system. Within the ETRM (Electronic Technical Reference Manual) model, a channel is the central delivery and subscription construct for marketing content: it groups content types, item types, perspectives, keywords, and item-matching rules, and it governs who may publish to or subscribe to that content. The table resides in the AMV schema and is classified as VALID in the documented environment.

A heuristic Data Vault classification mined from the foreign-key structure identifies this object as hub-leaning. In Data Vault terms, AMV_C_CHANNELS_B behaves as a hub: its primary key, CHANNEL_ID, is a stable surrogate identifier that is referenced by many dependent tables, while descriptive and state-bearing attributes could be modeled as satellites. This classification is a modeling suggestion only and does not affect the physical implementation in EBS.

Key Information Stored

The documented physical schema contains 48 columns. The most significant are:

Standard EBS WHO columns (OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) and SECURITY_GROUP_ID are also present.

Common Use Cases and Queries

Channels are surfaced in the Marketing Encyclopedia System administration and self-service pages, so the table is queried for channel maintenance, subscription reporting, and access auditing. A typical lookup joins the base table to its translation table to obtain the displayed name:

  • List active channels with their translated names: SELECT b.channel_id, t.channel_name FROM amv_c_channels_b b, amv_c_channels_tl t WHERE b.channel_id = t.channel_id AND t.language = USERENV('LANG') AND b.status = 'ACTIVE'
  • Identify channels owned by a specific resource via OWNER_USER_ID joined to JTF_RS_RESOURCE_EXTNS.
  • Report channels nearing expiration using EXPIRATION_DATE against SYSDATE.
  • Audit external access by filtering on EXTERNAL_ACCESS_FLAG and ACCESS_LEVEL_TYPE.
  • Analyze matching configuration across channels by pivotting the MATCH_ON_* flags.

Related Objects

The following objects are the most significant dependents and references:

  • AMV_C_CHANNELS_TL — translation table joined on CHANNEL_ID; supplies language-specific channel names and descriptions.
  • AMV_C_CATEGORIES_B — referenced by CHANNEL_CATEGORY_ID.
  • JTF_RS_RESOURCE_EXTNS — referenced by OWNER_USER_ID and DEFAULT_APPROVER_USER_ID for owner and approver resolution.
  • FND_APPLICATION — referenced by APPLICATION_ID, scoping channels to a product application.
  • AMV_C_CHL_ITEM_MATCH and AMV_C_CHL_PERSPECTIVES — child tables keyed on CHANNEL_ID holding item-matching and perspective configuration.
  • AMV_C_CONTENT_TYPES, AMV_C_ITEM_TYPES, and AMV_C_KEYWORDS — child tables that associate content types, item types, and keywords with a channel.
  • AMV_U_MY_CHANNELS, AMV_U_EXT_SUBSCRIPTIONS, and AMV_U_ACCESS — self-service tables that record user subscriptions and access grants against the channel record.