Search Results cn_rate_schedules_all




Overview
Explore in AI Chat

Overview

The CN_RATE_SCHEDULES_ALL table is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for compensation rate schedules, which are foundational constructs for defining and calculating variable pay. A rate schedule is a structured set of rules that determines the commission or bonus rates applied to sales transactions, quota achievements, or other performance metrics. The table's role is to store the high-level definition and metadata for these schedules, enabling the complex and tiered incentive calculations that drive sales force compensation. Its multi-org enabled structure, indicated by the "_ALL" suffix, allows it to store data for multiple operating units within a single installation.

Key Information Stored

While the provided ETRM excerpt does not list all columns, the primary and unique keys are documented and reveal the table's critical attributes. The primary identifier is the system-generated RATE_SCHEDULE_ID, which uniquely identifies each schedule record and is the primary join column for related entities. The NAME column holds the unique, user-defined identifier for the rate schedule, such as "Q4 Enterprise Software Commission" or "Tiered Bonus Schedule FY24." Other typical columns in this table, based on standard CN schema patterns, would include descriptive fields (DESCRIPTION), effective start and end dates (START_DATE, END_DATE), status (STATUS_CODE), and audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN). The ORG_ID column is also present to support the multi-org architecture.

Common Use Cases and Queries

This table is central to configuration, reporting, and audit activities. Administrators query it to list all active rate schedules or to validate schedule names before assignment. A common reporting use case is to analyze which schedules are assigned to specific salespeople or roles. Sample SQL patterns include retrieving basic schedule information and joining with assignment tables for analysis.

  • Listing Active Schedules: SELECT NAME, DESCRIPTION, START_DATE, END_DATE FROM CN_RATE_SCHEDULES_ALL WHERE SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE) AND ORG_ID = :p_org_id;
  • Finding Schedules for a Resource: SELECT RS.NAME FROM CN_RATE_SCHEDULES_ALL RS, CN_SRP_RATE_ASSIGNS_ALL SRA WHERE RS.RATE_SCHEDULE_ID = SRA.RATE_SCHEDULE_ID AND SRA.SALESREP_ID = :p_srp_id;

Related Objects

The CN_RATE_SCHEDULES_ALL table has a central role in the Incentive Compensation schema, acting as a parent to numerous child entities that define the schedule's specifics and its application. As documented in the foreign key relationships, its RATE_SCHEDULE_ID column is referenced by:

This extensive relationship network underscores that CN_RATE_SCHEDULES_ALL is the anchor point for building a complete, multi-dimensional incentive plan.