Search Results jtf_rs_salesreps




Overview
Explore in AI Chat

Overview

The JTF_RS_SALESREPS table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module. It serves as the central repository for storing master information about sales representatives across the application. This table is integral to the Resource Manager functionality, linking sales personnel data to other critical CRM and financial operations such as territory management, sales credit assignment, and resource tracking. Its role is to maintain a definitive list of sales reps, each uniquely identified, enabling consistent referencing throughout the suite for processes like opportunity management, order booking, and commission calculations.

Key Information Stored

The table's primary key is the SALESREP_ID, a unique system-generated identifier for each sales representative record. As indicated by the metadata, a critical business rule is enforced where, if the associated resource's category is 'OTHERS', the combination of SALESREP_NUMBER (a user-facing identifier) and ORG_ID (the operating unit identifier) must be unique. While the provided metadata does not list all columns, based on its purpose and common schema patterns, the table typically stores attributes such as the sales representative's name, active status (e.g., START_DATE_ACTIVE, END_DATE_ACTIVE), associated RESOURCE_ID (linking to the JTF_RS_RESOURCE_EXTNS table), job title, email address, and the ORG_ID for multi-org security. The RESOURCE_ID foreign key is explicitly documented, establishing the link to the broader resource management framework.

Common Use Cases and Queries

This table is frequently accessed for reporting, data validation, and integration tasks. A common use case is generating a list of active sales representatives within a specific operating unit for assignment in sales orders or opportunities. Another is validating salesrep data during migration or interfacing from external systems. Sample SQL patterns include retrieving basic rep information for a dropdown list or validating the existence of a rep ID. For example:
SELECT salesrep_id, salesrep_number, name FROM jtf_rs_salesreps WHERE org_id = :p_org_id AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
It is also central to queries that join sales performance data with rep master information from related transactional tables.

Related Objects

The JTF_RS_SALESREPS table has defined relationships with several other key EBS objects, as per the provided foreign key metadata. It is a parent table to:

  • JTF_RS_SRP_TERRITORIES: Stores territory assignments for each sales representative.
  • FII_AR_SALES_CREDITS: Used by the Financial Intelligence (FII) schema for analytical reporting on sales credits attributed to reps.
It is a child table to:
  • JTF_RS_RESOURCE_EXTNS: The foundational resource table, linking the salesrep to a more general resource entity which may have additional classifications and attributes.
This network of relationships underscores the table's importance in connecting CRM resource data with territory management and financial analytics.