Search Results hz_dss_secured_entities




Overview
Explore in AI Chat

Overview

The HZ_DSS_SECURED_ENTITIES table is a core data security object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Receivables (AR) module. It functions as a junction table that defines the many-to-many relationship between Data Sharing Groups (DSS Groups) and the business entities they secure. Its primary role is to enforce data security and visibility rules by explicitly linking a secured entity—such as a customer or site—to a specific data sharing group. This mechanism is fundamental to the Data Security System (DSS), which controls user access to trading community data based on their assigned responsibilities and group memberships.

Key Information Stored

The table's structure is concise, designed to store the essential linkage between a group and an entity. Its two primary columns form a composite primary key. The DSS_GROUP_CODE column stores the unique identifier for a Data Sharing Group defined in the HZ_DSS_GROUPS_B table. The ENTITY_ID column stores the unique identifier for a secured business entity, which corresponds to a record in the HZ_DSS_ENTITIES table. This entity typically represents a specific level of customer data, such as a customer account or site, that requires access control. The combination of these two columns ensures that a given entity can only be associated with a specific security group once, maintaining data integrity for the security model.

Common Use Cases and Queries

The primary use case is to determine which data security groups protect a specific business entity or to list all entities secured by a particular group. This is critical for security audits, troubleshooting data visibility issues for users, and during data migration or integration projects where security rules must be preserved. A common reporting query involves joining to the related descriptive tables to translate codes and IDs into meaningful names. For example, to list all secured entities for a given group:

Conversely, to find all groups securing a specific entity type:

  • SELECT g.NAME FROM HZ_DSS_SECURED_ENTITIES se, HZ_DSS_GROUPS_TL g, HZ_DSS_ENTITIES e WHERE se.DSS_GROUP_CODE = g.DSS_GROUP_CODE AND se.ENTITY_ID = e.ENTITY_ID AND e.ENTITY_CODE = '&ENTITY_CODE';

Related Objects

HZ_DSS_SECURED_ENTITIES sits at the center of the Data Security System's relational model. It has defined foreign key relationships with two key master tables, as documented in the ETRM metadata. The DSS_GROUP_CODE column references HZ_DSS_GROUPS_B.DSS_GROUP_CODE, linking each record to a master security group definition. The ENTITY_ID column references HZ_DSS_ENTITIES.ENTITY_ID, linking each record to the definition of a securable entity type within the trading community. These relationships ensure referential integrity, meaning a secured entity record cannot exist without a valid parent record in both the group and entity master tables. The table is primarily accessed through the application's security APIs and user interface, rather than via direct DML in standard operations.