Search Results ar_customer_profile_classes




Overview
Explore in AI Chat

Overview

The AR_CUSTOMER_PROFILE_CLASSES table is a core master data object within Oracle E-Business Suite Receivables (AR) modules, specifically in versions 12.1.1 and 12.2.2. It serves as the central repository for defining and storing customer profile class templates. A profile class is a reusable set of credit, collections, and payment rules that can be assigned to multiple customers, ensuring consistent policy application and simplifying customer setup. This table is fundamental to the credit management and collections processes, acting as a template from which individual customer profile records (AR_CUSTOMER_PROFILES) inherit their default attributes.

Key Information Stored

The table's primary identifier is the system-generated CUSTOMER_PROFILE_CLASS_ID. The NAME column is a unique, user-defined identifier for the profile class. Beyond these, the table stores foreign keys that link to critical control data, defining the class's behavior. As per the provided metadata, these include COLLECTOR_ID (linking to AR_COLLECTORS), DUNNING_LETTER_SET_ID (linking to AR_DUNNING_LETTER_SETS), STATEMENT_CYCLE_ID (linking to AR_STATEMENT_CYCLES), AUTOCASH_HIERARCHY_ID (linking to AR_AUTOCASH_HIERARCHIES), and GROUPING_RULE_ID (linking to RA_GROUPING_RULES). While the metadata excerpt does not list all columns, typical columns also include descriptions, creation dates, and status indicators.

Common Use Cases and Queries

The primary use case is the centralized management of credit and collections policies. Administrators create or modify profile classes here, and the changes can propagate to all associated customer profiles. Common reporting and query scenarios include identifying all customers assigned to a specific profile class, auditing which classes use a particular collector or dunning set, and listing all active profile classes. A sample SQL pattern to retrieve core class information is:

  • SELECT name, description, collector_id, dunning_letter_set_id FROM ar_customer_profile_classes WHERE enabled_flag = 'Y' ORDER BY name;

Another critical query joins this table to AR_CUSTOMER_PROFILES and HZ_CUST_ACCOUNTS to analyze customer assignments: SELECT hca.account_number, hca.account_name, acpc.name profile_class FROM hz_cust_accounts hca, ar_customer_profiles acp, ar_customer_profile_classes acpc WHERE hca.cust_account_id = acp.customer_id AND acp.customer_profile_class_id = acpc.customer_profile_class_id;

Related Objects

As indicated by the foreign key relationships, AR_CUSTOMER_PROFILE_CLASSES is a hub table with several key dependencies. The AR_CUSTOMER_PROFILES table is the most direct child, where each record may reference a profile class ID. The AR_CUST_PROF_CLASS_AMOUNTS table stores currency-specific credit limits and balance amounts for each class. For integration with Cash Management, the CE_FORECAST_ROWS table can reference profile classes for cash forecasting. The table draws its rule definitions from important reference tables: AR_COLLECTORS, AR_DUNNING_LETTER_SETS, AR_STATEMENT_CYCLES, AR_AUTOCASH_HIERARCHIES, and RA_GROUPING_RULES. Data is typically created and maintained via the Oracle Forms interface or the public Customer Profile Class API.