Search Results cn_srp_quota_assigns_all

Overview

The CN_SRP_QUOTA_ASSIGNS_ALL table is a core transactional entity 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 junction for assigning specific quota elements to salesperson plan assignments. This table operationalizes the compensation plan structure by linking a salesperson's overall plan assignment (from CN_SRP_PLAN_ASSIGNS_ALL) to the detailed performance quotas (from CN_QUOTAS_ALL) they are responsible for achieving. Its existence is critical for calculating commissions, as it defines the measurable targets against which a salesperson's performance and subsequent earnings are evaluated.

Key Information Stored

While the provided metadata does not list individual columns, the primary and foreign key relationships define its essential structure. The table's unique identifier is the SRP_QUOTA_ASSIGN_ID. Each record is fundamentally defined by the linkage between a salesperson's plan assignment (SRP_PLAN_ASSIGN_ID) and a specific quota definition (QUOTA_ID). A critical component is the RATE_SCHEDULE_ID, which links to the CN_RATE_SCHEDULES_ALL table, thereby attaching the compensation rates or formulas applicable to the assigned quota. This table typically also holds attributes governing the assignment, such as effective start and end dates (START_DATE, END_DATE), assignment status, and organizational context via the standard Oracle EBS ORG_ID column, as indicated by the "_ALL" suffix in the table name.

Common Use Cases and Queries

This table is central to quota management and commission calculation processes. A primary use case is generating reports to show all quota assignments for a salesperson or a team within a specific operating unit. Administrators use this data to audit plan configurations and troubleshoot calculation issues. For performance analysis, queries often join this table to quota achievement tables to compare targets against actuals. A typical reporting query would be:

SELECT sqa.srp_quota_assign_id,
       spa.salesrep_id,
       q.name quota_name,
       rs.name rate_schedule
FROM cn_srp_quota_assigns_all sqa,
     cn_srp_plan_assigns_all spa,
     cn_quotas_all q,
     cn_rate_schedules_all rs
WHERE sqa.srp_plan_assign_id = spa.srp_plan_assign_id
  AND sqa.quota_id = q.quota_id
  AND sqa.rate_schedule_id = rs.rate_schedule_id
  AND spa.salesrep_id = :rep_id
  AND sqa.org_id = :org_id;

Another critical use case is during the compensation calculation engine's runtime, where it reads these assignments to determine which quotas and associated rate schedules apply to a given transaction.

Related Objects

The CN_SRP_QUOTA_ASSIGNS_ALL table sits at a pivotal point in the Incentive Compensation schema, with documented relationships to several key tables:

• Parent/Dependent Tables (Foreign Key References):
  • CN_SRP_PLAN_ASSIGNS_ALL: Via SRP_PLAN_ASSIGN_ID. This is the primary parent, providing the salesperson-to-plan context.
  • CN_QUOTAS_ALL: Via QUOTA_ID. Links to the definition of the quota metric and target.
  • CN_RATE_SCHEDULES_ALL: Via RATE_SCHEDULE_ID. Links to the compensation rates applicable for this quota assignment.
• Child/Referencing Tables (Foreign Keys Pointing In):
  • CN_SRP_PAYEE_ASSIGNS_ALL: Uses SRP_QUOTA_ASSIGN_ID to assign specific payees (e.g., split commissions) to a quota assignment.
  • CN_SRP_PERIOD_QUOTAS_ALL: Uses SRP_QUOTA_ASSIGN_ID to store period-level breakdowns or adjustments of the assigned quota.
  • CN_SRP_QUOTA_RULES_ALL: Uses SRP_QUOTA_ASSIGN_ID to attach specific business rules governing the quota.
  • CN_SRP_RATE_ASSIGNS_ALL: Uses SRP_QUOTA_ASSIGN_ID for more granular rate assignments or overrides.