Search Results cn_source_all




Overview
Explore in AI Chat

Overview

The CN_SOURCE_ALL table is a core technical repository within the Oracle E-Business Suite Incentive Compensation (CN) module. It functions as a system-managed storage location for dynamically generated PL/SQL code. This code is produced by the module's internal Classification and Collection code generators, which are central to processing compensation plans. The table's role is to house the executable logic that calculates earnings, applies business rules, and determines payouts based on transactional data, enabling the flexible and performance-oriented operation of complex incentive schemes.

Key Information Stored

The table's primary purpose is to store generated PL/SQL source code and its associated metadata. While the full column list is not detailed in the provided excerpt, the documented relationships and primary key reveal critical fields. The SOURCE_ID column serves as the unique identifier for each code segment or package body. The OBJECT_ID is a foreign key linking the generated code to a specific compensation plan object (like a formula or rule) defined in the CN_OBJECTS_ALL table. The ORG_ID column supports the multi-org architecture, partitioning data by operating unit. The table likely contains columns for the actual source code (e.g., SOURCE_TEXT), a version or timestamp, and status indicators to manage code generation and execution lifecycles.

Common Use Cases and Queries

Direct interaction with this table is typically limited to diagnostic, audit, or support scenarios, as the code is managed by the application engine. Common use cases include verifying that code generation completed successfully for a plan, extracting the generated logic for debugging calculation errors, or auditing changes between plan versions. A sample query to retrieve the generated code for a specific compensation object would join on CN_OBJECTS_ALL.

SELECT cs.source_text, co.name
  FROM cn_source_all cs,
       cn_objects_all co
 WHERE cs.object_id = co.object_id
   AND co.name = 'SALES_COMMISSION_FORMULA_2024';

Administrators may also query to identify the most recently generated or largest code objects within the system for performance analysis.

Related Objects

The CN_SOURCE_ALL table has a direct and critical dependency on the CN_OBJECTS_ALL table, which is the master repository for all incentive compensation plan components. The documented foreign key relationship is:

  • CN_OBJECTS_ALL: The CN_SOURCE_ALL.OBJECT_ID column references CN_OBJECTS_ALL. This join is essential for associating dynamically generated code with its parent business object, such as a classification rule, formula, or collection plan.

While not listed in the excerpt, this table is intrinsically related to the runtime execution engine of the Incentive Compensation module. The generated code in CN_SOURCE_ALL is called by various CN package APIs during the compensation calculation process (often referred to as the "CN Process").