Search Results ibe_ecr_quotes_fact

Overview

The HZ_CUST_ACCOUNTS table is a core data object within the Oracle E-Business Suite (EBS) Trading Community Architecture (TCA) and Receivables (AR) modules. It serves as the central repository for storing information about customer accounts. In the TCA model, it functions as the crucial link between a business entity (Party) and its commercial relationship with the enterprise. While the HZ_PARTIES table defines the legal or functional entity itself, HZ_CUST_ACCOUNTS defines that entity in its capacity as a customer, allowing for multiple customer accounts under a single party. This table is fundamental to all customer-centric transactions, credit management, and reporting within the Order-to-Cash cycle in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is CUST_ACCOUNT_ID, which uniquely identifies each customer account record. Two critical foreign key relationships anchor the table to the TCA foundation: PARTY_ID links to HZ_PARTIES to identify the underlying business entity, and SELLING_PARTY_ID can link to another party record, often used in complex channel or intercompany selling scenarios. Other significant columns typically include ACCOUNT_NUMBER (the user-facing customer identifier), ACCOUNT_NAME, STATUS (tracking active or inactive status), CUSTOMER_TYPE, CUSTOMER_CLASS_CODE, and various date and attribute columns for categorization and business rule application. The structure enables a single legal entity (Party) to have multiple customer accounts for different divisions, brands, or business relationships.

Common Use Cases and Queries

This table is central to operational and analytical reporting. Common use cases include generating customer master lists, analyzing customer relationships, and supporting transaction processing. A fundamental query retrieves active customer accounts with their core details:

• SELECT ca.account_number, ca.account_name, p.party_name, ca.status FROM hz_cust_accounts ca, hz_parties p WHERE ca.party_id = p.party_id AND ca.status = 'A';

For transactional analysis, it is frequently joined to Receivables tables like RA_CUSTOMER_TRX_ALL to link invoices to the customer account. It is also essential for credit management queries, joining to AR_CREDIT_HISTORIES to assess customer credit limits and exposure. Implementation teams often query this table to validate customer data setups and troubleshoot issues where transactions fail due to invalid customer account references.

Related Objects

As indicated by the extensive foreign key metadata, HZ_CUST_ACCOUNTS is heavily referenced across the EBS ecosystem. Its primary relationship is with HZ_PARTIES. Within Receivables, it is directly referenced by core transaction tables including AR_CASH_RECEIPTS_ALL (for receipts), AR_ADJUSTMENTS_REP_ITF, AR_CREDIT_HISTORIES, and AR_CUSTOMER_CALLS_ALL. The table HZ_CUST_ACCT_SITES_ALL stores the operational sites (addresses, contacts, uses) associated with each customer account, forming a key hierarchy. Furthermore, it is referenced by other modules such as Advanced Pricing (AMS_EVENT_REGISTRATIONS) and Payables (AP_BANK_ACCOUNT_USES_ALL), demonstrating its enterprise-wide role as the definitive source for customer account identifiers.