Search Results class_category_name

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:

• HZ_DSS_CRITERIA (alias HDC) — the driving table holding the secured item definitions, including SECURED_ITEM_ID, STATUS, DSS_GROUP_CODE, and the owner table identifiers.
• FND_LOOKUP_TYPES_TL — supplies the translated meaning of the lookup type that the secured item references.
• FND_LOOKUP_VALUES_VL — supplies the translated meaning of the individual lookup code being secured.
• HZ_CLASS_CODE_DENORM — a denormalized class code table joined with an outer join to provide CONCAT_CLASS_CODE and its meaning.

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

• SECURED_ITEM_ID — unique identifier for the secured item record.
• STATUS — indicates whether the secured item is active or inactive.
• DSS_GROUP_CODE — the data security group this secured item belongs to.
• CLASS_CATEGORY / CLASS_CATEGORY_NAME — the lookup type and its translated meaning representing the category.
• CLASS_CODE / CLASS_NAME — the lookup code and its translated meaning representing the class.
• CONCAT_CLASS_CODE — the concatenated class code derived from HZ_CLASS_CODE_DENORM; this is the column most commonly referenced by users searching for the term "concat_class_code".
• CONCAT_CLASS_NAME — the translated meaning of the concatenated class code.
• Audit columns (OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN).

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).