Search Results ibe_msite_resps_b




Overview
Explore in AI Chat

Overview

The IBE_MSITE_RESPS_B table is a core data object within the Oracle E-Business Suite (EBS) iStore (IBE) module. It functions as the master definition table for mapping responsibilities to specialty stores (microsites). A specialty store is a configurable, branded storefront within the iStore framework, often tailored for specific sales channels, customer segments, or product lines. This table's primary role is to control access and define the user interface and functional privileges available for a given storefront by associating it with one or more EBS responsibilities. This association is fundamental to the iStore security model, determining which menus, functions, and data are accessible to users navigating a particular microsite.

Key Information Stored

The table stores the essential foreign key relationships that bind a microsite to a responsibility. The critical columns are MSITE_RESP_ID, which is the unique primary key identifier for each mapping record; MSITE_ID, which references the specific microsite defined in IBE_MSITES_B; and the pair RESPONSIBILITY_ID and APPLICATION_ID, which together uniquely identify an EBS responsibility from the FND_RESPONSIBILITY table. This two-column foreign key to FND_RESPONSIBILITY is a standard pattern in EBS for responsibility references. The table also includes standard WHO columns (e.g., CREATION_DATE, CREATED_BY) for auditing.

Common Use Cases and Queries

A primary use case is troubleshooting user access issues or verifying the configuration of a storefront. Administrators often query this table to list all responsibilities enabled for a microsite or to identify which microsite a particular responsibility serves. Common reporting needs include auditing security setups and generating configuration documentation. A typical query to retrieve all responsibility mappings for a microsite would be:

  • SELECT r.resp_key, r.responsibility_name, m.msite_id, s.msite_name FROM ibe_msite_resps_b m, fnd_responsibility_vl r, ibe_msites_b s WHERE m.responsibility_id = r.responsibility_id AND m.application_id = r.application_id AND m.msite_id = s.msite_id ORDER BY s.msite_name;

Another frequent operational query is to check for a specific responsibility's assignment before granting it to a user, ensuring it is linked to the correct storefront.

Related Objects

The IBE_MSITE_RESPS_B table sits at the center of several key relationships, as documented in the ETRM metadata. Its primary foreign key dependencies are:

  • IBE_MSITES_B: The parent table for microsite definitions. A join on MSITE_ID is used to get the microsite details (e.g., MSITE_NAME).
  • FND_RESPONSIBILITY: The core EBS table for responsibility definitions. A join on the composite key (RESPONSIBILITY_ID, APPLICATION_ID) is required to get the responsibility name and key.
  • IBE_MSITE_RESPS_TL: The corresponding Translation table, which holds the user-facing name and description for the mapping in multiple languages. It is joined to IBE_MSITE_RESPS_B on the MSITE_RESP_ID column.

These relationships are critical for any comprehensive query or data integrity constraint involving microsite responsibility assignments.