Search Results cn_srp_rule_uplifts_all




Overview
Explore in AI Chat

Overview

The CN_SRP_RULE_UPLIFTS_ALL table is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation module (CN). It functions as a junction table that stores the assignment of specific revenue class uplift factors to individual salesperson plan elements. Its primary role is to link a salesperson's quota rule (from CN_SRP_QUOTA_RULES_ALL) with a defined uplift factor (from CN_QUOTA_RULE_UPLIFTS_ALL), enabling the application of differentiated payment and quota multipliers based on revenue class. This table is essential for implementing complex, tiered compensation plans where earnings or quota attainment are adjusted by product or revenue type. As an "ALL" table, it is designed to support multi-organization access (MOAC) in both EBS 12.1.1 and 12.2.2, typically containing an ORG_ID column to partition data by operating unit.

Key Information Stored

The table's structure centers on its primary and foreign key relationships. The primary key, SRP_RULE_UPLIFT_ID, uniquely identifies each assignment record. The two critical foreign key columns define the relationship: SRP_QUOTA_RULE_ID links to the specific quota rule assigned to a salesperson in CN_SRP_QUOTA_RULES_ALL, and QUOTA_RULE_UPLIFT_ID links to the master definition of the uplift factor (e.g., a 110% payment factor) in CN_QUOTA_RULE_UPLIFTS_ALL. While the provided metadata does not list all columns, typical data stored includes the applicable payment factor and quota factor values for the assignment, effective start and end dates (START_DATE, END_DATE), the ORG_ID, and standard EBS audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY.

Common Use Cases and Queries

This table is primarily accessed for compensation calculation, audit reporting, and plan administration. A common operational use case is verifying the uplift factors applied to a salesperson's transactions during a compensation calculation batch run. Administrators may query it to validate plan assignments or troubleshoot discrepancies in calculated payments. A typical reporting query joins the table to its related master tables to list all uplift assignments for a given salesperson or plan.

Sample Query Pattern:
SELECT s.srp_quota_rule_id, u.uplift_name, u.payment_factor, u.quota_factor
FROM cn_srp_rule_uplifts_all r,
    cn_quota_rule_uplifts_all u
WHERE r.quota_rule_uplift_id = u.quota_rule_uplift_id
AND r.srp_quota_rule_id = :p_rule_id;

Related Objects

The CN_SRP_RULE_UPLIFTS_ALL table sits at the intersection of two key compensation entities, as defined by its documented foreign key constraints:

  • CN_SRP_QUOTA_RULES_ALL: This table holds the assignment of quota rules to individual salespeople (SRPs). The join is made via the column CN_SRP_RULE_UPLIFTS_ALL.SRP_QUOTA_RULE_ID.
  • CN_QUOTA_RULE_UPLIFTS_ALL: This master table contains the definition of the uplift factors themselves, such as factor names and multiplier values. The join is made via the column CN_SRP_RULE_UPLIFTS_ALL.QUOTA_RULE_UPLIFT_ID.

These relationships are critical for understanding the data model; the table has no purpose without joining to these parent tables to resolve the identities of both the assigned salesperson rule and the specific uplift factor being applied.