Search Results cn_rate_dimensions_all




Overview
Explore in AI Chat

Overview

The CN_RATE_DIMENSIONS_ALL table is a core data object within the Oracle E-Business Suite Incentive Compensation (CN) module. It serves as the master repository for defining rate dimensions, which are the key business variables or metrics used to calculate compensation rates and commissions. These dimensions form the foundational axes of a multi-dimensional rate matrix, enabling the creation of complex, tiered incentive plans based on performance against multiple criteria. Its role is critical for configuring the compensation engine's logic, as rate dimensions are referenced by rate schedules and their associated tiers to determine final payout percentages or amounts.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the primary key and foreign key relationships indicate the core data structure. The central column is RATE_DIMENSION_ID, a unique system-generated identifier for each dimension definition. Based on standard module functionality, typical columns would include a name (e.g., DIMENSION_NAME), a description, and attributes defining the dimension's data type (e.g., numeric range, discrete values), ordering, and status. The table is multi-org enabled, as indicated by the "_ALL" suffix, meaning it stores data for multiple operating units, with an ORG_ID column controlling data access and security.

Common Use Cases and Queries

This table is primarily accessed during the design and administration of compensation plans. Common use cases include listing all available dimensions for building a new rate schedule, auditing dimension definitions, and troubleshooting rate calculation issues by tracing the dimension back to its source data. A typical reporting query would join this table to its related schedule mapping table to analyze which dimensions are used in active plans.

SELECT rd.dimension_name, rd.description, rsd.rate_schedule_id
  FROM cn_rate_dimensions_all rd,
       cn_rate_sch_dims_all rsd
 WHERE rd.rate_dimension_id = rsd.rate_dimension_id
   AND rd.org_id = :p_org_id
   AND rsd.org_id = :p_org_id;

Related Objects

The table maintains documented foreign key relationships with two critical child tables, as per the provided metadata:

  • CN_RATE_DIM_TIERS_ALL: This table stores the specific threshold values or levels (tiers) defined for a given rate dimension. It joins to CN_RATE_DIMENSIONS_ALL via the RATE_DIMENSION_ID column.
  • CN_RATE_SCH_DIMS_ALL: This table acts as a mapping or junction table, linking rate dimensions to specific rate schedules. It also joins to CN_RATE_DIMENSIONS_ALL via the RATE_DIMENSION_ID column, defining which dimensions are used in a particular compensation plan structure.

These relationships establish a hierarchy where a dimension (CN_RATE_DIMENSIONS_ALL) can have multiple tiers (CN_RATE_DIM_TIERS_ALL) and can be associated with multiple rate schedules (via CN_RATE_SCH_DIMS_ALL).