Search Results hz_class_category_uses




Overview
Explore in AI Chat

Overview

The HZ_CLASS_CATEGORY_USES table is a core reference table within the Oracle E-Business Suite Trading Community Architecture (TCA) framework, specifically under the AR (Receivables) product schema. Its primary function is to define and enforce the permissible relationships between classification categories and the specific business objects, or "owner tables," that can utilize them. This table acts as a control mechanism, ensuring that classification data, such as customer categories or account statuses, is correctly and consistently applied only to the appropriate entity types (e.g., parties, customer accounts, locations) across the application. By governing these associations, it maintains data integrity within the complex TCA model.

Key Information Stored

The table's structure is focused on mapping two critical pieces of information. The CLASS_CATEGORY column stores the identifier for a specific classification scheme defined in the HZ_CLASS_CATEGORIES table. The OWNER_TABLE column, which was the focus of the user's search, is pivotal; it stores the name of the database table (e.g., HZ_PARTIES, HZ_CUST_ACCOUNTS) that is authorized to use the linked class category. Together, these columns form the table's primary key (HZ_CLASS_CATEGORY_USES_PK), meaning each combination of a category and an owner table is unique. This design prevents a single classification category from being incorrectly assigned to multiple, unrelated entity types.

Common Use Cases and Queries

This table is primarily accessed for validation, setup, and reporting on classification rules. A common administrative task is to review all classification categories available for a specific entity. For example, to determine which categories can be assigned to Customer Accounts, one would query: SELECT CLASS_CATEGORY FROM HZ_CLASS_CATEGORY_USES WHERE OWNER_TABLE = 'HZ_CUST_ACCOUNTS';. Conversely, to identify all entity types that can use a specific category like 'CUSTOMER_CATEGORY': SELECT OWNER_TABLE FROM HZ_CLASS_CATEGORY_USES WHERE CLASS_CATEGORY = 'CUSTOMER_CATEGORY';. These relationships are critical when extending TCA or troubleshooting issues where classifications appear unavailable for certain data entry forms.

Related Objects

The HZ_CLASS_CATEGORY_USES table has a direct and essential dependency on the HZ_CLASS_CATEGORIES table via a foreign key constraint on the CLASS_CATEGORY column. HZ_CLASS_CATEGORIES stores the master definition of the classification categories themselves. The owner tables referenced in the OWNER_TABLE column, such as HZ_PARTIES or HZ_CUST_ACCOUNTS, are the ultimate consumers of this mapping. In practice, application logic and public APIs (like those in the HZ_CLASSIFICATION_V2PUB package) rely on the relationships defined in HZ_CLASS_CATEGORY_USES to validate and process classification data for business entities.