Search Results cn_srp_rate_assigns_all




Overview
Explore in AI Chat

Overview

The CN_SRP_RATE_ASSIGNS_ALL table is a core transactional table within the Oracle E-Business Suite Incentive Compensation (CN) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for assigning specific rate tiers from compensation rate schedules to individual salespeople (SRP). This table is fundamental to the commission calculation engine, as it establishes the precise earning rate that applies to a salesperson for a given quota and plan assignment. The presence of the 'ALL' suffix indicates it is a multi-organization table, storing data across operating units. Its primary role is to link salesperson assignments, quotas, and rate schedules to the granular rate tier definitions that determine payout percentages or amounts.

Key Information Stored

The table's structure is designed to manage the many-to-many relationships between salesperson assignments and rate tiers. The most critical columns, as indicated by the primary and unique keys, are SRP_QUOTA_ASSIGN_ID and RATE_TIER_ID. The SRP_QUOTA_ASSIGN_ID links to a specific salesperson's quota assignment, while the RATE_TIER_ID is the direct foreign key to the CN_RATE_TIERS_ALL table, pinpointing the exact tier (e.g., Tier 1, Tier 2) and its associated rate. Other essential foreign key columns include RATE_SCHEDULE_ID (linking to the parent CN_RATE_SCHEDULES_ALL), QUOTA_ID, SRP_PLAN_ASSIGN_ID, and RT_QUOTA_ASGN_ID. Together, these columns create a comprehensive assignment record that defines which rate from which schedule applies to which salesperson for a specific performance period and quota.

Common Use Cases and Queries

The primary use case is the real-time or batch determination of commission rates during the calculation of incentive earnings. Administrators may query this table to audit or report on rate assignments for troubleshooting. A common reporting query would join this table to salesperson, quota, and rate tier details to list all active rate assignments. For a user searching specifically for "rate_tier_id", a typical pattern would involve identifying all salesperson assignments linked to a particular tier, perhaps to assess the impact of a tier definition change.

  • Sample Query: SELECT sra.srp_quota_assign_id, sra.rate_tier_id, rt.tier_number, rt.rate FROM cn_srp_rate_assigns_all sra, cn_rate_tiers_all rt WHERE sra.rate_tier_id = rt.rate_tier_id AND sra.rate_schedule_id = :p_sched_id;
  • Use Case: Validating that a salesperson's transaction volume or revenue correctly maps to the intended rate tier based on the assigned schedule's tier boundaries.

Related Objects

The table is a nexus within the Incentive Compensation schema, with documented foreign key relationships to several key master and transactional tables. These relationships are crucial for data integrity and join logic in custom reports or integrations.

  • CN_SRP_PLAN_ASSIGNS_ALL: Joined via SRP_PLAN_ASSIGN_ID. Links the rate assignment to the salesperson's overall plan assignment.
  • CN_SRP_QUOTA_ASSIGNS_ALL: Joined via SRP_QUOTA_ASSIGN_ID (part of the primary key). Links to the specific quota assigned to the salesperson.
  • CN_RATE_SCHEDULES_ALL: Joined via RATE_SCHEDULE_ID. Identifies the parent rate schedule containing the tier.
  • CN_QUOTAS_ALL: Joined via QUOTA_ID. Links directly to the quota definition.
  • CN_RT_QUOTA_ASGNS_ALL: Joined via RT_QUOTA_ASGN_ID. May link to rate-specific quota assignment details.
  • CN_RATE_TIERS_ALL: Joined via RATE_TIER_ID (part of the primary key). This is the most direct relationship, providing the actual rate value and tier attributes applied to the assignment.