Search Results hz_dss_criteria




Overview
Explore in AI Chat

Overview

The HZ_DSS_CRITERIA table is a core data object within the Oracle E-Business Suite Receivables (AR) module, specifically in versions 12.1.1 and 12.2.2. It functions as the repository for defining the specific criteria that constitute a Data Sharing Group (DSS). Data Sharing Groups are a security mechanism that controls access to trading community data, such as customers and accounts, based on user-defined rules. This table stores the individual rule definitions that link a group to the specific parties, relationships, or other entities that its members are permitted to view and transact with, thereby enforcing data-level security within the TCA (Trading Community Architecture) framework.

Key Information Stored

The table's primary purpose is to map a Data Sharing Group to its qualifying data. The critical columns include DSS_GROUP_CODE, which links the criterion to its parent group defined in HZ_DSS_GROUPS_B. The SECURED_ITEM_ID serves as the table's primary key. The OWNER_TABLE_ID1 column is a pivotal foreign key that holds the identifier (typically a PARTY_ID) of the secured entity, such as a specific customer or party. The table structure is designed to support the definition of criteria based on different entity types, with relationships potentially governed through joins to tables like HZ_RELATIONSHIPS.

Common Use Cases and Queries

The primary use case is the administration and enforcement of data security for customer data. When a user's responsibility is assigned to a Data Sharing Group, the system queries HZ_DSS_CRITERIA to determine which party records they are authorized to access. A common reporting need is to audit all criteria assigned to a specific group. A sample query for this would be:

  • SELECT dss_group_code, owner_table_id1 FROM hz_dss_criteria WHERE dss_group_code = 'GROUP_NAME';

Another practical scenario involves troubleshooting data visibility issues by joining to HZ_PARTIES to see the actual party names secured by a criterion:

  • SELECT hp.party_name, hdc.dss_group_code FROM hz_dss_criteria hdc, hz_parties hp WHERE hdc.owner_table_id1 = hp.party_id AND hdc.dss_group_code = 'GROUP_NAME';

Related Objects

HZ_DSS_CRITERIA is centrally connected to several key TCA security and entity tables, as documented in the provided foreign key metadata.

  • HZ_DSS_GROUPS_B: The parent table. The DSS_GROUP_CODE in HZ_DSS_CRITERIA references this table to define the group to which the criterion belongs.
  • HZ_PARTIES: A primary foreign key relationship. The OWNER_TABLE_ID1 column in HZ_DSS_CRITERIA typically stores a PARTY_ID, linking the criterion to a specific trading community entity.
  • HZ_RELATIONSHIP_TYPES: The provided metadata indicates a foreign key relationship where OWNER_TABLE_ID1 can also reference this table, allowing criteria to be based on specific types of party relationships.