Search Results cn_rulesets_all_b_uk

Overview

The CN_RULESETS_ALL_B table is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module. It serves as the master repository for defining rulesets, which are logical groupings of revenue classification rules. These rulesets are fundamental to the process of analyzing and classifying transactional revenue data for accurate compensation calculations. The table supports multi-organization architecture through its ORG_ID column, allowing rulesets to be defined and managed at the business unit level. As a foundational table, it establishes the structural framework within which individual classification rules (stored in CN_RULES_ALL_B) are organized and executed.

Key Information Stored

The table's primary purpose is to store the definition and configuration of each ruleset. While the specific column list is not fully detailed in the provided metadata, the documented relationships and keys highlight the most critical data points. The RULESET_ID and ORG_ID columns together form the unique identifier (CN_RULESETS_ALL_B_UK) for each record. The table links to a repository (CN_REPOSITORIES_ALL) via the REPOSITORY_ID, indicating the source data context for the rules. A key functional attribute is the DESTINATION_COLUMN_ID, which references the CN_OBJECTS_ALL table to define the target column or attribute where the ruleset's output—the classified revenue—is to be stored for subsequent processing and reporting.

Common Use Cases and Queries

This table is central to the setup and maintenance of the compensation plan's logic. Common administrative tasks include querying all active rulesets for a specific business unit or validating the configuration of a ruleset before deployment. A typical query might join to related tables to get a comprehensive view of a ruleset's definition and its associated rules. For example, to list all rulesets with their destination column name and rule count, a developer or administrator might use a pattern similar to the following:

• SELECT cr.ruleset_id, cr.name, co.name destination_column, COUNT(rule.rule_id) rule_count
• FROM cn_rulesets_all_b cr,
• cn_objects_all co,
• cn_rules_all_b rule
• WHERE cr.destination_column_id = co.object_id
• AND cr.ruleset_id = rule.ruleset_id
• AND cr.org_id = :p_org_id
• GROUP BY cr.ruleset_id, cr.name, co.name;

This data is critical for troubleshooting classification errors and auditing the compensation logic flow from source transaction to calculated payout.

Related Objects

The CN_RULESETS_ALL_B table sits at the center of several key relationships within the Incentive Compensation schema, as documented by its foreign key constraints.

• Referenced By (Child Table): The CN_RULES_ALL_B table has a foreign key (RULESET_ID) referencing this table. This establishes a one-to-many relationship where a single ruleset contains multiple individual classification rules.
• References (Parent Tables):
  • CN_REPOSITORIES_ALL: Linked via CN_RULESETS_ALL_B.REPOSITORY_ID and ORG_ID. This ties the ruleset to a specific data repository.
  • CN_OBJECTS_ALL: Linked via CN_RULESETS_ALL_B.DESTINATION_COLUMN_ID and ORG_ID. This defines the output target for the ruleset's classification result.

These relationships are essential for navigating the data model during development, integration, and reporting activities within the CN module.