Results for “msite_information20”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IBE_MSITE_INFORMATION is a table in the IBE (iStore) product schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores additional descriptive information about specialty stores (micro-sites or "m-sites") defined in Oracle iStore. Each row extends a base specialty store record held in IBE_MSITES_B with supplementary attributes, context-sensitive descriptive flexfield values, and descriptive columns used by iStore storefront configuration and personalization logic. The table is owned by the IBE schema and is marked VALID across both release levels.
From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. It appears as a dependent detail table that hangs off a hub (the store/master site entity represented by IBE_MSITES_B via MSITE_ID) and carries descriptive, time-stamped attributes, which is the classic pattern of a satellite. This classification is a heuristic suggestion rather than a documented Data Vault design; the physical object is a standard EBS child table using the FND who-columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and an OBJECT_VERSION_NUMBER for optimistic locking.
Key Information Stored
The table contains 46 documented columns. The most significant are:
- MSITE_INFORMATION_ID — surrogate primary key enforced by IBE_MSITE_INFORMATION_PK. A second unique index, IBE_MSITE_INFORMATION_U1, also covers this column and serves as the documented business-key candidate relationship.
- MSITE_ID — foreign key to IBE_MSITES_B, linking the information row to its parent specialty store.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, used for multi-tenant / security group partitioning.
- MSITE_INFORMATION_CONTEXT — the descriptive flexfield context that determines which of the numbered MSITE_INFORMATION
segments are meaningful for a given row. - MSITE_INFORMATION1 through MSITE_INFORMATION20 — twenty context-sensitive flexfield segment columns holding configurable store-attributed values.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS attribute flexfield block for user-defined extensions.
- OBJECT_VERSION_NUMBER — concurrency control column used by the OAF/BC4J framework.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the FND audit columns recording who created and last modified the row.
Common Use Cases and Queries
Typical uses include reporting on store attributes, extracting storefront configuration for integration, and auditing security group assignment. Because the meaningful values reside in the context-sensitive segments, most queries join to the base store table and filter on the context.
A common pattern retrieves store detail for a given specialty store:
- SELECT i.msite_id, i.msite_information_context, i.msite_information1, i.msite_information2 FROM ibe.ibe_msite_information i WHERE i.msite_id = :p_msite_id;
A reporting join to the parent store and its translations is also frequent:
- SELECT b.msite_id, b.msite_code, i.attribute1, i.attribute2 FROM ibe.ibe_msites_b b, ibe.ibe_msite_information i WHERE b.msite_id = i.msite_id AND i.security_group_id = :p_security_group;
For extract-based integrations, the LAST_UPDATE_DATE column drives incremental pulls:
- SELECT * FROM ibe.ibe_msite_information WHERE last_update_date >= :p_since_date;
Related Objects
The principal objects related to IBE_MSITE_INFORMATION, based on documented foreign keys and schema dependencies, are:
- IBE_MSITES_B — parent specialty store (base) table. Joined via IBE_MSITE_INFORMATION.MSITE_ID = IBE_MSITES_B.MSITE_ID.
- FND_SECURITY_GROUPS — security group definition. Joined via IBE_MSITE_INFORMATION.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID.
- IBE_MSITES_TL — translated store names/descriptions typically joined through MSITE_ID to enrich reporting.
- IBE_MSITE_INFORMATION_PK — the primary key constraint on MSITE_INFORMATION_ID.
- IBE_MSITE_INFORMATION_U1 — the unique index supporting the primary-key candidate.
- IBE_MSITE_INFORMATION table/synonym interfaces — referenced by Oracle iStore storefront configuration pages and any custom concurrent programs extracting store attributes by MSITE_ID and context.
-
This Table Stores Additional Information about Specialty Stores
-
This Table Stores Additional Information about Specialty Stores
-
eTRM - IBE Tables and Views 12.2.2
This table stores information about supported Work Flow notifications in iStore.
-
eTRM - IBE Tables and Views 12.1.1
This table stores information about supported Work Flow notifications in iStore.