Results for “ar_hcust_prof_class_amounts”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_HCUST_PROF_CLASS_AMOUNTS is a Receivables (AR) reporting view in Oracle EBS 12.1.1 and 12.2.2 that exposes customer profile class amount limits on a per-currency basis. A customer profile class defines default credit, dunning, statement, and interest treatment for a group of customers. Because monetary limits such as credit limits and minimum dunning amounts are currency-specific, they are stored one row per profile class per currency, and this view flattens that structure for query and reporting purposes.

The view is registered in ETRM as a synonym-style wrapper over the base table HZ_CUST_PROF_CLASS_AMTS, with the view text performing a direct column projection (SELECT ... FROM HZ_CUST_PROF_CLASS_AMTS). It carries no transformation or filtering logic; its purpose is compatibility and naming convention, presenting profile class amount limits under an AR-prefixed name while the physical storage resides in the Oracle Trading Community (HZ) schema. The view is documented as "Not implemented in this database," indicating it may not exist in every environment and should be verified before use in custom code.

Underlying Base Objects

The documented base object is HZ_CUST_PROF_CLASS_AMTS, the HZ table that stores currency-level amount limits for customer profile classes. The view exposes the same column set, with one notable naming difference: the view lists both PROFILE_CLASS_ID and CUSTOMER_PROFILE_CLASS_ID in its column listing, while the view text projects PROFILE_CLASS_ID from the base table. Row identity is the primary key column PROFILE_CLASS_AMOUNT_ID (documented in the column list as CUST_PROF_CLASS_AMOUNT_ID), which uniquely identifies each profile-class-and-currency combination.

Because the view is a straight projection, joins, indexes, and performance characteristics are inherited entirely from HZ_CUST_PROF_CLASS_AMTS. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are passed through unchanged.

Key Columns

• PROFILE_CLASS_AMOUNT_ID — Primary key identifying the profile class/currency amount record.
• PROFILE_CLASS_ID — Foreign key to the customer profile class; links back to HZ_CUST_PROFILE_CLASSES.
• CURRENCY_CODE — The currency in which the following limits are expressed.
• TRX_CREDIT_LIMIT / OVERALL_CREDIT_LIMIT — Transaction-level and aggregate credit limits for the profile class in this currency.
• MIN_DUNNING_AMOUNT, MIN_DUNNING_INVOICE_AMOUNT — Thresholds governing when dunning letters are generated.
• MAX_INTEREST_CHARGE, INTEREST_RATE — Late-charge parameters applied to overdue balances.
• MIN_STATEMENT_AMOUNT — Minimum balance required before a statement is produced.
• AUTO_REC_MIN_RECEIPT_AMOUNT — Minimum receipt amount eligible for automatic receipt application.
• MIN_FC_BALANCE_AMOUNT, MIN_FC_INVOICE_AMOUNT — Foreign-currency balance and invoice minimums.
• ATTRIBUTE_CATEGORY / ATTRIBUTE1–15 — Standard descriptive flexfield (DFF) columns.
• JGZZ_ATTRIBUTE_CATEGORY / JGZZ_ATTRIBUTE1–15 — Global descriptive flexfield columns; JGZZ_ATTRIBUTE_CATEGORY is the context column returned by the user search term "jgzz_attribute_category".
• GLOBAL_ATTRIBUTE_CATEGORY / GLOBAL_ATTRIBUTE1–20 — Additional global attribute storage for localization and seeding.

Common Use Cases and Queries

Typical uses include credit management reporting, dunning configuration validation, and integration extracts that feed downstream collections or credit systems. A representative query joins the view to profile class and customer definitions to report limits by currency and customer:

• List credit limits for a profile class: SELECT currency_code, trx_credit_limit, overall_credit_limit FROM ar_hcust_prof_class_amounts WHERE profile_class_id = :p_profile_class_id;
• Report dunning thresholds: SELECT currency_code, min_dunning_amount, min_dunning_invoice_amount FROM ar_hcust_prof_class_amounts WHERE currency_code = 'USD';
• Extract flexfield context values: SELECT profile_class_id, currency_code, jgzz_attribute_category FROM ar_hcust_prof_class_amounts WHERE jgzz_attribute_category IS NOT NULL;
• Join to HZ_CUST_PROFILE_CLASSES for profile class names when building credit-limit dashboards.

Since the view is a direct projection and is documented as not implemented in all databases, developers should confirm its existence in the target instance and, where absent, query HZ_CUST_PROF_CLASS_AMTS directly using the equivalent column names.