Search Results hz_dss_groups_b




Overview
Explore in AI Chat

Overview

The HZ_DSS_GROUPS_B table is a core data structure within the Oracle E-Business Suite (EBS) Receivables (AR) module, specifically designed to support the Data Security System (DSS). This table serves as the master repository for defining Data Sharing Groups. In the context of EBS, Data Sharing Groups are a critical security mechanism that controls access to trading community data, such as customers and related entities, based on user responsibilities and organizational hierarchies. The table's role is to store the fundamental definition of each security group, enabling the system to partition and secure customer data across different business units, divisions, or other organizational constructs, thereby enforcing data visibility rules.

Key Information Stored

As a base table, HZ_DSS_GROUPS_B primarily stores the unique identifier and essential attributes for each Data Sharing Group. The primary key column, DSS_GROUP_CODE, is the most critical field, acting as the unique code that identifies each distinct security group throughout the system. While the provided ETRM metadata does not list all columns, typical columns in such a base table would include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY for auditing, and potentially a NAME or DESCRIPTION field. The corresponding translated table, HZ_DSS_GROUPS_TL, referenced in the foreign key list, stores the language-specific names and descriptions for these groups.

Common Use Cases and Queries

This table is central to administrative setups and security audits within Receivables. Common use cases include the initial configuration of data security rules for customer data access and generating reports to review existing security group definitions. System administrators or auditors might run queries to list all defined groups or analyze group assignments. A fundamental query would join the base table with its translation table to retrieve the group codes and their descriptions:

  • SELECT b.DSS_GROUP_CODE, tl.NAME FROM AR.HZ_DSS_GROUPS_B b, AR.HZ_DSS_GROUPS_TL tl WHERE b.DSS_GROUP_CODE = tl.DSS_GROUP_CODE AND tl.LANGUAGE = USERENV('LANG');

Another critical use case involves troubleshooting data visibility issues, where one might trace a user's inability to see a customer record back to the specific Data Sharing Groups assigned to that user's responsibility.

Related Objects

The HZ_DSS_GROUPS_B table is a parent entity with several key dependent objects, as indicated by the foreign key relationships. The HZ_DSS_ASSIGNMENTS table links Data Sharing Groups to specific responsibilities, defining which security groups a user's responsibility can access. The HZ_DSS_CRITERIA table stores the detailed security rules (e.g., based on operating unit, territory) that define the membership of a Data Sharing Group. The HZ_DSS_SECURED_ENTITIES table links the groups to the specific customer or party records they secure. Finally, the HZ_DSS_GROUPS_TL table provides the translated names and descriptions for the groups stored in the base table. These relationships collectively form the backbone of the Data Security System for trading community data in Oracle EBS.