Search Results as_salesforce




Overview
Explore in AI Chat

Overview

The RA_SALESREPS_ALL table is a core data repository within Oracle E-Business Suite (EBS) Receivables (AR) module, specifically designed to store master information about salespeople or sales representatives. Its primary role is to serve as the central reference for salesperson data, enabling the assignment of sales credit, commission calculations, and revenue tracking across the order-to-cash cycle. As a multi-organization table (indicated by the "_ALL" suffix), it stores data for all operating units defined within the instance, making it integral to multi-org architectures in versions 12.1.1 and 12.2.2. The table's extensive foreign key relationships underscore its critical integration with modules like Order Management (OE), General Ledger (GL), and Projects (PA).

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign keys reveal the essential data linkages. The table is uniquely identified by the SALESREP_ID primary key. Crucially, it stores accounting and structural references for each salesperson, including the SET_OF_BOOKS_ID and several General Ledger account combinations (GL_ID_REV for revenue, GL_ID_FREIGHT, and GL_ID_REC for receivables). These GL links ensure sales transactions are posted to the correct financial segments. Other significant foreign keys include SALES_CREDIT_TYPE_ID (linking to commission types) and SALESFORCE_ID for integration with the sales force management functionality. The table likely also stores descriptive columns such as the salesperson's name, employee number, active status, and commission rates.

Common Use Cases and Queries

This table is fundamental for operational reporting and transactional integrity. Common use cases include generating sales performance reports, validating salesperson assignments during order entry, and ensuring accurate GL account derivation during invoice creation. A typical query might join RA_SALESREPS_ALL to transaction tables to analyze sales credit. For example, to list invoices with their primary sales representative, one would query:

  • SELECT trx.trx_number, srp.name FROM ra_customer_trx_all trx JOIN ra_salesreps_all srp ON trx.primary_salesrep_id = srp.salesrep_id WHERE trx.org_id = :p_org_id;

Another critical pattern involves validating the setup by checking for salespeople missing required GL account assignments, which could cause posting errors.

Related Objects

As evidenced by the foreign key constraints, RA_SALESREPS_ALL is a hub table referenced by numerous transactional entities across EBS. Key related objects include:

This network of dependencies highlights that RA_SALESREPS_ALL is not merely a standalone list but a foundational component of the sales and accounting data model.