Search Results cn_quota_rule_uplifts_all




Overview
Explore in AI Chat

Overview

The CN_QUOTA_RULE_UPLIFTS_ALL table is a core data object within the Oracle E-Business Suite Incentive Compensation module (CN). It functions as a child table to CN_QUOTA_RULES_ALL, storing the specific uplift percentages applied to payment and target calculations for assigned revenue classes. Its primary role is to enable sophisticated compensation modeling by allowing different uplift factors (e.g., bonuses or adjustments) to be applied to a quota rule's calculations based on revenue class and effective date ranges. This table is essential for implementing tiered or conditional compensation plans where earnings or performance targets are modulated by product or revenue type.

Key Information Stored

While the provided metadata does not list individual columns, the table's description and key relationships define its critical data elements. The central piece of information is the uplift percentage, which modifies the base calculation defined in the parent quota rule. Each record is uniquely identified by a system-generated QUOTA_RULE_UPLIFT_ID, which serves as the primary key. A foreign key column, QUOTA_RULE_ID, links each uplift record to its parent rule in CN_QUOTA_RULES_ALL. Furthermore, each record is associated with a specific revenue class and contains effective start and end dates to control the period during which the uplift is applicable. This structure allows for the historical tracking of uplift changes over time.

Common Use Cases and Queries

A primary use case is the analysis and auditing of compensation plan rules to verify the correct uplift percentages are applied to specific product categories during a fiscal quarter. Compensation analysts run reports to summarize all active uplifts by revenue class. A common SQL pattern involves joining to the parent quota rule and revenue class setup tables to produce a human-readable report. For example:

  • Identifying all uplifts for a specific plan element: SELECT * FROM cn_quota_rule_uplifts_all WHERE quota_rule_id = <RULE_ID> AND SYSDATE BETWEEN start_date AND end_date;
  • Reporting on uplifts by revenue class: SELECT r.revenue_class_name, u.uplift_percentage, u.start_date, u.end_date FROM cn_quota_rule_uplifts_all u, cn_revenue_classes_v r WHERE u.revenue_class_id = r.revenue_class_id ORDER BY r.revenue_class_name;

This table is also critical during the compensation calculation engine's runtime, where it is queried to apply the correct uplift to transaction amounts based on their revenue class and transaction date.

Related Objects

The CN_QUOTA_RULE_UPLIFTS_ALL table sits at the center of a key relationship hierarchy within the Incentive Compensation schema, as documented in the provided metadata.

  • Parent Table (Foreign Key Reference): The table CN_QUOTA_RULES_ALL is the direct parent. Each record in CN_QUOTA_RULE_UPLIFTS_ALL references a single quota rule via the QUOTA_RULE_ID column. This defines the base rule to which the uplift applies.
  • Child Table (Referenced by Foreign Key): The table CN_SRP_RULE_UPLIFTS_ALL is a child table. It references CN_QUOTA_RULE_UPLIFTS_ALL via the QUOTA_RULE_UPLIFT_ID column. This relationship typically extends the uplift logic to specific salesperson (SRP) assignments or exceptions.

Understanding these relationships is mandatory for writing accurate joins in custom reports or for troubleshooting data integrity issues within the compensation plan setup.