Results for “target_amount”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The CN_SRP_PER_QUOTA_RC_ALL table is a core transactional object within the Oracle EBS Incentive Compensation (CN) module. Its documented description is "Salesperson Revenue Classes by Period," which identifies it as the storage mechanism for associating a specific salesperson with the revenue classes that apply to a given quota within a defined quota period. Revenue classes in Incentive Compensation determine how credit is apportioned across products, product categories, or business lines when a sales transaction is evaluated for compensation purposes. By storing these assignments per period and per quota, the table allows compensation plans to differentiate crediting rules over time rather than applying a single static mapping.

The object resides in the CN schema and is valid across EBS 12.1.1 and 12.2.2. The documented structure carries a surrogate primary key, SRP_PER_QUOTA_RC_ID, enforced by the constraint CN_SRP_PER_QUOTA_RC_PK. Two additional unique constraints, CN_SRP_PER_QUOTA_RC_UK1 and CN_SRP_PER_QUOTA_RC_UK2, establish business-key candidates over the combinations of SRP_PERIOD_QUOTA_ID, REVENUE_CLASS_ID, and SALESREP_ID, PERIOD_ID, QUOTA_ID, REVENUE_CLASS_ID respectively. A separate unique index, CN_SRP_PER_QUOTA_RC_U1, spans SRP_PER_QUOTA_RC_ID and ORG_ID, reflecting the multi-org (Operating Unit) partitioning of the data. Heuristically, the foreign-key structure suggests a Data Vault link classification, since the table primarily resolves many-to-many relationships among salespersons, quotas, periods, and revenue classes rather than acting as a descriptive hub or satellite.

Key Information Stored

The table contains 20 documented columns. The most significant include:

  • SRP_PER_QUOTA_RC_ID — surrogate primary key, unique identifier for each row.
  • ORG_ID — Operating Unit identifier supporting multi-org data segregation.
  • SRP_PERIOD_QUOTA_ID — links to the period-quota assignment; a component of the first unique constraint.
  • SRP_PLAN_ASSIGN_ID — links to the plan assignment record under which the salesperson operates.
  • REVENUE_CLASS_ID — the revenue class being credited; a component of both unique constraints.
  • PERIOD_ID — the quota period to which the revenue class applies.
  • QUOTA_ID — the quota definition associated with this row.
  • SALESREP_ID — the salesperson to whom the revenue class applies.
  • TARGET_AMOUNT — the quota target amount for the salesperson/period/revenue class combination.
  • YEAR_TO_DATE, QUARTER_TO_DATE, PERIOD_TO_DATE — cumulative credited amounts at each aggregation level.
  • YEAR_TO_DATE_F, PERIOD_TO_DATE_F — functional-currency counterparts of the cumulative figures.
  • SECURITY_GROUP_ID — used for row-level security filtering via FND_SECURITY_GROUPS.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Compensation analysts and developers query this table to determine which revenue classes drive crediting for a salesperson during a given quota period, and to reconcile period-to-date and year-to-date credited amounts. A typical retrieval filters by salesperson and period:

  • SELECT salesrep_id, revenue_class_id, target_amount, period_to_date, year_to_date FROM cn_srp_per_quota_rc_all WHERE salesrep_id = :p_rep AND period_id = :p_period;
  • Joining to CN_REVENUE_CLASSES_ALL to resolve revenue class names for reporting.
  • Aggregating PERIOD_TO_DATE across revenue classes to validate quota attainment per salesperson.
  • Comparing PERIOD_TO_DATE against PERIOD_TO_DATE_F to detect currency conversion discrepancies.

Related Objects

Foreign-key metadata links this table to several critical Incentive Compensation objects: