Results for “ar_customer_profile_classes”

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

Overview

AR_CUSTOMER_PROFILE_CLASSES is a Receivables (AR) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores customer profile class information. A customer profile class is a reusable template of default collection, credit, statement, dunning, interest, and payment attributes that can be assigned to one or many customer profiles. Rather than configuring these parameters individually for every customer, organizations define profile classes and let profile assignment cascade the defaults. The table is owned by the AR schema and is documented as VALID in ETRM with 95 columns.

From a Data Vault modeling perspective, the ETRM heuristic classification for this object is satellite-leaning. This is appropriate, since the table functions primarily as a descriptive attribute container holding a broad set of configurable parameters tied to a business key (NAME) and a surrogate key (CUSTOMER_PROFILE_CLASS_ID), rather than acting as a pure hub or link.

Key Information Stored

The table is anchored by the surrogate primary key CUSTOMER_PROFILE_CLASS_ID, enforced by both AR_CUSTOMER_PROFILE_CLASSES_PK and unique index AR_CUSTOMER_PROFILE_CLASSES_U1. A second business-key candidate is defined on NAME via AR_CUSTOMER_PROFILE_CLASSES_UK, so NAME effectively serves as the user-facing unique identifier of the profile class.

Among the most significant configuration columns are:

• NAME, DESCRIPTION, STATUS — the profile class identifier, descriptive text, and active/inactive status.
• COLLECTOR_ID — the default collector (foreign key to AR_COLLECTORS).
• CREDIT_CHECKING, TOLERANCE, REVIEW_CYCLE_DAYS — credit control behavior.
• STANDARD_TERMS, OVERRIDE_TERMS, UNIQUE_TERMS, DISCOUNT_TERMS — payment term handling.
• DUNNING_LETTERS, AUTO_DUNNING_DAYS, DUNNING_LETTER_SET_ID, COMBINE_DUNNING_LETTERS — dunning configuration (DUNNING_LETTER_SET_ID references AR_DUNNING_LETTER_SETS).
• INTEREST_CHARGES, INTEREST_PERIOD_DAYS, CHARGE_ON_FINANCE_CHARGE_FLAG — late-charge interest rules.
• STATEMENTS, CREDIT_BALANCE_STATEMENTS, STATEMENT_CYCLE_ID — statement generation (STATEMENT_CYCLE_ID references AR_STATEMENT_CYCLES).
• PRIMARY_AUTO_CASH_METHOD, AUTOCASH_HIERARCHY_ID, PAYMENT_GRACE_DAYS, DISCOUNT_GRACE_DAYS — receipt application defaults (AUTOCASH_HIERARCHY_ID references AR_AUTOCASH_HIERARCHIES).
• GROUPING_RULE_ID — references RA_GROUPING_RULES for revenue grouping.
• ATTRIBUTE1–15, GLOBAL_ATTRIBUTE1–20, JGZZ_ATTRIBUTE1–15 — descriptive flexfield and global descriptive flexfield segments.
• WHO columns and REQUEST_ID — audit and concurrent request context.

Common Use Cases and Queries

Typical usage includes reporting the default collection parameters applied to customer bases, validating that profile classes are correctly linked to collectors and dunning letter sets, and diagnosing why a given customer exhibits particular credit or statement behavior. Because profiles inherit from classes, joins to AR_CUSTOMER_PROFILES are common.

Illustrative query patterns include:

• Listing all active profile classes: SELECT customer_profile_class_id, name, status FROM ar_customer_profile_classes WHERE status = 'A';
• Finding all customers assigned to a given class: join AR_CUSTOMER_PROFILES on CUSTOMER_PROFILE_CLASS_ID.
• Reviewing dunning configuration: join AR_DUNNING_LETTER_SETS on DUNNING_LETTER_SET_ID.
• Checking statement cycles: join AR_STATEMENT_CYCLES on STATEMENT_CYCLE_ID.

Related Objects

AR_CUSTOMER_PROFILE_CLASSES is referenced by several dependent tables and references several lookup tables via foreign keys:

• AR_CUSTOMER_PROFILES — references CUSTOMER_PROFILE_CLASS_ID; the primary consumer of profile class defaults.
• AR_CUST_PROF_CLASS_AMOUNTS — references CUSTOMER_PROFILE_CLASS_ID, storing per-currency amount thresholds.
• CE_FORECAST_ROWS — references CUSTOMER_PROFILE_CLASS_ID for cash forecasting.
• AR_COLLECTORS — referenced via COLLECTOR_ID.
• AR_DUNNING_LETTER_SETS — referenced via DUNNING_LETTER_SET_ID.
• AR_STATEMENT_CYCLES — referenced via STATEMENT_CYCLE_ID.
• AR_AUTOCASH_HIERARCHIES — referenced via AUTOCASH_HIERARCHY_ID.
• RA_GROUPING_RULES — referenced via GROUPING_RULE_ID.