Search Results hz_cust_prof_class_amts_pk

Overview

HZ_CUST_PROF_CLASS_AMTS is a Receivables (AR) transactional configuration table that stores customer profile class amount limits on a per-currency basis. A customer profile class in Oracle EBS defines a reusable set of credit, collections, statement, dunning, and interest parameters that can be assigned to many customer accounts. Because credit limits, minimum dunning amounts, minimum statement amounts, and related monetary thresholds are inherently currency-sensitive, Oracle stores them in this child table rather than directly on HZ_CUST_PROFILE_CLASSES, allowing a single profile class to carry distinct amounts for each currency in which the enterprise transacts.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. Its grain is one row per profile class per currency, keyed by a surrogate identifier while the natural business key is the combination of profile class and currency code. This makes it a descriptive satellite attached to the profile class hub, with an additional dependency on interest schedules.

Key Information Stored

The table is documented with 91 columns in Release 12.2.2. The most operationally significant are the following.

• PROFILE_CLASS_AMOUNT_ID — Surrogate primary key, enforced by HZ_CUST_PROF_CLASS_AMTS_PK and also carried by the unique index HZ_CUST_PROF_CLASS_AMTS_U1.
• PROFILE_CLASS_ID — Foreign key to HZ_CUST_PROFILE_CLASSES; identifies the owning profile class. Together with CURRENCY_CODE it forms the business-key unique index HZ_CUST_PROF_CLASS_AMTS_U2.
• CURRENCY_CODE — The currency for which the monetary limits on this row apply.
• OVERALL_CREDIT_LIMIT and TRX_CREDIT_LIMIT — Aggregate and per-transaction credit ceilings used in credit checking.
• MIN_DUNNING_AMOUNT and MIN_DUNNING_INVOICE_AMOUNT — Thresholds below which dunning letters are suppressed.
• MIN_STATEMENT_AMOUNT — Minimum balance required before a statement is generated.
• MIN_INTEREST_CHARGE and MAX_INTEREST_CHARGE — Floor and cap applied to computed interest.
• INTEREST_RATE, INTEREST_TYPE, INTEREST_FIXED_AMOUNT, and INTEREST_SCHEDULE_ID — Interest calculation parameters; INTEREST_SCHEDULE_ID references CE_INTEREST_SCHEDULES.
• PENALTY_TYPE, PENALTY_RATE, PENALTY_FIXED_AMOUNT, and PENALTY_SCHEDULE_ID — Late-payment penalty configuration.
• AUTO_REC_MIN_RECEIPT_AMOUNT — Floor for automatic receipt creation.
• EXCHANGE_RATE_TYPE — Rate type used when converting these amounts.
• EXPIRATION_DATE — Effective end date for the currency-specific configuration.
• OBJECT_VERSION_NUMBER and the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) plus the ATTRIBUTE, JGZZ_ATTRIBUTE, and GLOBAL_ATTRIBUTE flexfield groups complete the row.

Common Use Cases and Queries

Typical uses include auditing credit limits by currency, reconciling profile class configuration across operating units, and tracing the source of a credit check failure.

SELECT pca.currency_code, pca.overall_credit_limit,
       pca.trx_credit_limit, pca.min_dunning_amount
FROM   hz_cust_prof_class_amts pca
WHERE  pca.profile_class_id = :profile_class_id;

SELECT pc.profile_class_name, pca.currency_code,
       pca.overall_credit_limit
FROM   hz_cust_profile_classes pc,
       hz_cust_prof_class_amts  pca
WHERE  pc.profile_class_id = pca.profile_class_id
AND    pca.overall_credit_limit IS NOT NULL;

Reporting patterns frequently aggregate limits by currency, compare configured limits against current exposure in HZ_CREDIT_USAGES, or extract rows where EXCHANGE_RATE_TYPE differs from the corporate standard.

Related Objects

• HZ_CUST_PROFILE_CLASSES — Parent table; joined on PROFILE_CLASS_ID.
• HZ_CREDIT_USAGES — References this table through PROFILE_CLASS_AMOUNT_ID, linking usage records to the currency-specific limit row.
• CE_INTEREST_SCHEDULES — Referenced by INTEREST_SCHEDULE_ID for interest computation.
• HZ_CUSTOMER_PROFILES — Assigns profile classes to customer accounts, indirectly consuming these limits.
• HZ_CUST_ACCOUNTS — Customer accounts whose credit checking resolves to these amount rows.
• AR_INTEREST_HEADERS and related interest tables — Consume the interest and penalty attributes.
• HZ_CUST_PROF_CLASS_AMTS_PK / _U1 / _U2 — Primary key and unique indexes enforcing row and business-key integrity.