Search Results hz_cust_profile_classes

Overview

The HZ_CUST_PROFILE_CLASSES table is a core data object within the Oracle E-Business Suite Receivables (AR) module. It serves as the master repository for defining standard credit profile classes. These profile classes act as templates that establish default credit management policies, such as credit limits, risk codes, and payment terms. The primary role of this table is to provide a centralized, reusable set of credit rules that can be efficiently assigned to customer profiles, thereby standardizing and streamlining the credit control process across the enterprise.

Key Information Stored

The table's structure is designed to hold the definitional attributes of a credit profile class. While the provided metadata specifies the primary key column, the table typically contains several other critical columns based on standard Oracle TCA (Trading Community Architecture) and Receivables data models. The central column is PROFILE_CLASS_ID, which is the unique identifier (primary key) for each class. Other standard columns often include PROFILE_CLASS_NAME for the descriptive name, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE for auditing. The table stores the class-level defaults, while the detailed, currency-specific financial amounts (like credit limits) for each class are stored in the related child table, HZ_CUST_PROF_CLASS_AMTS.

Common Use Cases and Queries

This table is central to credit management setup and inquiry. A common use case is during customer account creation, where a profile class is selected to automatically populate the customer's credit profile with predefined rules. For reporting, administrators often query this table to list all available classes or analyze class assignments. A typical query to retrieve all active profile classes would be:

• SELECT PROFILE_CLASS_ID, PROFILE_CLASS_NAME FROM HZ_CUST_PROFILE_CLASSES ORDER BY PROFILE_CLASS_NAME;

Another frequent scenario involves joining with the HZ_CUSTOMER_PROFILES table to identify which customers are assigned to a specific risk profile class for portfolio analysis.

Related Objects

As indicated by the foreign key relationships in the metadata, HZ_CUST_PROFILE_CLASSES is a parent table with key dependencies. The primary child table is HZ_CUSTOMER_PROFILES, which references PROFILE_CLASS_ID to assign a standard class to a specific customer account. The second related table is HZ_CUST_PROF_CLASS_AMTS, which stores the detailed monetary amounts (e.g., credit limit, order limit) for each profile class, typically segmented by currency. These relationships ensure data integrity, where a profile class must exist before it can be assigned to a customer or have detailed amount records.