Search Results cn_srp_payee_assigns_all




Overview
Explore in AI Chat

Overview

The CN_SRP_PAYEE_ASSIGNS_ALL table is a core data object within the Oracle E-Business Suite Incentive Compensation (CN) module, specifically for releases 12.1.1 and 12.2.2. It serves as the system of record for date-effective payee assignments to salesperson plan elements. In the context of incentive compensation, a payee is the individual or entity entitled to receive payment for a sales transaction or achievement, which may or may not be the same as the salesperson who generated the revenue. This table enables the complex and flexible compensation structures required by modern sales organizations, allowing for the accurate tracking and historical auditing of who is paid for specific sales performance over time.

Key Information Stored

While the provided metadata does not list specific columns beyond key identifiers, the table's structure is defined by its primary and foreign keys. The primary key, SRP_PAYEE_ASSIGN_ID, uniquely identifies each payee assignment record. Crucially, the table is date-effective, meaning it will contain multiple rows for the same assignment with different effective date ranges to maintain a history of changes. The foreign key columns, QUOTA_ID and SRP_QUOTA_ASSIGN_ID, link the payee assignment directly to a specific quota definition (CN_QUOTAS_ALL) and to the specific assignment of that quota to a salesperson (CN_SRP_QUOTA_ASSIGNS_ALL). Other typical columns in such a table would include START_DATE, END_DATE for the date-effective tracking, PAYEE_ID to identify the recipient, and likely attributes for the assignment percentage or split.

Common Use Cases and Queries

The primary use case is determining the correct payee for a commission calculation during the compensation processing cycle. A typical query would identify the active payee assignment for a given salesperson and quota at a specific point in time. For example, to find all active payee assignments as of today, one might query: SELECT * FROM cn_srp_payee_assigns_all WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1). Reporting use cases include auditing compensation plan changes, analyzing payee assignment history for a specific salesperson, and validating that all quota assignments have corresponding payee definitions before a compensation run. Data fixes often involve inserting new date-effective rows or end-dating existing ones to correct assignment errors.

Related Objects

The table has documented foreign key relationships with two other core Incentive Compensation tables, forming a critical data chain for quota management and payment.

  • CN_QUOTAS_ALL: Linked via the QUOTA_ID column. This table stores the master definition of sales quotas and performance measures.
  • CN_SRP_QUOTA_ASSIGNS_ALL: Linked via the SRP_QUOTA_ASSIGN_ID column. This table stores the assignment of specific quotas to individual salespeople (SRPs). Therefore, CN_SRP_PAYEE_ASSIGNS_ALL sits downstream, defining who gets paid for the performance against that assigned quota.

This relationship ensures that payee assignments are always anchored to a concrete, assigned quota, maintaining data integrity from the performance measure through to the payment recipient.