IBE — iStore
41 documented tables · 59 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
IBE_MSITES_B |
Stores Mini Site (Specialty Stores) Information. | hub |
IBE_DSP_SECTIONS_B |
This table stores information about the sections. | hub |
IBE_DSP_CONTEXT_B |
Stores the display contexts associated with templates and media attributes for media. | hub-leaning |
IBE_SHP_LIST_ITEMS_ALL |
Stores Shopping List Items details. | satellite-leaning |
IBE_MSITE_RESPS_B |
Defines the responsibilities supported by the Specialty Store. | satellite-leaning |
IBE_STORES_B |
Stores details of a WEB store. | hub-leaning |
IBE_SH_SHP_LISTS_ALL |
Stores Shopping Lists details. | satellite-leaning |
IBE_CT_RELATION_RULES |
Mapping or SQL rules that define product relationships | satellite-leaning |
IBE_DSP_SECTION_ITEMS |
This table stores the association between sections and items. | satellite-leaning |
IBE_WF_NOTIF_SETUP |
This table stores information about supported Work Flow notifications in iStore. | hub-leaning |
IBE_WF_NOTIF_MSG_MAPS |
This table contains information about message mappings for each notification. | link |
IBE_MSITE_LANGUAGES |
Stores the languages supported by the mini-sites | link |
IBE_DSP_TPL_CTG |
This table stores the category to logical template mappings | link |
IBE_DSP_LGL_PHYS_MAP |
Stores the logical to physical media mapping based on site and language | link |
IBE_ORD_ONECLICK |
Express checkout settings for registered customers | link |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
IBE_LOGICALCONTENT_GRP |
GRP | 7 | 9 packages |
IBE_DSPMGRVALIDATION_GRP |
GRP | 30 | 7 packages |
IBE_PHYSICALMAP_GRP |
GRP | 14 | 5 packages |
IBE_ATTACHMENT_GRP |
GRP | 4 | 3 packages |
IBE_TPLCATEGORY_GRP |
GRP | 5 | 3 packages |
IBE_DELIVERABLE_GRP |
GRP | 7 | 3 packages |
IBE_DSP_SECTION_GRP |
GRP | 12 | 3 packages |
IBE_DISPLAYCONTEXT_GRP |
GRP | 12 | 2 packages |
IBE_DSP_HIERARCHY_SETUP_PUB |
PUB | 3 | 1 packages |
IBE_MSITE_GRP |
GRP | 15 | 1 packages |