Search Results hz_dss_entities




Overview
Explore in AI Chat

Overview

The HZ_DSS_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 the master repository for defining entities that can be secured under the Data Security System (DSS). DSS is a framework that enables granular, row-level access control, allowing administrators to restrict user access to specific business data, such as transactions or customer accounts, based on configurable security policies. This table stores the fundamental building blocks—the entities themselves—upon which these security rules are constructed and applied, making it critical for implementing and managing data security within the Receivables application.

Key Information Stored

The table's structure is designed to manage a hierarchy of securable entities. The primary columns include ENTITY_ID, which serves as the unique identifier for each securable entity. The OBJECT_ID column is a foreign key to FND_OBJECTS, linking the entity to its corresponding application object definition within the EBS foundation layer. A key structural feature is the PARENT_ENTITY_ID column, which is a self-referencing foreign key to the same table (HZ_DSS_ENTITIES). This allows for the creation of nested entity hierarchies, where a parent entity can encompass multiple child entities, enabling complex and tiered security models. The table's primary key constraint, HZ_DSS_ENTITIES_PK, is enforced on the ENTITY_ID column.

Common Use Cases and Queries

The primary use case revolves around the administration and auditing of the Data Security System. Common activities include analyzing the hierarchy of securable entities to understand security inheritance or identifying all entities available for a specific application object. A typical query might join HZ_DSS_ENTITIES with FND_OBJECTS to list all securable entities with their associated object names. Another critical query involves joining with HZ_DSS_SECURED_ENTITIES to see which specific entity instances (e.g., a particular customer account) have active security grants. For example, a query to find all child entities under a specific parent would utilize the self-referential relationship on PARENT_ENTITY_ID.

Related Objects

  • FND_OBJECTS: Foundation table that defines application objects. The HZ_DSS_ENTITIES.OBJECT_ID foreign key links a securable entity to its base object definition.
  • HZ_DSS_SECURED_ENTITIES: A central dependent table that stores the actual security grants or assignments. Its ENTITY_ID column is a foreign key to HZ_DSS_ENTITIES.ENTITY_ID, linking a specific grant to the entity being secured.
  • Self-Reference: The table has a foreign key relationship with itself via the PARENT_ENTITY_ID column, enabling the creation of hierarchical entity structures.