Search Results cn_role_details




Overview
Explore in AI Chat

Overview

The CN_ROLE_DETAILS table is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation module (CN). It serves as the master repository for detailed information pertaining to a sales role. The table's primary function is to support salesforce planning activities, a critical process for structuring and managing the sales organization, assigning compensation plans, and defining performance metrics. The data stored in this table is foundational for configuring how sales representatives and managers are organized, compensated, and measured against quotas within the incentive compensation system.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary and foreign keys, the table's structure and relationships indicate the nature of its data. The primary key, ROLE_ID, uniquely identifies each sales role record. A critical foreign key, ATTAIN_SCHEDULE_ID, links the role to a specific attainment schedule defined in the CN_ATTAIN_SCHEDULES table. This relationship is central to planning, as it defines the timeline and rules for measuring performance against quotas. Other columns in the table likely store descriptive attributes of the sales role, such as role name, effective dates, hierarchy information, and planning-specific flags or parameters used exclusively for configuring the salesforce structure.

Common Use Cases and Queries

The primary use case for CN_ROLE_DETAILS is during the setup and maintenance of the sales organization hierarchy within Incentive Compensation. Administrators query this table to validate role definitions, ensure proper linkage to attainment schedules, and troubleshoot planning issues. Common reporting needs include listing all active sales roles with their associated attainment schedules or identifying roles that are not yet mapped to compensation plans. A typical query would join CN_ROLE_DETAILS with related tables for a comprehensive view:

  • SELECT rd.role_id, rd.name, sched.name AS attain_schedule FROM cn_role_details rd, cn_attain_schedules sched WHERE rd.attain_schedule_id = sched.attain_schedule_id;
  • Queries to find roles missing plan assignments: SELECT rd.* FROM cn_role_details rd WHERE NOT EXISTS (SELECT 1 FROM cn_role_plan_maps rpm WHERE rpm.role_id = rd.role_id);

Related Objects

CN_ROLE_DETAILS is a central hub within the Incentive Compensation schema, with documented relationships to several key tables. The ROLE_ID column is the primary point of integration.

These relationships show that a role's details are essential for linking to compensation plans (CN_ROLE_PLAN_MAPS), associating descriptive text (CN_PLAN_TEXTS), and categorizing quota assignments (CN_ROLE_QUOTA_CATES).