Results for “jtf_dsp_msite_sct_items_u1”

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

Overview

JTF_DSP_MSITE_SCT_ITEMS is a CRM Foundation (JTF) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the association between mini-sites and section items. In the Oracle CRM self-service model, a mini-site represents a targeted, personalized web presence assembled from reusable content building blocks. Section items are those building blocks—individual content entries that logically belong to a section. This table resolves the many-to-many relationship between the two, recording exactly which section items appear on which mini-site.

From a Data Vault modeling perspective, the heuristic classification of this object is a link table. It does not carry descriptive attributes about either the mini-site or the section item itself; instead it captures the relationship between two business entities, supported by its foreign keys to JTF_MSITES_B and JTF_DSP_SECTION_ITEMS. Analysts building a dimensional or Data Vault layer should treat it as a link connecting two hubs, with the operational audit and date columns acting as satellite-style metadata.

Key Information Stored

The table contains twelve documented columns. The most significant are:

• MINI_SITE_SECTION_ITEM_ID — the surrogate primary key defined by constraint JTF_DSP_MSITE_SCT_ITEMS_PK. It uniquely identifies each mini-site/section-item association row.
• MINI_SITE_ID — foreign key to JTF_MSITES_B, identifying the mini-site to which the content is attached.
• SECTION_ITEM_ID — foreign key to JTF_DSP_SECTION_ITEMS, identifying the reusable content item being placed.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security-group access partitioning across the CRM content model.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date window during which the association is active. These are the columns that allow time-phased publication and retraction of content without deleting associations.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Applications Framework (OAF) to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns recording who created and last modified the association and when.

Two unique indexes exist. JTF_DSP_MSITE_SCT_ITEMS_U1 covers MINI_SITE_SECTION_ITEM_ID alone, serving as the business-key candidate aligned to the primary key. JTF_DSP_MSITE_SCT_ITEMS_U2 covers the composite (SECTION_ITEM_ID, MINI_SITE_ID), which is the true natural-key candidate: it guarantees that a given section item is associated with a given mini-site at most once.

Common Use Cases and Queries

The primary operational use case is rendering a mini-site: identifying which section items are currently published on a given mini-site, filtered by the active date window and security group.

• Resolving a mini-site's live content:

  SELECT msi.SECTION_ITEM_ID
  FROM   JTF.JTF_DSP_MSITE_SCT_ITEMS msi
  WHERE  msi.MINI_SITE_ID = :mini_site_id
  AND    TRUNC(SYSDATE) BETWEEN msi.START_DATE_ACTIVE
                            AND NVL(msi.END_DATE_ACTIVE, SYSDATE);

• Auditing content reuse: count how many mini-sites reference a section item to determine impact before retiring content.
• Reconciliation reporting: join to JTF_DSP_SECTION_ITEMS to confirm that every associated item still exists and is valid.
• Concurrent-update diagnostics: compare OBJECT_VERSION_NUMBER values across sessions when OAF raises "row has been modified" errors.

Related Objects

• JTF_MSITES_B — joined on MINI_SITE_ID; the mini-site header this table attaches content to.
• JTF_DSP_SECTION_ITEMS — joined on SECTION_ITEM_ID; the reusable content item definitions.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; enforces data access partitioning.
• JTF_DSP_MSITE_SCT_ITEMS_PK / JTF_DSP_MSITE_SCT_ITEMS_U1 / JTF_DSP_MSITE_SCT_ITEMS_U2 — the constraints and unique indexes that enforce integrity on the association rows.
• Mini-site and section-item OAF pages / JTF_DSP APIs — the CRM Foundation UI and programmatic interfaces that insert, update, and query these associations.