Search Results rt_quota_asgn_id

Overview

The CN_RT_QUOTA_ASGNS_ALL table is a core data object within the Oracle E-Business Suite Incentive Compensation (CN) module, versions 12.1.1 and 12.2.2. It functions as the central junction table that governs the assignment of rate tables (rate schedules) to specific plan elements (quotas) for defined periods. This assignment is a critical configuration step in the compensation planning process, as it determines which calculation rules and payout rates apply to a given quota based on performance against it. The table's "ALL" suffix indicates it is a multi-organization table, storing data across all operating units configured within the instance.

Key Information Stored

While the full column list is not provided in the metadata, the documented primary and foreign keys reveal the essential data structure. The primary identifier is the RT_QUOTA_ASGN_ID, a unique system-generated key. The two fundamental foreign keys are QUOTA_ID, which links to the CN_QUOTAS_ALL table to identify the specific quota or plan element, and RATE_SCHEDULE_ID, which links to the CN_RATE_SCHEDULES_ALL table to identify the applicable rate table. A robust implementation would also include columns to define the effective date range of the assignment (START_DATE and END_DATE), along with standard Oracle EBS audit columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE. The table enables a single quota to have different rate tables assigned over time or for different scenarios.

Common Use Cases and Queries

This table is primarily accessed for configuration validation, historical reporting, and troubleshooting compensation calculations. Administrators may query it to verify which rate table is currently active for a sales plan or to audit changes in rate assignments over a fiscal period. A typical query would join to related tables to produce a human-readable report:

• Identifying active rate table assignments for a specific quota: SELECT q.name quota_name, rs.name rate_schedule_name, rqa.start_date, rqa.end_date FROM cn_rt_quota_asgns_all rqa, cn_quotas_all q, cn_rate_schedules_all rs WHERE rqa.quota_id = q.quota_id AND rqa.rate_schedule_id = rs.rate_schedule_id AND q.quota_id = :p_quota_id AND SYSDATE BETWEEN rqa.start_date AND NVL(rqa.end_date, SYSDATE);
• Troubleshooting calculation errors by verifying the rate table-quota linkage for a given transaction date.
• Generating an audit trail of all rate table assignments made to a compensation plan component.

Related Objects

The CN_RT_QUOTA_ASGNS_ALL table sits at the intersection of key Incentive Compensation entities, as defined by its foreign key relationships.

• Referenced By This Table (Outgoing Foreign Keys):
  • CN_QUOTAS_ALL via QUOTA_ID: Links the assignment to the specific quota or plan element.
  • CN_RATE_SCHEDULES_ALL via RATE_SCHEDULE_ID: Links the assignment to the specific rate table containing the calculation rules.
• References This Table (Incoming Foreign Key):
  • CN_SRP_RATE_ASSIGNS_ALL via RT_QUOTA_ASGN_ID: This relationship indicates that once a rate table is assigned to a quota (record in CN_RT_QUOTA_ASGNS_ALL), that specific assignment can be further assigned to individual salespeople (SRPs) or teams. This creates a hierarchical assignment model: Rate Schedule → Quota → Salesperson.