Search Results cn_srp_per_quota_rc_all




Overview
Explore in AI Chat

Overview

The CN_SRP_PER_QUOTA_RC_ALL table is a core transactional table within the Oracle E-Business Suite Incentive Compensation module (CN). It serves as a junction table that establishes the relationship between salesperson period quotas and specific revenue classes. Its primary role is to store the detailed breakdown of which revenue classes—categories of income such as product lines or service types—are applicable to a salesperson's quota target for a given compensation period. This granular association is fundamental for calculating accurate commissions, as it allows the system to measure performance and apply compensation rules against specific revenue streams. The table supports multi-organization access control (MOAC) through its '_ALL' suffix, meaning it can store data for multiple operating units.

Key Information Stored

The table's structure is designed to enforce unique combinations of its key business entities. Its primary and unique keys highlight the critical data points. The surrogate primary key is SRP_PER_QUOTA_RC_ID. From a business logic perspective, the most significant columns are the foreign keys that create the essential relationships: SRP_PERIOD_QUOTA_ID links to the salesperson's overarching quota assignment for a period, SALESREP_ID identifies the resource, PERIOD_ID defines the time interval, QUOTA_ID specifies the target, and REVENUE_CLASS_ID—explicitly noted in the user's search—pinpoints the specific category of revenue to which the quota applies. The presence of REVENUE_CLASS_ID in both unique key constraints (UK1 and UK2) underscores its mandatory and non-duplicable nature within the defined contexts of a period quota or a salesperson-period-quota combination.

Common Use Cases and Queries

This table is central to quota management and commission calculation reporting. A common operational use case is validating or reporting the revenue class coverage for a sales team's quarterly targets. Analysts frequently query this table to understand quota composition. A typical reporting query would join to related dimension tables to produce a readable summary:

  • Identifying all revenue classes assigned to a specific quota: SELECT rc.name FROM cn_srp_per_quota_rc_all rc_all, cn_revenue_classes_all rc WHERE rc_all.revenue_class_id = rc.revenue_class_id AND rc_all.quota_id = :p_quota_id;
  • Analyzing a salesperson's quota breakdown for a period: SELECT q.name quota, rc.name revenue_class FROM cn_srp_per_quota_rc_all rc_all, cn_quotas_all q, cn_revenue_classes_all rc WHERE rc_all.quota_id = q.quota_id AND rc_all.revenue_class_id = rc.revenue_class_id AND rc_all.salesrep_id = :p_rep_id AND rc_all.period_id = :p_period_id;

Related Objects

As indicated by its foreign key constraints, CN_SRP_PER_QUOTA_RC_ALL has direct dependencies on several other key Incentive Compensation tables. It is a child table of CN_SRP_PERIOD_QUOTAS_ALL, which holds the main period quota record. Its relationship to CN_REVENUE_CLASSES_ALL is critical for resolving the REVENUE_CLASS_ID to a meaningful name. It also references the master quota definition in CN_QUOTAS_ALL and the salesperson's plan assignment in CN_SRP_PLAN_ASSIGNS_ALL. This table is likely referenced by various commission calculation engine packages and is a fundamental source for quota attainment and compensation analytical reports.