Search Results srp_quota_rule_id




Overview
Explore in AI Chat

Overview

The CN_SRP_QUOTA_RULES_ALL table is a core data entity within the Oracle E-Business Suite Incentive Compensation (CN) module, specifically in versions 12.1.1 and 12.2.2. It functions as a junction table that establishes the linkage between a salesperson's quota assignments and the specific quota rules and revenue classes that define their compensation plan. Its primary role is to store the association of quota rules, which dictate performance measurement criteria, to individual sales representatives (SRPs) within the context of their assigned plans and quotas. This table is critical for the operational logic of calculating commissions, as it determines which rules apply to which salesperson and for which revenue categories.

Key Information Stored

While the provided metadata does not list all columns, the foreign key relationships and primary key define its essential structure. The central column is SRP_QUOTA_RULE_ID, the primary key that uniquely identifies each rule assignment record. The table's foreign key columns are its most critical data points: SRP_PLAN_ASSIGN_ID links to the salesperson's overall plan assignment (CN_SRP_PLAN_ASSIGNS_ALL). SRP_QUOTA_ASSIGN_ID links to their specific quota assignment (CN_SRP_QUOTA_ASSIGNS_ALL). QUOTA_RULE_ID links to the definition of the quota rule itself (CN_QUOTA_RULES_ALL). Finally, REVENUE_CLASS_ID links to the classification of revenue (CN_REVENUE_CLASSES_ALL), indicating the type of sales transaction to which the rule applies. Collectively, these columns answer who (SRP), under what plan and quota, is governed by which rule, for which type of revenue.

Common Use Cases and Queries

This table is central to compensation analytics and troubleshooting. A common use case is generating a report of all active quota rules applied to a sales team. Administrators may query this table to validate rule assignments during plan configuration. A typical diagnostic query would join to related assignment and definition tables to list rule details per salesperson:

  • Identifying rules for a specific salesperson: SELECT sra.* FROM cn_srp_quota_rules_all sra, cn_srp_plan_assigns_all spa WHERE sra.srp_plan_assign_id = spa.srp_plan_assign_id AND spa.salesrep_id = <rep_id>;
  • Reporting on all rule assignments with descriptive names: SELECT spa.salesrep_id, qa.name quota_assign_name, qr.name rule_name, rc.name revenue_class FROM cn_srp_quota_rules_all sqra, cn_srp_plan_assigns_all spa, cn_srp_quota_assigns_all qa, cn_quota_rules_all qr, cn_revenue_classes_all rc WHERE sqra.srp_plan_assign_id = spa.srp_plan_assign_id AND sqra.srp_quota_assign_id = qa.srp_quota_assign_id AND sqra.quota_rule_id = qr.quota_rule_id AND sqra.revenue_class_id = rc.revenue_class_id;

Related Objects

The CN_SRP_QUOTA_RULES_ALL table sits at a key intersection in the Incentive Compensation schema, with documented relationships to several other tables.

  • Referenced Tables (Foreign Keys FROM this table):
    • CN_SRP_PLAN_ASSIGNS_ALL: Joined via SRP_PLAN_ASSIGN_ID. Links the rule to the salesperson's plan assignment.
    • CN_SRP_QUOTA_ASSIGNS_ALL: Joined via SRP_QUOTA_ASSIGN_ID. Links the rule to the specific quota assignment.
    • CN_QUOTA_RULES_ALL: Joined via QUOTA_RULE_ID. Provides the definition and logic of the quota rule.
    • CN_REVENUE_CLASSES_ALL: Joined via REVENUE_CLASS_ID. Defines the revenue class (e.g., Product, Service) to which the rule applies.
  • Referencing Table (Foreign Key TO this table):
    • CN_SRP_RULE_UPLIFTS_ALL: Joined via SRP_QUOTA_RULE_ID. Stores uplift adjustments that are specifically tied to an instance of a quota rule assigned to a salesperson.