Search Results cn_role_quota_cates




Overview
Explore in AI Chat

Overview

The CN_ROLE_QUOTA_CATES table is a core data object within the Oracle E-Business Suite Incentive Compensation (CN) module, specifically for versions 12.1.1 and 12.2.2. It serves as a critical junction table that governs the assignment of specific quota components to sales roles. This table is fundamental to the configuration of the compensation plan structure, enabling administrators to define which quota categories—representing measurable performance targets like revenue or units sold—are applicable to a given sales role. By linking roles, quota categories, and calculation formulas, it establishes the foundational rules for how sales performance is measured and, subsequently, how commissions are calculated.

Key Information Stored

The table's primary purpose is to maintain assignment relationships, which is reflected in its key columns. The primary key is ROLE_QUOTA_CATE_ID, a unique identifier for each assignment record. The core foreign key columns define the relationship: ROLE_ID links to CN_ROLE_DETAILS to identify the sales role, QUOTA_CATEGORY_ID links to CN_QUOTA_CATEGORIES to specify the performance metric, and ROLE_MODEL_ID links to CN_ROLE_MODELS_ALL to associate the assignment with a specific compensation role model. A critical functional column is CALC_FORMULA_ID, which references CN_CALC_FORMULAS_ALL and determines the specific formula used to calculate the quota achievement or credit for this role and category combination.

Common Use Cases and Queries

This table is central to compensation plan setup and reporting. A primary use case is during the plan design phase, where administrators query existing assignments to audit or modify the quota components tied to roles. For reporting, it is frequently joined to produce lists of all quota categories assigned to a specific sales role or to identify all roles eligible for a particular quota category. A common diagnostic query verifies the configuration for a role model, ensuring formulas are correctly assigned.

  • Sample Query (Assignments by Role): SELECT r.role_name, qc.name quota_category, cf.name formula FROM cn_role_quota_cates rqc, cn_role_details r, cn_quota_categories qc, cn_calc_formulas_all cf WHERE rqc.role_id = r.role_id AND rqc.quota_category_id = qc.quota_category_id AND rqc.calc_formula_id = cf.calc_formula_id AND r.role_id = :p_role_id;

Related Objects

The CN_ROLE_QUOTA_CATES table has extensive relationships within the Incentive Compensation schema, acting as a hub for quota-related data. As documented in the ETRM, its primary key is referenced by several child tables that store detailed rules and results, including CN_COMP_ANCHORS, CN_ROLE_QUOTA_FORMULAS, CN_ROLE_QUOTA_RATES, and CN_SRP_QUOTA_CATES_ALL. It directly references several master configuration tables via foreign keys: CN_ROLE_DETAILS (on ROLE_ID), CN_QUOTA_CATEGORIES (on QUOTA_CATEGORY_ID), CN_ROLE_MODELS_ALL (on ROLE_MODEL_ID), and CN_CALC_FORMULAS_ALL (on CALC_FORMULA_ID). This network of relationships underscores its pivotal role in connecting role definitions to the granular mechanics of quota calculation and compensation.