Search Results hz_class_categories




Overview
Explore in AI Chat

Overview

The HZ_CLASS_CATEGORIES table is a core reference table within Oracle E-Business Suite's Trading Community Architecture (TCA) model, specifically under the Receivables (AR) product family. It serves as the master definition table for classification categories, which are the high-level groupings used to classify parties, organizations, and related entities. These categories provide a flexible framework for segmenting and categorizing the trading community based on various business dimensions, such as industry type, geographic region, customer tier, or any other user-defined classification. The table's primary role is to establish the valid categories to which specific classification codes can be assigned, enabling structured and consistent categorization across the application.

Key Information Stored

The table's structure is designed to define and control classification categories. The primary key column, CLASS_CATEGORY, stores the unique identifier for each classification category. While the provided metadata does not list all columns, based on standard TCA implementation, other critical columns typically include CONTENT_SOURCE_TYPE, STATUS, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE. The CLASS_CATEGORY value acts as a key reference point throughout the classification system, determining where and how codes within that category can be applied to party records.

Common Use Cases and Queries

A primary use case is the setup and maintenance of the classification system during application implementation or enhancement. Administrators populate this table with categories relevant to their business analysis and reporting needs. Common queries involve listing all active classification categories or verifying the setup before assigning codes to parties. For example, to retrieve all defined categories, a query such as SELECT class_category FROM hz_class_categories WHERE status = 'A' ORDER BY class_category; is used. In reporting scenarios, this table is joined to HZ_CODE_ASSIGNMENTS and HZ_PARTIES to analyze the distribution of parties across different classification categories, such as industry or customer segment.

Related Objects

As indicated by the foreign key relationships in the metadata, HZ_CLASS_CATEGORIES is central to the classification data model. Key dependent objects include:

  • HZ_CLASS_CATEGORY_USES: Defines which object types (e.g., PARTY, PARTY_SITE) a specific classification category can be assigned to.
  • HZ_CLASS_CODE_RELATIONS: Stores hierarchical or other relationships between classification codes within a category.
  • HZ_CODE_ASSIGNMENTS: The core transactional table that records which specific classification code from a category is assigned to a given party or entity.
  • ZX_FC_TYPES_B: A table from the E-Business Tax (ZX) module that can reference classification categories, linking tax rules to party classifications.
These relationships ensure that classification categories are consistently governed and applied across the TCA model.