Search Results cn_comp_anchors




Overview
Explore in AI Chat

Overview

The CN_COMP_ANCHORS table is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation module (CN). It serves as the foundation for defining commission plan performance targets and their corresponding payout expectations. The table's primary role is to store "compensation anchors," which are critical rules that map specific levels of quota achievement to predetermined commission rates or amounts. This functionality enables organizations to automate and standardize their commission calculations by establishing clear, formulaic relationships between sales performance and compensation, which is essential for accurate and timely incentive payouts in versions 12.1.1 and 12.2.2.

Key Information Stored

The table stores the configuration rules that define the commission payout schedule. Its primary key, COMP_ANCHOR_ID, uniquely identifies each anchor rule. The most critical columns define the performance threshold and the resulting compensation. While the full column list is not detailed in the provided metadata, based on its described purpose, the table logically contains fields for the quota achievement percentage (e.g., 100% of quota) and the associated expected commission value (which could be a rate, multiplier, or fixed amount). The foreign key columns, QUOTA_CATEGORY_ID and ROLE_QUOTA_CATE_ID, are essential as they link each anchor rule to specific quota categories and role assignments, ensuring the compensation rule is applied to the correct performance metrics and personnel.

Common Use Cases and Queries

The primary use case is the configuration and execution of commission calculations. Administrators use this table to set up tiered commission plans, such as defining that achieving 90-100% of quota pays a 10% commission rate, while achieving 110% pays 15%. A common reporting query would join CN_COMP_ANCHORS with quota assignment and transaction tables to assess projected commissions or audit plan rules. A typical SQL pattern for retrieving the commission schedule for a quota category would be:

  • SELECT ca.comp_anchor_id, qc.name quota_category, ca.achievement_percentage, ca.commission_rate FROM cn_comp_anchors ca, cn_quota_categories qc WHERE ca.quota_category_id = qc.quota_category_id ORDER BY qc.name, ca.achievement_percentage;

This data is fundamental for generating statements that show reps their earnings potential at various performance levels.

Related Objects

The CN_COMP_ANCHORS table has documented foreign key relationships with two other central Incentive Compensation tables, as per the provided metadata:

  • CN_QUOTA_CATEGORIES: Joined via CN_COMP_ANCHORS.QUOTA_CATEGORY_ID. This links each compensation anchor rule to a specific type of quota (e.g., Product Revenue, New Business).
  • CN_ROLE_QUOTA_CATES: Joined via CN_COMP_ANCHORS.ROLE_QUOTA_CATE_ID. This relationship ties the anchor rule to the assignment of a specific quota category to a compensation role, ensuring the rule applies to the correct individuals.

These relationships ensure that compensation anchors are contextually applied within the hierarchical structure of quotas, roles, and assignments in the Incentive Compensation module.