Search Results cn_attribute_rules_all




Overview
Explore in AI Chat

Overview

The CN_ATTRIBUTE_RULES_ALL table is a core data object within the Oracle E-Business Suite Incentive Compensation (CN) module, specifically for versions 12.1.1 and 12.2.2. It serves as the repository for rule definitions that are utilized by the revenue classification generator code. This process is fundamental to the Incentive Compensation engine, as it automates the categorization and qualification of transactional revenue data for subsequent commission calculations. The table operates in a multi-organization (Multi-Org) context, as indicated by the "_ALL" suffix and the presence of the ORG_ID column, allowing rules to be defined and managed separately for different operating units.

Key Information Stored

The table's primary purpose is to define the linkage between a rule, a specific attribute (or column) from a compensation plan's data model, and the processing module that applies the rule logic. While the full column list is not detailed in the provided metadata, the foreign key relationships reveal its critical components. The key identifier is the ATTRIBUTE_RULE_ID (the primary key). The RULE_ID column references the master rule definition in CN_RULES_ALL_B. The COLUMN_ID points to the specific data object attribute (in CN_OBJECTS_ALL) upon which the rule operates. The SLICE_MODULE_ID links to the processing module (in CN_MODULES_ALL_B) that contains the executable logic for evaluating the rule against the specified column. The ORG_ID column is essential for partitioning data by operating unit.

Common Use Cases and Queries

This table is central to administrative and diagnostic activities within Incentive Compensation setup. A common use case involves analyzing the rule framework attached to a specific compensation plan or revenue class to troubleshoot classification results. System administrators may query this table to audit rule assignments or identify rules associated with a particular module during a performance review. A typical diagnostic query would join to related master tables to retrieve a readable summary of rule definitions.

Sample Query Pattern:
SELECT cara.attribute_rule_id,
      crb.name rule_name,
      coa.name column_name,
      cmb.module_name
FROM cn_attribute_rules_all cara,
     cn_rules_all_b crb,
     cn_objects_all coa,
     cn_modules_all_b cmb
WHERE cara.rule_id = crb.rule_id
AND cara.column_id = coa.object_id
AND cara.slice_module_id = cmb.module_id
AND cara.org_id = 123;

Related Objects

The CN_ATTRIBUTE_RULES_ALL table has defined foreign key relationships with several fundamental CN tables, forming a key part of the rule definition hierarchy.

  • CN_RULES_ALL_B: References via CN_ATTRIBUTE_RULES_ALL.RULE_ID. This is the master table for rule definitions.
  • CN_OBJECTS_ALL: References via CN_ATTRIBUTE_RULES_ALL.COLUMN_ID. This table stores metadata for data model objects and attributes used in compensation plans.
  • CN_MODULES_ALL_B: References via CN_ATTRIBUTE_RULES_ALL.SLICE_MODULE_ID. This table contains definitions for modules, which are units of executable business logic for processing rules and calculations.

All relationships are scoped by the ORG_ID, ensuring data integrity within the Multi-Org architecture.