Results for “ibe_dsp_sections_b”

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

Overview

The IBE_DSP_SECTIONS_B table is a core configuration and catalog structure within the Oracle iStore (IBE) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It stores the master definition of display sections — the logical groupings used to organize products, categories, and content across an iStore storefront. Each row represents a section header that controls how merchandise and informational content are presented to end users, including placement rules, activation windows, and site availability.

From a Data Vault modeling perspective, the relationship metadata suggests this table functions as a hub. The surrogate primary key SECTION_ID is referenced by numerous dependent tables, while the table itself holds the descriptive attributes associated with each section identity. This classification is offered as a heuristic modeling suggestion rather than a formal designation.

Key Information Stored

The table contains 36 documented columns. The most significant include:

• SECTION_ID — Surrogate primary key (IBE_DSP_SECTIONS_B_PK) uniquely identifying each section.
• ACCESS_NAME — Business-key candidate; participates in the unique index IBE_DSP_SECTIONS_B_UK1 and provides a human-readable access identifier.
• ZD_EDITION_NAME — Part of the unique index IBE_DSP_SECTIONS_B_U1 (SECTION_ID, ZD_EDITION_NAME), supporting edition-based redefinition.
• SECTION_TYPE_CODE and STATUS_CODE — Classify the section type and its lifecycle state.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Define the active date range for the section.
• DISPLAY_CONTEXT_ID — Foreign key to IBE_DSP_CONTEXT_B, linking the section to its display context.
• DELIVERABLE_ID — Foreign key to JTF_AMV_ITEMS_B, associating the section with deliverable media items.
• AVAILABLE_IN_ALL_SITES_FLAG — Controls multi-site availability.
• AUTO_PLACEMENT_RULE and ORDER_BY_CLAUSE — Govern automatic product placement and sort order.
• ENABLE_COMPARISON — Flag enabling product comparison within the section.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing Oracle security group partitioning.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — DFF (descriptive flexfield) columns for extensibility.

Common Use Cases and Queries

Typical use cases include storefront configuration auditing, multi-site section availability reporting, and tracing how sections map to site roots. A representative query lists active sections with their localized names:

• SELECT s.section_id, s.access_name, t.section_name FROM ibe.ibe_dsp_sections_b s, ibe.ibe_dsp_sections_tl t WHERE s.section_id = t.section_id AND t.language = 'US' AND SYSDATE BETWEEN s.start_date_active AND NVL(s.end_date_active, SYSDATE + 1);
• SELECT section_id, access_name FROM ibe.ibe_dsp_sections_b WHERE available_in_all_sites_flag = 'Y' AND status_code = 'ACTIVE';
• Joining to IBE_DSP_MSITE_SCT_SECTS to resolve parent/child section hierarchies for a given multi-site.

Reporting scenarios frequently combine this table with IBE_DSP_SECTION_ITEMS for content inventory and with IBE_MSITES_B to determine root sections per site.

Related Objects

• IBE_DSP_SECTIONS_TL — Stores translated section names and descriptions; joined on SECTION_ID.
• IBE_DSP_SECTION_ITEMS — Lists items assigned to each section; joined on SECTION_ID.
• IBE_DSP_MSITE_SCT_SECTS — Defines parent/child section relationships across multi-sites via PARENT_SECTION_ID and CHILD_SECTION_ID.
• IBE_MSITES_B — References MSITE_ROOT_SECTION_ID, identifying each site's root section.
• IBE_DSP_CONTEXT_B — Parent display context referenced by DISPLAY_CONTEXT_ID.
• JTF_AMV_ITEMS_B — Deliverable media reference via DELIVERABLE_ID.
• FND_SECURITY_GROUPS — Security partitioning via SECURITY_GROUP_ID.
• IBE_CT_RELATION_RULES — Relates sections as origin/destination objects for cross-sell and up-sell rules.
• IBE_SECTION_SEARCH — Search index referencing SECTION_ID.
• IBE_ECR_ORDERS_FACT and IBE_ECR_QUOTES_FACT — Analytics fact tables joined on SECTION_ID.