Search Results as_sales_groups_pk

Overview

The AS_SALES_GROUPS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, residing in the OSM schema. It serves as the foundational table for defining and storing sales group entities in the Sales Foundation (AS) module. A sales group is a logical organizational unit used to aggregate sales resources, typically for management reporting, territory alignment, and quota assignment. The table's primary role is to act as the master source for all sales group definitions, providing a unique identifier and descriptive attributes that are referenced throughout the sales force automation and compensation structures of the application.

Key Information Stored

The table's structure is centered on uniquely identifying and describing a sales group. The primary key column, SALES_GROUP_ID, is the system-generated unique identifier for each sales group record. While the provided ETRM metadata does not list all columns, standard implementation patterns for such a table typically include columns for the group's name (e.g., SALES_GROUP_NAME), a description, effective start and end dates for managing the group's lifecycle, and attributes for enabling or disabling the group. The existence of a primary key constraint named AS_SALES_GROUPS_PK on the SALES_GROUP_ID column confirms its role as the central unique reference.

Common Use Cases and Queries

This table is primarily used in administrative setups and downstream reporting. Common operational scenarios include creating new sales teams, modifying existing group structures, and assigning salespeople to these groups via the related AS_SALESFORCE table. A fundamental query to retrieve all active sales groups would leverage the primary identifier and descriptive fields. For example:

• SELECT sales_group_id, sales_group_name, description FROM osm.as_sales_groups WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

Reporting use cases often involve joining AS_SALES_GROUPS with the AS_SALESFORCE table to analyze sales force distribution or with opportunity and forecast tables to measure performance by group. Its data is critical for generating managerial hierarchy reports and calculating aggregated sales metrics for compensation plans.

Related Objects

The most direct and documented relationship for the AS_SALES_GROUPS table is with the AS_SALESFORCE table. A foreign key constraint exists where the SALES_GROUP_ID column in AS_SALESFORCE references the SALES_GROUP_ID primary key in AS_SALES_GROUPS. This enforces referential integrity, ensuring that every salesperson assigned to a group in the AS_SALESFORCE table corresponds to a valid record in the master AS_SALES_GROUPS table. While not listed in the excerpt, this table is also likely referenced by other objects within the AS module, such as territory definitions, quota assignment tables, and various sales analytics views, forming a central node in the sales organization data model.