Search Results cn_role_plan_maps




Overview
Explore in AI Chat

Overview

The CN_ROLE_PLAN_MAPS table is a core data object within the Oracle E-Business Suite Incentive Compensation (CN) module. Its primary function is to establish and maintain the fundamental association between a defined sales role and a specific compensation plan. This mapping is critical for the operational integrity of the compensation engine, as it determines which compensation rules and calculations apply to individuals based on their assigned sales role. The table acts as a junction, linking the role definitions in the system to the various compensation plan structures, thereby enabling the accurate and automated processing of sales credits, commissions, and incentive payments.

Key Information Stored

The table's structure is designed to manage the unique relationship between a role and a plan. The primary identifier for each mapping record is the ROLE_PLAN_MAP_ID column. The two most critical foreign key columns are ROLE_ID, which references the CN_ROLE_DETAILS table to identify the specific sales role, and a corresponding PLAN_ID column (implied by the table's purpose, though not explicitly listed in the provided metadata), which would reference the compensation plan definition. Additional columns typically found in such mapping tables may include effective start and end dates (START_DATE, END_DATE) to manage the temporal validity of the assignment, and attributes like CREATED_BY and CREATION_DATE for auditing purposes.

Common Use Cases and Queries

This table is central to configuration, reporting, and audit processes. Administrators query it to validate plan assignments or to generate a list of all plans available to a particular role. A common reporting use case involves joining this table to role and plan detail tables to produce a comprehensive role-to-plan matrix for business review. Troubleshooting often involves queries to identify missing mappings that may cause compensation processing errors. Sample SQL to retrieve active mappings would resemble:

  • SELECT r.role_name, p.plan_name FROM cn_role_plan_maps rpm, cn_role_details r, cn_plans_v p WHERE rpm.role_id = r.role_id AND rpm.plan_id = p.plan_id AND SYSDATE BETWEEN rpm.start_date AND NVL(rpm.end_date, SYSDATE);

Related Objects

CN_ROLE_PLAN_MAPS has direct dependencies on several key Incentive Compensation tables. As documented, it holds a foreign key relationship to the CN_ROLE_DETAILS table via the ROLE_ID column. It will also have a foreign key relationship to a plan definition table, such as CN_PLANS or a related view. The table is referenced by the compensation calculation engine and is integral to the data model supporting the assignment of compensation rules (quotas, rates, etc.) to individuals through their role. It may also be referenced by various compensation planning and analysis views within the module.