Search Results ra_customers




Overview
Explore in AI Chat

Overview

The RA_CUSTOMERS table is the central repository for master customer information within Oracle E-Business Suite Receivables (AR) and serves as a foundational data object for the entire order-to-cash cycle. It stores the core identifying and descriptive attributes for a business's customer entities, which are shared and referenced across numerous EBS modules. Its role is critical, acting as the primary source of truth for customer data, enabling integrated business processes in Order Management, Service, and other financial and operational applications.

Key Information Stored

The table's primary identifier is the system-generated CUSTOMER_ID, with CUSTOMER_NUMBER serving as a unique business key. Key descriptive columns include PARTY_ID, linking to the Trading Community Architecture (TCA) party model, and attributes like CUSTOMER_NAME, CUSTOMER_CLASS_CODE, and CUSTOMER_TYPE. It also holds critical operational references that define default business rules for a customer, such as PRIMARY_SALESREP_ID, PAYMENT_TERM_ID, PRICE_LIST_ID, and ORDER_TYPE_ID. Additional columns manage communication preferences and default sites for activities like dunning (DUNNING_SITE_USE_ID) and statements (STATEMENT_SITE_USE_ID).

Common Use Cases and Queries

Common use cases include generating customer master lists, analyzing customer classifications, and troubleshooting transaction issues by verifying a customer's default setup. A typical query retrieves a customer's core details and linked default values:

  • SELECT customer_id, customer_number, customer_name, customer_class_code, primary_salesrep_id, payment_term_id FROM ra_customers WHERE customer_number = '&CUST_NUM';

For reporting, RA_CUSTOMERS is frequently joined to transaction tables like RA_CUSTOMER_TRX_ALL and site tables like HZ_CUST_SITE_USES_ALL to analyze sales or payment history by customer segment. Developers also query this table to validate customer IDs before creating transactions via APIs or custom interfaces.

Related Objects

RA_CUSTOMERS has extensive relationships across the EBS suite, as evidenced by its foreign keys. Key related objects include: