Search Results ibe_dsp_lgl_phys_map

Overview

The IBE_DSP_LGL_PHYS_MAP table is a core data structure within the Oracle E-Business Suite iStore (IBE) module, versions 12.1.1 and 12.2.2. It functions as a mapping table that defines the relationship between logical media identifiers and their corresponding physical media files. Its primary role is to manage the contextual display of digital assets, such as images or documents, across different iStore sites and languages. This enables a single logical piece of content to be associated with multiple physical renditions, allowing for site-specific and language-specific customization of the online storefront's visual and media elements.

Key Information Stored

The table's central purpose is to maintain mappings keyed by site and language. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal its critical data points. The primary key column is LGL_PHYS_MAP_ID, which uniquely identifies each mapping record. The table stores foreign key references to an iStore site (MSITE_ID), a logical media item (ITEM_ID), and a physical attachment file (ATTACHMENT_ID). This structure implies the table also contains columns to specify the applicable language and likely a logical media type or context code, facilitating the resolution of which physical file (ATTACHMENT_ID) to display for a given logical item (ITEM_ID) on a specific site (MSITE_ID) and language.

Common Use Cases and Queries

A primary use case is the dynamic rendering of product images or marketing banners on an iStore site. When a user visits a site in a specific locale, the application queries this table to find the correct physical image file for the logical banner slot. Common reporting needs include auditing media coverage across sites or identifying missing physical files for a launch. A typical query pattern would join to the related item and attachment tables to retrieve a usable file path or identifier.

• Sample Query for Site Media: SELECT map.msite_id, map.item_id, att.attachment_name FROM ibe_dsp_lgl_phys_map map, jtf_amv_attachments att WHERE map.attachment_id = att.attachment_id AND map.msite_id = :p_site_id;
• Validation Query: Identifying logical items without a physical mapping for a critical site and language combination.

Related Objects

The table is centrally connected to several key EBS objects, as documented by its foreign key constraints. These relationships are fundamental to its operation.

• IBE_MSITES_B: Joined via MSITE_ID. This links each mapping to a specific iStore master site, enabling multi-site media management.
• JTF_AMV_ITEMS_B: Joined via ITEM_ID. This connects the mapping to the logical media item or content object within the JTF Attachment Manager repository.
• JTF_AMV_ATTACHMENTS: Joined via ATTACHMENT_ID. This critical link references the actual physical file data stored in the attachments repository, completing the logical-to-physical resolution.