Search Results hz_customer_profiles




Overview
Explore in AI Chat

Overview

HZ_CUSTOMER_PROFILES is the Oracle Receivables (AR) table that stores credit, collections, and billing profile information for customer accounts and customer account sites. It sits within the Trading Community Architecture (TCA) data model and holds the "credit side" of a customer relationship — the settings that drive credit checking, dunning, statements, interest charges, late charges, and autcash/collection behavior. A single customer account, or a specific site use within that account, can carry one profile record that governs how Receivables treats its transactions.

Because the table's primary key is a surrogate identifier and its columns describe attributes of a referenced account, site use, or party, the heuristic Data Vault classification is satellite-leaning. In Data Vault terms it is best modeled as a satellite hanging off a customer account or party hub, rather than a hub or link in its own right.

Key Information Stored

The table contains 120 documented columns. The most operationally significant include:

Common Use Cases and Queries

Typical reporting and integration scenarios include identifying customers on credit hold, listing accounts assigned to a given collector, and reconciling statement cycles.

SELECT p.cust_account_id, p.party_id, p.status,
       p.credit_hold, p.credit_rating, p.risk_code
FROM   hz_customer_profiles p
WHERE  p.credit_hold = 'Y';

Joining to the account master to report customer name and account number:

SELECT a.account_number, p.credit_rating, p.collector_id
FROM   hz_customer_profiles p,
       hz_cust_accounts     a
WHERE  p.cust_account_id = a.cust_account_id
AND    p.status = 'A';

Other common uses include feeding dunning and statement processes, extracting credit classification for risk dashboards, and joining to HZ_CUST_PROFILE_AMTS to report per-currency credit limits that complete the profile.

Related Objects