Results for “amvi_b_pk”

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

Overview

The JTF.JTF_AMV_ITEMS_B table, owned by the JTF schema, is the master (base) table for the Oracle E-Business Suite Advanced Media/Attachment and Knowledge Management infrastructure. It stores the header-level definition of "items" — discrete content objects such as documents, deliverables, URLs, media files, and knowledge content — that are surfaced across Oracle applications including iStore, iSupport, Order Capture, and the HTML-based knowledge base. Each row represents a single content item in the base language, while translatable descriptive columns reside in the companion table JTF_AMV_ITEMS_TL.

In Oracle EBS 12.1.1 and 12.2.2, the physical definition is consistent: the table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and the primary key AMVI_B_PK (found via the user's search for amvi_b_pk) is a unique NORMAL index on ITEM_ID and ZD_EDITION_NAME in APPS_TS_TX_IDX. From a Data Vault modeling perspective, the metadata classifies this object as hub-leaning: ITEM_ID is a surrogate/business identifier around which numerous dependent tables cluster, making JTF_AMV_ITEMS_B a natural hub with linked satellites (the _TL translation table and authorization tables).

Key Information Stored

The table contains 42 documented columns. The most operationally significant include:

• ITEM_ID — surrogate identifier for the content item; the leading column of the AMVI_B_PK unique index.
• ZD_EDITION_NAME — edition discriminator used in the Online Patching (12.2) editions model; combined with ITEM_ID it forms the full unique business key AMVI_B_PK (ITEM_ID, ZD_EDITION_NAME).
• LANGUAGE_CODE — InterMedia language code governing the base row language; indexed by JTF_AMV_ITEMS_B_N2 and referencing FND_LANGUAGES.
• APPLICATION_ID — owning application, foreign key to FND_APPLICATION; indexed by N4.
• CONTENT_TYPE_ID — classification of the content (document, URL, etc.); foreign key to AMV_I_CONTENT_TYPES_B.
• STATUS_CODE — lifecycle status (e.g., published, draft); indexed by N1.
• OWNER_ID — owning party/record; indexed by N3.
• URL_STRING — the target URL for link-type items; used by the domain index JTF_AMV_ITEMS_URL_CTX.
• EFFECTIVE_START_DATE and EXPIRATION_DATE — validity window controlling item visibility.
• OBJECT_VERSION_NUMBER — optimistic locking column.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS for multi-org/security partitioning.
• ACCESS_NAME, DELIVERABLE_TYPE_CODE, APPLICABLE_TO_CODE — access naming and deliverable applicability controls, each independently indexed (N6, N7, N5).
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard EBS DFF descriptor columns.
• Standard WHO columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical reporting patterns join the base table to its translation table to retrieve language-specific titles and descriptions, and filter on status and validity:

• List active published items for an application:
  SELECT i.item_id, t.title FROM jtf.jtf_amv_items_b i, jtf.jtf_amv_items_tl t WHERE i.item_id = t.item_id AND i.status_code = 'PUBLISHED' AND i.application_id = :app AND SYSDATE BETWEEN i.effective_start_date AND NVL(i.expiration_date, SYSDATE+1);
• Retrieve URL-type content matching a domain index hit on URL_STRING via the JTF_AMV_ITEMS_URL_CTX domain index.
• Report items by owner or deliverable type using the N3 and N7 indexes for performance.
• Audit/edition queries filtering ZD_EDITION_NAME during 12.2 Online Patching cycles.
• KPI dashboards tracking content volume by content type (CONTENT_TYPE_ID) and language (LANGUAGE_CODE).

Related Objects

JTF_AMV_ITEMS_B is central to the AMV/DSP content model. Key related objects include:

• JTF_AMV_ITEMS_TL — translation (satellite) table joined on ITEM_ID, holding language-specific titles and text.
• JTF_AMV_ATTACHMENTS — attachments linked via ATTACHMENT_USED_BY_ID = ITEM_ID.
• JTF_AMV_ITEM_AUTHORS and JTF_AMV_ITEM_KEYWORDS — authorship and keyword metadata joined on ITEM_ID.
• AMV_I_ITEM_PERSPECTIVES — perspectives/relationships attached to items.
• AMV_I_CONTENT_TYPES_B — content type lookup referenced by CONTENT_TYPE_ID.
• JTF_DSP_CONTEXT_B and IBE_DSP_SECTIONS_B (via DELIVERABLE_ID) — publishing/deliverable structures consuming items.
• FND_LANGUAGES, FND_APPLICATION, and FND_SECURITY_GROUPS — reference lookups for LANGUAGE_CODE, APPLICATION_ID, and SECURITY_GROUP_ID respectively.
• APIs such as JTF_AMV_ITEMS_PKG and the AMV_* PL/SQL packages provide insert/update/query operations against this table from Oracle Content Manager and Knowledge Management flows.