Search Results ibe_dsp_context_b




Overview
Explore in AI Chat

Overview

The IBE_DSP_CONTEXT_B table is a core data structure within the Oracle E-Business Suite iStore (IBE) module. It functions as the master table for storing display contexts, which are critical configuration entities that govern the presentation of content and media within the iStore application. A display context acts as a logical container, associating specific templates and media attributes with different sections or items in the storefront, thereby enabling flexible and context-aware rendering of product information, banners, and other media elements. Its role is central to the personalization and layout management capabilities of the Oracle iStore e-commerce platform.

Key Information Stored

The table's primary identifier is the CONTEXT_ID, a system-generated unique key. The structure enforces uniqueness through a composite key on the ACCESS_NAME and CONTEXT_TYPE_CODE columns, which together define a functional identifier for the context. The ACCESS_NAME typically holds a code or name used by the application logic to retrieve the context, while the CONTEXT_TYPE_CODE categorizes its purpose. A critical foreign key is the ITEM_ID, which links the display context to a specific media item or content object stored in the JTF_AMV_ITEMS_B table, forming the bridge between display rules and the actual media assets.

Common Use Cases and Queries

Primary use cases involve the administration of storefront layouts and the dynamic selection of templates for product displays. For instance, an administrator may configure different display contexts for the homepage versus a product category page, each pulling in distinct media and using different templates. Common reporting and diagnostic queries include retrieving all contexts for a specific media item or validating context definitions. A typical SQL pattern to list active contexts with their associated item names would be:

  • SELECT dc.context_id, dc.access_name, dc.context_type_code, ji.item_title FROM ibe.ibe_dsp_context_b dc, jtf.jtf_amv_items_b ji WHERE dc.item_id = ji.item_id;

Another frequent operation is joining to its translation table, IBE_DSP_CONTEXT_TL, to fetch context descriptions in the user's session language.

Related Objects

IBE_DSP_CONTEXT_B sits at the center of a hierarchy of display configuration objects, as evidenced by its foreign key relationships. The documented dependencies are:

  • JTF_AMV_ITEMS_B: The master table for media items. Joined via IBE_DSP_CONTEXT_B.ITEM_ID = JTF_AMV_ITEMS_B.ITEM_ID.
  • IBE_DSP_CONTEXT_TL: The translation table holding language-specific descriptions for contexts. Joined via IBE_DSP_CONTEXT_B.CONTEXT_ID = IBE_DSP_CONTEXT_TL.CONTEXT_ID.
  • IBE_DSP_OBJ_LGL_CTNT: Stores logical content objects, which can be associated with a specific context. Joined via IBE_DSP_CONTEXT_B.CONTEXT_ID = IBE_DSP_OBJ_LGL_CTNT.CONTEXT_ID.
  • IBE_DSP_SECTIONS_B: Stores page section definitions that reference a display context for their layout. Joined via IBE_DSP_CONTEXT_B.CONTEXT_ID = IBE_DSP_SECTIONS_B.DISPLAY_CONTEXT_ID.