Search Results ibe_section_search




Overview
Explore in AI Chat

Overview

The IBE_SECTION_SEARCH table is a core data object within the Oracle E-Business Suite iStore (IBE) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to manage the relationship between catalog items and specific sections of a minisite, enabling the restriction of search results. This table acts as a junction or mapping table, defining which inventory items are searchable and discoverable within designated sections of a given iStore minisite. By maintaining these associations, it provides the underlying data structure that powers the faceted and section-specific search capabilities essential for a personalized and organized online storefront experience.

Key Information Stored

The table's structure is defined by a composite primary key, which uniquely identifies each valid mapping record. The key columns are INVENTORY_ITEM_ID, MINISITE_ID, ORGANIZATION_ID, and SECTION_ID. The INVENTORY_ITEM_ID and ORGANIZATION_ID columns together identify a specific product from the inventory master (MTL_SYSTEM_ITEMS_B). The MINISITE_ID references a specific iStore storefront (IBE_MSITES_B), and the SECTION_ID points to a defined section or category within that minisite (IBE_DSP_SECTIONS_B). The presence of a record in this table explicitly permits the associated item to appear in search results when a customer is browsing that particular minisite section.

Common Use Cases and Queries

A primary use case is the administration of an iStore catalog, where a manager needs to control product visibility across different site sections. For example, a product might be mapped to both a "New Arrivals" section and a "Clearance" section for targeted discoverability. A common reporting query would list all items assigned to a specific section for a given minisite to audit search mappings. A typical SQL pattern is:

  • SELECT ms.minisite_name, sec.section_name, msi.segment1 item_code FROM ibe_section_search ss, ibe_msites_b ms, ibe_dsp_sections_b sec, mtl_system_items_b msi WHERE ss.minisite_id = ms.minisite_id AND ss.section_id = sec.section_id AND ss.inventory_item_id = msi.inventory_item_id AND ss.organization_id = msi.organization_id AND ms.minisite_id = :p_minisite_id;

Conversely, to find all sections where a specific item is searchable, one would query by the INVENTORY_ITEM_ID and ORGANIZATION_ID.

Related Objects

The IBE_SECTION_SEARCH table maintains documented foreign key relationships with three fundamental EBS tables, ensuring referential integrity for its key columns:

  • IBE_MSITES_B: The foreign key on MINISITE_ID links to this table, which stores the definition of iStore minisites.
  • IBE_DSP_SECTIONS_B: The foreign key on SECTION_ID links to this table, which holds the master definitions of display sections or categories within minisites.
  • MTL_SYSTEM_ITEMS_B: A composite foreign key on INVENTORY_ITEM_ID and ORGANIZATION_ID links to this Inventory table, which is the master source for all product items.

These relationships confirm that every record in IBE_SECTION_SEARCH must correspond to a valid minisite, a valid section within that minisite, and a valid inventory item within a specific operating unit.