Search Results cn_role_quota_rates




Overview
Explore in AI Chat

Overview

The CN_ROLE_QUOTA_RATES table is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module, specifically in versions 12.1.1 and 12.2.2. It serves as a critical junction table that governs the assignment of compensation rate structures to specific quota components defined for a sales role. This table is fundamental to the configuration of incentive plans, as it establishes the link between a salesperson's performance targets (quotas) and the corresponding payout rates or multipliers. By defining which rate table applies to a particular quota element for a given role, the system can accurately calculate commissions and bonuses based on achieved performance against assigned quotas.

Key Information Stored

The table's primary purpose is to store relationship identifiers. Its key column is the ROLE_QUOTA_RATE_ID, which serves as the unique primary key for each assignment record. The two most critical foreign key columns are RATE_SCHEDULE_ID and RATE_TIER_ID. The RATE_SCHEDULE_ID links to the CN_RATE_SCHEDULES_ALL table, identifying the specific schedule of rates (e.g., a commission percentage table). The RATE_TIER_ID links to the CN_RATE_TIERS_ALL table, pinpointing a specific tier or level within that rate schedule (e.g., the tier for 90-100% quota attainment). While the provided metadata does not list all columns, the foreign key relationships imply the table also contains a reference to a quota component (likely via a foreign key to CN_ROLE_QUOTA_CATES, though the documented foreign key is listed in reverse), thereby completing the association between role, quota, and rate.

Common Use Cases and Queries

A primary use case is the audit and verification of incentive plan setups. Compensation administrators often need to report on which rate schedules are assigned to various sales roles. A typical query would join CN_ROLE_QUOTA_RATES to CN_RATE_SCHEDULES_ALL and role-quota tables to list all assignments. Another critical scenario is during the commission calculation process, where the Incentive Compensation engine references this table to locate the correct rate tier for a salesperson's role and quota achievement. Troubleshooting miscalculated commissions often involves querying this table to ensure the intended rate schedule is correctly linked. A sample query pattern is:

  • SELECT rqr.role_quota_rate_id, rqs.name schedule_name, rqt.name tier_name
  • FROM cn_role_quota_rates rqr,
  • cn_rate_schedules_all rqs,
  • cn_rate_tiers_all rqt
  • WHERE rqr.rate_schedule_id = rqs.rate_schedule_id
  • AND rqr.rate_tier_id = rqt.rate_tier_id;

Related Objects

The CN_ROLE_QUOTA_RATES table is centrally connected to several key Incentive Compensation tables through documented foreign key relationships. It references master data for rates and is itself referenced by transactional data.

  • CN_RATE_SCHEDULES_ALL: Provides the rate schedule master data. Joined via CN_ROLE_QUOTA_RATES.RATE_SCHEDULE_ID.
  • CN_RATE_TIERS_ALL: Provides the specific tier within a rate schedule. Joined via CN_ROLE_QUOTA_RATES.RATE_TIER_ID.
  • CN_ROLE_QUOTA_CATES: Has a foreign key referencing ROLE_QUOTA_RATE_ID, indicating this table likely defines the quota component to which the rate is applied.
  • CN_SRP_QUOTA_RATES_ALL: This transactional table stores calculated quota rates for individual salespeople (SRPs). It references CN_ROLE_QUOTA_RATES.ROLE_QUOTA_RATE_ID, demonstrating how the role-level assignment is instantiated for specific employees during calculation.