Search Results ibe_dsp_obj_lgl_ctnt_uk1

Overview

The table IBE_DSP_OBJ_LGL_CTNT is a core data repository within the Oracle E-Business Suite iStore (IBE) module, versions 12.1.1 and 12.2.2. It serves as a configuration table that manages the assignment of default logical content items to specific display objects within defined contexts. Its primary role is to support the dynamic and context-sensitive rendering of the iStore user interface by establishing relationships between displayable objects—such as categories or sections—and the logical content items that should be presented for them by default. This table is essential for implementing personalized and targeted merchandising rules within the e-commerce storefront.

Key Information Stored

The table's structure is designed to define a unique mapping between a content item and a display object within a specific context. The primary key is the surrogate key OBJ_LGL_CTNT_ID. The critical business key columns, which form a unique constraint (IBE_DSP_OBJ_LGL_CTNT_UK1), are ITEM_ID, CONTEXT_ID, OBJECT_ID, and OBJECT_TYPE. The ITEM_ID column stores the identifier for the logical content item, which references the JTF_AMV_ITEMS_B table. The CONTEXT_ID column points to a display context defined in IBE_DSP_CONTEXT_B. The OBJECT_ID and OBJECT_TYPE columns together identify the specific object (e.g., a product category from MTL_CATEGORIES_B or a site section from IBE_DSP_SECTIONS_B) to which the default item is assigned.

Common Use Cases and Queries

A primary use case is querying the default content configured for a specific product category within a given storefront context, which drives the UI presentation. Administrators may run queries to audit or manage these assignments. For example, to find all default logical items for categories in a specific context, one might use a query such as:

• SELECT cat.segment1 category_code, item.item_title, item.item_description FROM ibe_dsp_obj_lgl_ctnt ctnt, jtf_amv_items_b item, mtl_categories_b cat WHERE ctnt.item_id = item.item_id AND ctnt.object_id = cat.category_id AND ctnt.object_type = 'CATEGORY' AND ctnt.context_id = 1001;

Another common scenario involves data migration or initialization scripts, where default content rules for new objects must be inserted into this table based on template configurations.

Related Objects

IBE_DSP_OBJ_LGL_CTNT maintains documented foreign key relationships with several fundamental tables, as per the provided metadata. It references IBE_DSP_CONTEXT_B via the CONTEXT_ID column to define the applicable display context. It references MTL_CATEGORIES_B via the OBJECT_ID column when the object type is a category. It references IBE_DSP_SECTIONS_B via the OBJECT_ID column when the object type is a site section. Finally, it references JTF_AMV_ITEMS_B via the ITEM_ID column to identify the specific logical content item (such as a banner, text, or media object) to be displayed. These relationships are central to its function of linking iStore's content management system with its catalog and UI framework.