Search Results amv_i_perspectives_b




Overview
Explore in AI Chat

Overview

AMV_I_PERSPECTIVES_B is the base table of the Marketing Encyclopedia System (AMV) module in Oracle E-Business Suite, holding the master definitions of perspectives — reusable attribute groupings that describe how an item or a channel may be viewed, classified, or presented within the marketing encyclopedia. Because a perspective can be applied to either an item or a channel, the table functions as a shared reference set rather than a transaction table, and its rows are created and maintained as setup data by marketing administrators.

Under the heuristic Data Vault classification mined from the foreign key structure, AMV_I_PERSPECTIVES_B is identified as standalone — that is, it neither references other hubs nor is referenced through modeled FK constraints, other than the security group linkage. The accompanying unique index AMV_I_PERSPECTIVES_B_U1 (PERSPECTIVE_ID, ZD_EDITION_NAME) indicates that the table is edition-aware, a pattern consistent with multi-tenant or editioning deployments in R12.2.x environments. In a Data Vault model, this table would most naturally be treated as a hub-like reference entity keyed by PERSPECTIVE_ID, with descriptive attributes carried in a satellite; however, because it also carries edition and security attributes inline, it may alternatively be modeled as a standalone reference dimension.

Key Information Stored

The documented physical schema for ETRM 12.2.2 contains nine columns in the AMV schema. The most significant of these are:

  • PERSPECTIVE_ID — the surrogate primary key, uniquely identifying each perspective; it also anchors the unique index U1.
  • ZD_EDITION_NAME — the edition identifier. Combined with PERSPECTIVE_ID in U1, it forms the effective business-key candidate, enabling edition-scoped lookups.
  • SECURITY_GROUP_ID — the foreign key referencing FND_SECURITY_GROUPS, used to resolve the security context under which the perspective is visible.
  • OBJECT_VERSION_NUMBER — the standard EBS optimistic locking column, incremented on each update to detect concurrent modifications.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard audit trail capturing when the row was last modified, by which application user, and from which login session.
  • CREATION_DATE, CREATED_BY — the creation audit pair recording the originating timestamp and responsible user.

The table therefore holds only identity and control information; the descriptive perspective attributes that users associate with items and channels are stored in related AMV tables keyed by PERSPECTIVE_ID.

Common Use Cases and Queries

Typical usage centers on resolving which perspectives exist for a given security group and edition, then joining outward to detail tables. A representative query for edition-scoped perspective listing is:

  • SELECT p.perspective_id, p.zd_edition_name, p.security_group_id, p.creation_date FROM amv.amv_i_perspectives_b p WHERE p.zd_edition_name = :edition AND p.security_group_id = :group ORDER BY p.perspective_id;
  • Audit reporting: query rows where LAST_UPDATE_DATE falls within a date range to surface recent perspective setup changes, joined to FND_USER on LAST_UPDATED_BY / CREATED_BY.
  • Concurrency diagnostics: inspecting OBJECT_VERSION_NUMBER values to confirm whether a transaction updated the perspective row as expected.
  • Data-migration validation: comparing PERSPECTIVE_ID populations between environments using the U1 key to detect gaps or duplicates.

Because the table is a base table, direct DML is not recommended; maintenance should proceed through the Marketing Encyclopedia System concurrent programs and UI.

Related Objects

The relationship data documents a single outbound foreign key. The most significant related objects are:

  • FND_SECURITY_GROUPS — referenced by AMV_I_PERSPECTIVES_B.SECURITY_GROUP_ID; join on SECURITY_GROUP_ID to resolve the security group name and context.
  • AMV_I_PERSPECTIVES_B_PK — the primary key constraint/index on PERSPECTIVE_ID.
  • AMV_I_PERSPECTIVES_B_U1 — the unique business-key index on (PERSPECTIVE_ID, ZD_EDITION_NAME).
  • AMV_I_PERSPECTIVES_TL — the translation table that carries perspective names and descriptions in multiple languages, joined on PERSPECTIVE_ID.
  • AMV_I_ITEM_PERSPECTIVES / AMV_I_CHANNEL_PERSPECTIVES — association tables that attach perspectives to items and channels respectively, joined to this table on PERSPECTIVE_ID.
  • FND_USER — joined on CREATED_BY and LAST_UPDATED_BY for audit reporting.

Together these objects form the perspective framework within the Marketing Encyclopedia System, with AMV_I_PERSPECTIVES_B acting as the central identity record for each perspective definition.