Search Results cn_dimensions_all_b




Overview
Explore in AI Chat

Overview

The CN_DIMENSIONS_ALL_B table is a core data definition table within the Oracle E-Business Suite Incentive Compensation (CN) module. It serves as the master repository for defining and storing the various dimensions used to categorize and analyze compensation data. In the context of incentive compensation, a dimension represents a fundamental business attribute—such as Product, Customer, Sales Channel, or Territory—by which performance is measured, quotas are set, and commissions are calculated. The table's structure supports a multi-organization architecture, as indicated by the ORG_ID column, allowing for the definition of dimensions that are specific to individual operating units within an enterprise deployment.

Key Information Stored

The table's primary purpose is to uniquely identify and describe each dimension available to the compensation system. The key columns, as defined by its primary keys and foreign key relationships, are DIMENSION_ID and ORG_ID. The DIMENSION_ID is the unique system identifier for a dimension definition. The ORG_ID links the dimension to a specific operating unit, enabling data partitioning. Another critical column is SOURCE_TABLE_ID, which is a foreign key to the CN_OBJECTS_ALL table. This relationship suggests the table stores metadata linking the logical dimension to its underlying physical data source or object within the application's flexible data model, which is central to the module's configuration.

Common Use Cases and Queries

This table is primarily accessed during the configuration and administration of the Incentive Compensation module. Common operational scenarios include setting up the compensation plan structure, defining rules for crediting transactions, and building analytical reports. Administrators may query this table to list all available dimensions for a given operating unit or to retrieve the metadata for a specific dimension used in a plan component. A typical query would join CN_DIMENSIONS_ALL_B to CN_OBJECTS_ALL to get a descriptive name for the dimension's source object.

  • Retrieving all dimensions for an operating unit (e.g., ORG_ID = 204):
    SELECT DIMENSION_ID FROM CN_DIMENSIONS_ALL_B WHERE ORG_ID = 204;
  • Finding the source object for a specific dimension:
    SELECT d.DIMENSION_ID, o.NAME FROM CN_DIMENSIONS_ALL_B d, CN_OBJECTS_ALL o WHERE d.SOURCE_TABLE_ID = o.OBJECT_ID AND d.DIMENSION_ID = &dimension_id;

Related Objects

The CN_DIMENSIONS_ALL_B table is central to the Incentive Compensation data model, with documented relationships to several key tables. It references the CN_OBJECTS_ALL table via the SOURCE_TABLE_ID foreign key to obtain metadata about the dimension's data source. More significantly, its primary key (DIMENSION_ID, ORG_ID) is referenced by other critical tables. The CN_HEAD_HIERARCHIES_ALL_B table references the DIMENSION_ID to define roll-up hierarchies for each dimension. Furthermore, the CN_OBJECTS_ALL table itself references the DIMENSION_ID, indicating that objects can be associated with specific dimensions. These relationships underscore its role as a foundational reference table for defining the analytical structure of the compensation system.

  • Foreign Key (This table references):
    • CN_OBJECTS_ALL on CN_DIMENSIONS_ALL_B.SOURCE_TABLE_ID = CN_OBJECTS_ALL.OBJECT_ID
  • Foreign Keys (Referencing this table):
    • CN_HEAD_HIERARCHIES_ALL_B on CN_HEAD_HIERARCHIES_ALL_B.DIMENSION_ID = CN_DIMENSIONS_ALL_B.DIMENSION_ID
    • CN_OBJECTS_ALL on CN_OBJECTS_ALL.DIMENSION_ID = CN_DIMENSIONS_ALL_B.DIMENSION_ID AND CN_OBJECTS_ALL.ORG_ID = CN_DIMENSIONS_ALL_B.ORG_ID