Search Results cn_srp_period_quotas_all

Overview

The CN_SRP_PERIOD_QUOTAS_ALL table is a core transactional table within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module, specifically in versions 12.1.1 and 12.2.2. It serves as the central repository for associating salesperson quota assignments with specific compensation periods. The table's primary role is to establish the detailed, period-level mapping of quota targets to individual sales representatives, enabling the accurate calculation of commissions and performance attainment. By linking salespeople, their assigned quotas, and the applicable time periods, this table forms the foundational data structure for the period-based quota management and incentive earnings processes within the application.

Key Information Stored

The table stores the intersection of salesperson, quota, and period data. Its key columns, as defined by its primary and unique keys, are critical identifiers. The primary key is the surrogate key SRP_PERIOD_QUOTA_ID. The table enforces two unique constraints: one ensures a quota assignment (SRP_QUOTA_ASSIGN_ID) is not duplicated for a given PERIOD_ID, and another ensures a specific SALESREP_ID does not have the same QUOTA_ID assigned more than once for a single PERIOD_ID. Other significant foreign key columns include SRP_PLAN_ASSIGN_ID, linking the record to the salesperson's overall plan assignment, and QUOTA_ID, identifying the specific quota metric. These columns collectively define the "who," "what," and "when" of quota targets.

Common Use Cases and Queries

This table is central to reporting and analytics on sales performance and quota attainment. Common use cases include generating period-to-date quota achievement reports, calculating commission accruals, and analyzing sales team performance against targets. A typical query would join this table to dimension tables for salespersons, quotas, and periods to produce a comprehensible report. For example, to list all quota assignments for a sales representative in the current fiscal quarter, one might query using the SALESREP_ID and filter on PERIOD_IDs within the quarter's date range. Data from this table is also essential for the batch processes that run the compensation engine to compute earned incentives based on actual performance against the period quotas stored here.

Related Objects

The CN_SRP_PERIOD_QUOTAS_ALL table maintains integral relationships with several other key Incentive Compensation tables, as documented by its foreign keys:

• CN_PERIOD_STATUSES_ALL: Joined via PERIOD_ID to validate the status and attributes of the compensation period.
• CN_SRP_PLAN_ASSIGNS_ALL: Joined via SRP_PLAN_ASSIGN_ID to link the period quota to the salesperson's overarching compensation plan assignment.
• CN_SRP_QUOTA_ASSIGNS_ALL: Joined via SRP_QUOTA_ASSIGN_ID to reference the higher-level quota assignment from which this period-specific instance is derived.
• CN_QUOTAS_ALL: Joined via QUOTA_ID to obtain the definition and details of the quota metric itself (e.g., revenue, units).
• CN_SRP_PER_QUOTA_RC_ALL: This table holds related records, such as rate cards or adjustments, that reference back to CN_SRP_PERIOD_QUOTAS_ALL via the SRP_PERIOD_QUOTA_ID column.