Search Results cn_sch_dim_tiers_all




Overview
Explore in AI Chat

Overview

The CN_SCH_DIM_TIERS_ALL table is a core data structure within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module, specifically in versions 12.1.1 and 12.2.2. It serves as a critical junction table that defines the multi-dimensional rate cube for a compensation plan. Its primary role is to store the specific combinations of rate dimension tiers that collectively determine the applicable payout rate for a transaction. Each row in this table represents a unique cell within the rate cube, linking a rate schedule to the precise tier values across all assigned rate dimensions, thereby enabling the complex, multi-variable calculations essential for sophisticated sales incentive programs.

Key Information Stored

The table's structure is designed to establish relationships between key compensation entities. Its primary key, SCH_DIM_TIER_ID, uniquely identifies each rate cube combination. The most significant foreign key columns define its core linkages: RATE_SCHEDULE_ID connects the combination to a specific rate schedule (CN_RATE_SCHEDULES_ALL). RATE_DIM_TIER_ID links to a specific tier within a rate dimension (CN_RATE_DIM_TIERS_ALL), such as a "Revenue" dimension's "$1M-$5M" tier. RATE_TIER_ID connects to the actual payout rate value (CN_RATE_TIERS_ALL) that applies when this specific combination of dimension tiers is met. Together, these columns map the abstract structure of a rate cube to concrete, actionable payout data.

Common Use Cases and Queries

This table is central to the rate determination engine during the compensation calculation process. A common operational query involves fetching the applicable rate for a given transaction by matching its attribute values against the defined dimension tiers within a schedule. For example, to audit or preview rates for a specific schedule, one might execute a query joining CN_SCH_DIM_TIERS_ALL to CN_RATE_DIM_TIERS_ALL to see tier descriptions and to CN_RATE_TIERS_ALL to see the corresponding payout rates. Reporting use cases include analyzing the complexity and structure of compensation plans by counting the number of unique rate cube combinations (rows) per rate schedule, or validating that all expected dimension tier combinations have been assigned a valid rate tier.

Related Objects

The CN_SCH_DIM_TIERS_ALL table sits at the intersection of several fundamental Incentive Compensation tables, as documented by its foreign key relationships:

  • CN_RATE_SCHEDULES_ALL: Joined via RATE_SCHEDULE_ID. This is the parent object, as every rate cube combination must belong to a specific compensation rate schedule.
  • CN_RATE_DIM_TIERS_ALL: Joined via RATE_DIM_TIER_ID. This relationship defines which specific tier from a rate dimension (e.g., a quota attainment band) is part of this cube cell.
  • CN_RATE_TIERS_ALL: Joined via RATE_TIER_ID. This is the ultimate target of the relationship, providing the actual commission rate, bonus amount, or multiplier that applies for the given combination of dimension tiers.