Search Results cn_plan_texts




Overview
Explore in AI Chat

Overview

The CN_PLAN_TEXTS table is a core data object within the Oracle E-Business Suite Incentive Compensation module (CN). It serves as the central repository for the textual and descriptive components of a compensation plan or contract. Its primary role is to store user-customizable information that defines the formal agreement between the organization and a sales role, including its title, qualification rules, and legal or procedural terms. This table enables the personalization and formal documentation of compensation agreements, which is critical for sales operations and commission administration in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to hold the narrative and administrative details of a compensation contract. While the full column list is not detailed in the provided metadata, the description and foreign key relationships indicate several critical data points. The primary key is the PLAN_TEXT_ID. Essential foreign key columns include ROLE_ID, linking to the CN_ROLE_DETAILS table to associate the contract text with a specific sales role, and QUOTA_CATEGORY_ID, linking to CN_QUOTA_CATEGORIES to tie terms to specific performance metrics. Based on its described purpose, the table likely contains columns for storing the contract title, club qualification criteria, detailed terms and conditions, and approver information.

Common Use Cases and Queries

This table is primarily accessed for generating formal compensation contracts, configuring plan rules, and administrative reporting. A common operational use case is retrieving the complete contract text for a specific salesperson's role to generate a signable document. A typical query would join CN_PLAN_TEXTS with role and assignment tables. For auditing or compliance, administrators may run reports to verify that all active roles have associated, up-to-date contract terms. Sample SQL to find contract details for a role would be:

  • SELECT pt.contract_title, pt.terms_and_conditions, rd.role_name FROM cn_plan_texts pt, cn_role_details rd WHERE pt.role_id = rd.role_id AND rd.role_name = '[Role Name]';

Another key use case involves the "club qualification" text, which defines the performance thresholds for elite sales clubs, a common motivational structure in sales organizations.

Related Objects

CN_PLAN_TEXTS has defined relationships with several other key Incentive Compensation tables, as per the provided metadata. It is linked via foreign key constraints to:

  • CN_ROLE_DETAILS: Through the ROLE_ID column. This relationship ensures every contract text is associated with a defined sales role.
  • CN_QUOTA_CATEGORIES: Through the QUOTA_CATEGORY_ID column. This links the contractual terms to specific quota or performance measurement categories.

The table's primary key, PLAN_TEXT_ID, is likely referenced by other transactional or historical tables within the CN schema that need to preserve a snapshot of the contract terms applicable at a specific point in time.

  • Table: CN_PLAN_TEXTS 12.1.1

    owner:CN,  object_type:TABLE,  fnd_design_data:CN.CN_PLAN_TEXTS,  object_name:CN_PLAN_TEXTS,  status:VALID,  product: CN - Incentive Compensation ,  description: CN_PLAN_TEXTS contains the custimized information on compensation contract for each sales role. User can customize contract title, club qualification, terms and conditions, approver's information. ,  implementation_dba_data: CN.CN_PLAN_TEXTS , 

  • Table: CN_PLAN_TEXTS 12.2.2

    owner:CN,  object_type:TABLE,  fnd_design_data:CN.CN_PLAN_TEXTS,  object_name:CN_PLAN_TEXTS,  status:VALID,  product: CN - Incentive Compensation ,  description: CN_PLAN_TEXTS contains the custimized information on compensation contract for each sales role. User can customize contract title, club qualification, terms and conditions, approver's information. ,  implementation_dba_data: CN.CN_PLAN_TEXTS , 

  • Table: CN_ROLE_DETAILS 12.2.2

    owner:CN,  object_type:TABLE,  fnd_design_data:CN.CN_ROLE_DETAILS,  object_name:CN_ROLE_DETAILS,  status:VALID,  product: CN - Incentive Compensation ,  description: CN_ROLE_DETAILS contain detail information of a sales role. These detail information are only used in salesforce planning. ,  implementation_dba_data: CN.CN_ROLE_DETAILS , 

  • Table: CN_ROLE_DETAILS 12.1.1

    owner:CN,  object_type:TABLE,  fnd_design_data:CN.CN_ROLE_DETAILS,  object_name:CN_ROLE_DETAILS,  status:VALID,  product: CN - Incentive Compensation ,  description: CN_ROLE_DETAILS contain detail information of a sales role. These detail information are only used in salesforce planning. ,  implementation_dba_data: CN.CN_ROLE_DETAILS , 

  • Table: CN_QUOTA_CATEGORIES 12.1.1

    owner:CN,  object_type:TABLE,  fnd_design_data:CN.CN_QUOTA_CATEGORIES,  object_name:CN_QUOTA_CATEGORIES,  status:VALID,  product: CN - Incentive Compensation ,  description: CN_QUOTA_CATEGORIES contains informations about your quota components. You need one row for each component you create. ,  implementation_dba_data: CN.CN_QUOTA_CATEGORIES , 

  • Table: CN_QUOTA_CATEGORIES 12.2.2

    owner:CN,  object_type:TABLE,  fnd_design_data:CN.CN_QUOTA_CATEGORIES,  object_name:CN_QUOTA_CATEGORIES,  status:VALID,  product: CN - Incentive Compensation ,  description: CN_QUOTA_CATEGORIES contains informations about your quota components. You need one row for each component you create. ,  implementation_dba_data: CN.CN_QUOTA_CATEGORIES ,