Search Results class_name




Overview
Explore in AI Chat

Overview

HZ_DSS_SECURED_CLASSES_V is an APPS-owned reporting view in the Oracle E-Business Suite Receivables (AR) product family. It exposes the configuration of secured class codes used by the Data Security System (DSS) framework within the Trading Community Architecture (TCA) and Customer/Party model. In Oracle EBS 12.1.1 and 12.2.2, DSS controls which classifications of customer, party, or contact data a given responsibility or user may access. This view flattens the configuration stored in HZ_DSS_CRITERIA together with lookup metadata and denormalized class code information, presenting a readable result set that joins secured items to their owning lookup types, lookup codes, and concatenated class identifiers.

The view is primarily consumed for reporting, validation, diagnostics, and integration. It allows administrators and developers to audit which class categories and class codes are defined as secured, what group code governs them, and the human-readable meaning associated with each secured entry.

Underlying Base Objects

The view is defined over four documented base objects:

The join is filtered so that only rows where HDC.OWNER_TABLE_NAME equals 'FND_LOOKUP_VALUES' are returned, and all lookup-based joins are restricted to the user's session language via USERENV('LANG'). The outer joins to HZ_CLASS_CODE_DENORM ensure that secured items without a corresponding denormalized class code row are still returned.

Key Columns

Common Use Cases and Queries

Typical use cases include auditing secured class configuration and joining CONCAT_CLASS_CODE to other TCA or DSS objects.

  • List all active secured classes for a given group: 
    SELECT SECURED_ITEM_ID, CLASS_CATEGORY_NAME, CLASS_NAME, CONCAT_CLASS_CODE, STATUS
FROM   HZ_DSS_SECURED_CLASSES_V
WHERE  DSS_GROUP_CODE = :group_code
AND    STATUS = 'A';
  • Locate the concatenated class code for a specific category and class: 
    SELECT CONCAT_CLASS_CODE, CONCAT_CLASS_NAME
FROM   HZ_DSS_SECURED_CLASSES_V
WHERE  CLASS_CATEGORY = :category
AND    CLASS_CODE = :class_code;
  • Join to denormalized data to validate classification mappings and isolate entries lacking a denormalized class code (CONCAT_CLASS_CODE IS NULL).