Search Results ibe_msite_prty_accss




Overview
Explore in AI Chat

Overview

The IBE_MSITE_PRTY_ACCSS table is a core data object within the Oracle E-Business Suite iStore (IBE) module, specifically for versions 12.1.1 and 12.2.2. It serves as a junction table that defines the relationship between parties (customers, organizations) and specialty stores, known as microsites. Its primary function is to manage and enforce access control, determining which parties are authorized to interact with or purchase from specific microsites within the iStore application. This table is essential for implementing segmented storefronts, such as partner portals or specialized B2B storefronts, where access is restricted to a defined set of customers.

Key Information Stored

The table's structure is designed to map party identifiers to microsite identifiers. The most critical columns are the primary and unique key columns. The MSITE_PRTY_ACCSS_ID column serves as the primary key surrogate identifier for each record. The combination of PARTY_ID and MSITE_ID forms a unique key (IBE_MSITE_PRTY_ACCSS_UK1), ensuring that a specific party cannot be granted duplicate access to the same microsite. The PARTY_ID stores the identifier from the Trading Community Architecture (TCA) registry (HZ_PARTIES), representing the customer or organization. The MSITE_ID stores the identifier for the microsite, linking to the IBE_MSITES_B table which defines the storefront's configuration.

Common Use Cases and Queries

A primary use case is validating a user's access during a storefront session. When a user logs into a microsite, the application queries this table to confirm their party ID is associated with the current MSITE_ID. Administrators use this table to grant or revoke access for customer accounts to specific storefronts. Common reporting needs include listing all parties with access to a given microsite or auditing which microsites a particular customer can access. A typical query to retrieve all parties for a microsite would be:

  • SELECT hp.party_name, hp.party_number FROM ibe_msite_prty_accss impa, hz_parties hp WHERE impa.party_id = hp.party_id AND impa.msite_id = <MSITE_ID>;

Conversely, to find all microsites accessible to a party:

  • SELECT imb.name FROM ibe_msite_prty_accss impa, ibe_msites_b imb WHERE impa.msite_id = imb.msite_id AND impa.party_id = <PARTY_ID>;

Related Objects

The IBE_MSITE_PRTY_ACCSS table has defined foreign key relationships with two fundamental tables, as per the provided metadata. Its MSITE_ID column references the IBE_MSITES_B.MSITE_ID column. This links each access record to the master definition of a microsite, which contains its name, description, and operational parameters. Its PARTY_ID column references the HZ_PARTIES.PARTY_ID column. This links each access record to the Trading Community Architecture (TCA) registry, providing access to the full legal name, address, and profile information for the customer or organization. These relationships are critical for any join query that requires displaying microsite names or party details alongside the access mapping.

  • Table: IBE_MSITE_PRTY_ACCSS 12.2.2

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_MSITE_PRTY_ACCSS,  object_name:IBE_MSITE_PRTY_ACCSS,  status:VALID,  product: IBE - iStore ,  description: Defines the parties supported by the Specialty Stores ,  implementation_dba_data: IBE.IBE_MSITE_PRTY_ACCSS , 

  • Table: IBE_MSITE_PRTY_ACCSS 12.1.1

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_MSITE_PRTY_ACCSS,  object_name:IBE_MSITE_PRTY_ACCSS,  status:VALID,  product: IBE - iStore ,  description: Defines the parties supported by the Specialty Stores ,  implementation_dba_data: IBE.IBE_MSITE_PRTY_ACCSS , 

  • Table: IBE_MSITES_B 12.1.1

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_MSITES_B,  object_name:IBE_MSITES_B,  status:VALID,  product: IBE - iStore ,  description: Stores Mini Site (Specialty Stores) Information. ,  implementation_dba_data: IBE.IBE_MSITES_B , 

  • Table: IBE_MSITES_B 12.2.2

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_MSITES_B,  object_name:IBE_MSITES_B,  status:VALID,  product: IBE - iStore ,  description: Stores Mini Site (Specialty Stores) Information. ,  implementation_dba_data: IBE.IBE_MSITES_B ,