Results for “ibe_dsp_lgl_phys_map”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IBE_DSP_LGL_PHYS_MAP is an Oracle E-Business Suite table owned by the IBE (iStore) schema. It stores the logical-to-physical media mapping for iStore content, resolved by site and language. In practice, the table lets iStore determine which physical media asset (an attachment) should be rendered for a given logical content item, per store site and per language. This supports multilingual, multi-site storefronts where the same logical content is served through different physical media files depending on the shopper's site and language context.
The table is classified as VALID in Oracle EBS 12.2.2. Its heuristic Data Vault classification is link, mined from its foreign key structure. As a modeling suggestion, this reflects its role as a resolution/association table connecting a media site, a content item, and an attachment. It is not a descriptive hub or satellite but rather a relationship object that binds logical content keys to physical media across site and language dimensions.
Key Information Stored
The physical schema documented in ETRM 12.2.2 contains 16 columns. The most significant columns are:
- LGL_PHYS_MAP_ID — the surrogate primary key (documented as PK OCO_38364745) uniquely identifying each logical-to-physical mapping row.
- MSITE_ID — foreign key to IBE_MSITES_B, identifying the iStore media site to which the mapping applies.
- ATTACHMENT_ID — foreign key to JTF_AMV_ATTACHMENTS, identifying the physical media attachment served.
- ITEM_ID — foreign key to JTF_AMV_ITEMS_B, identifying the logical media/content item.
- LANGUAGE_CODE — the language for which the mapping is valid.
- DEFAULT_LANGUAGE — flag indicating whether the mapping is the default for the language.
- DEFAULT_SITE — flag indicating whether the mapping is the default for the site.
- CONTENT_ITEM_KEY — a logical content key used to resolve the physical media.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, used for multi-org/security partitioning.
- OBJECT_VERSION_NUMBER — optimistic locking version for concurrent updates.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit (WHO) columns.
- ZD_EDITION_NAME — editioning support column used in 12.2 online patching.
The documented unique index IBE_DSP_LGL_PHYS_MAP_U2 covers ITEM_ID, MSITE_ID, LANGUAGE_CODE, DEFAULT_LANGUAGE, DEFAULT_SITE, and ZD_EDITION_NAME, indicating the business key that enforces uniqueness of a mapping for an item/site/language combination.
Common Use Cases and Queries
Typical uses include troubleshooting why the wrong image or media appears on a storefront, verifying which physical attachment resolves for a given site and language, and auditing default mappings. A representative query joining the mapping to its related objects follows:
- Resolve physical media for a content item at a site and language:
SELECT m.LGL_PHYS_MAP_ID, m.ITEM_ID, m.MSITE_ID, m.LANGUAGE_CODE, m.ATTACHMENT_ID FROM IBE.IBE_DSP_LGL_PHYS_MAP m WHERE m.ITEM_ID = :item_id AND m.MSITE_ID = :msite_id AND m.LANGUAGE_CODE = :lang; - Find default mappings:
SELECT * FROM IBE.IBE_DSP_LGL_PHYS_MAP WHERE DEFAULT_SITE = 'Y' OR DEFAULT_LANGUAGE = 'Y'; - Join to media sites and items to report media coverage per site: join MSITE_ID to IBE_MSITES_B and ITEM_ID to JTF_AMV_ITEMS_B.
- Reconcile orphaned mappings when attachments are removed by joining ATTACHMENT_ID to JTF_AMV_ATTACHMENTS.
Related Objects
The following objects are most significant, based on documented foreign key relationships:
- IBE_MSITES_B — joined on IBE_DSP_LGL_PHYS_MAP.MSITE_ID.
- JTF_AMV_ATTACHMENTS — joined on IBE_DSP_LGL_PHYS_MAP.ATTACHMENT_ID.
- JTF_AMV_ITEMS_B — joined on IBE_DSP_LGL_PHYS_MAP.ITEM_ID.
- FND_SECURITY_GROUPS — joined on IBE_DSP_LGL_PHYS_MAP.SECURITY_GROUP_ID.
These relationships confirm the table's function as a resolution link between logical content items, physical attachments, media sites, and security partitioning.
-
Stores the logical to physical media mapping based on site and language
-
Stores the logical to physical media mapping based on site and language