Search Results hz_cust_prof_class_amts




Overview
Explore in AI Chat

Overview

The HZ_CUST_PROF_CLASS_AMTS table is a core data object within the Oracle E-Business Suite Receivables (AR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the repository for defining and storing currency-specific credit and risk amount limits associated with customer profile classes. A profile class is a template that groups customers with similar credit characteristics. This table enables the assignment of distinct financial thresholds, such as credit limits and order amount limits, for each currency in which a customer classified under that profile may transact. Its role is fundamental to the system's credit management and risk assessment engine, ensuring that customer transaction limits are enforced on a per-currency basis according to their assigned profile class.

Key Information Stored

The table's primary purpose is to link a profile class, a currency, and specific monetary limits. Its structure is centered around the PROFILE_CLASS_AMOUNT_ID primary key column. The most critical columns include PROFILE_CLASS_ID, which foreign-key references HZ_CUST_PROFILE_CLASSES to identify the parent profile class, and CURRENCY_CODE, which specifies the currency for the associated limits. The table stores various amount limit columns, which typically include fields for credit limit, order limit, and potentially other risk-related monetary thresholds. These columns define the maximum allowable transaction values for customers assigned to the linked profile class when conducting business in the specified currency.

Common Use Cases and Queries

The primary use case is the configuration and maintenance of multi-currency credit policies. Administrators use this table to define, for example, that a "Standard Commercial" profile class has a credit limit of 50,000 USD and 40,000 EUR. Common operational queries involve retrieving all currency-specific limits for a given profile class or validating a transaction amount against the appropriate limit. A typical reporting SQL pattern joins this table to the profile class and currency tables:

  • SELECT pca.profile_class_id, pca.currency_code, pca.credit_limit, hcp.name FROM hz_cust_prof_class_amts pca, hz_cust_profile_classes hcp WHERE pca.profile_class_id = hcp.profile_class_id ORDER BY hcp.name, pca.currency_code;

This data is critical for credit check concurrent programs and real-time validation during order entry and invoicing workflows within Order Management and Receivables.

Related Objects

HZ_CUST_PROF_CLASS_AMTS is centrally connected to several key Trading Community Architecture (TCA) and Receivables objects. Its most direct parent is the HZ_CUST_PROFILE_CLASSES table, which holds the master definition of the profile class. A foreign key constraint enforces this relationship on the PROFILE_CLASS_ID column. Furthermore, the table is referenced by the HZ_CREDIT_USAGES table via the PROFILE_CLASS_AMOUNT_ID, which tracks the actual consumption of these credit limits by customer accounts. In application logic, this table is accessed and maintained through standard Oracle Customer Data Management (CDM) and Credit Management APIs, which ensure data integrity and proper validation.