Results for “can_view_flag”

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

Overview

The table AMV.AMV_U_EXT_SUBSCRIPTIONS is a core transactional object within the Oracle E-Business Suite Marketing Encyclopedia System (product code AMV). It stores the subscriptions created by external users for channels and categories managed by the Marketing Encyclopedia. In practice, this table records which external (self-service) users have elected to follow, receive, or access specific content channels or category nodes, together with the permissions they hold against that subscribed content. It is therefore the authoritative source for external-user subscription entitlement and access control within AMV.

The object is documented as a physical table in both Release 12.1.1 and 12.2.2, owned by the AMV schema, with a VALID status and a physical column count of 17. The ETRM metadata provides a heuristic Data Vault classification of link. Under that modeling suggestion, AMV_U_EXT_SUBSCRIPTIONS functions as an associative (many-to-many) construct that resolves relationships between external users and the channels or categories to which they subscribe, with descriptive permission attributes attached to each association. It is not classified as a hub or satellite, because it exists primarily to connect two independent entities through a subscription event.

Key Information Stored

The table is defined by a surrogate primary key and a small number of business-key and foreign-key columns, supported by descriptive and audit attributes. The most significant columns are:

• SUBSCRIPTION_ID — the surrogate primary key, enforced by the unique index AMV_U_EXT_SUBSCRIPTIONS_PK and also AMV_U_EXT_SUBSCRIPTIONS_U1.
• USER_ID — identifies the subscribing external user; a foreign key to FND_USER and part of the composite unique index AMV_U_EXT_SUBSCRIPTIONS_U2.
• SUBSCRIBING_TO_ID — the identifier of the subscribed channel or category; also part of the U2 unique index.
• SUBSCRIBING_TO_TYPE — discriminates the target of the subscription, distinguishing whether SUBSCRIBING_TO_ID resolves to a channel or a category; it completes the U2 unique index alongside USER_ID and SUBSCRIBING_TO_ID.
• SUBSCRIPTION_START_DATE and SUBSCRIPTION_END_DATE — define the effective validity window of the subscription, supporting date-based access and expiry reporting.
• CAN_VIEW_FLAG, CAN_CREATE_FLAG, CAN_DELETE_FLAG, CAN_UPDATE_FLAG — a set of permission attributes granting the external user view, create, delete, and update rights against the subscribed object.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS, supporting multi-organization and security-group data partitioning typical of EBS.
• OBJECT_VERSION_NUMBER — the optimistic-locking column, accompanied by the standard audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

The surrogate key, SUBSCRIPTION_ID, is distinct from the business-key candidate defined by U2 (USER_ID, SUBSCRIBING_TO_ID, SUBSCRIBING_TO_TYPE), which prevents a user holding duplicate subscriptions to the same channel or category.

Common Use Cases and Queries

Typical reporting requires resolving the subscription to its subscribing user and target channel or category. A join pattern leveraging the documented foreign keys is:

• List active subscriptions for a user: join AMV_U_EXT_SUBSCRIPTIONS to FND_USER on USER_ID, filtering on SUBSCRIPTION_START_DATE and SUBSCRIPTION_END_DATE, and on the CAN_VIEW_FLAG permission.
• Report channel subscribers: join SUBSCRIBING_TO_ID to AMV_C_CHANNELS_B where SUBSCRIBING_TO_TYPE indicates a channel, aggregating subscriber counts.
• Report category subscribers: join SUBSCRIBING_TO_ID to AMV_C_CATEGORIES_B where SUBSCRIBING_TO_TYPE indicates a category.
• Detect duplicate subscriptions: group by USER_ID, SUBSCRIBING_TO_ID, and SUBSCRIBING_TO_TYPE and flag counts greater than one, since U2 should enforce uniqueness.
• Audit permission grants: filter on combinations of CAN_CREATE_FLAG, CAN_DELETE_FLAG, and CAN_UPDATE_FLAG to identify users with elevated rights.

Related Objects

The following objects are most significant to this table, based on the documented primary-key and foreign-key relationships:

• AMV_C_CHANNELS_B — referenced via SUBSCRIBING_TO_ID for channel subscriptions.
• AMV_C_CATEGORIES_B — referenced via SUBSCRIBING_TO_ID for category subscriptions.
• FND_USER — referenced via USER_ID to identify the subscribing external user.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for security-group partitioning.
• AMV_U_EXT_SUBSCRIPTIONS_PK / _U1 / _U2 — the unique indexes enforcing the primary key and business-key uniqueness.