Search Results cn_formula_inputs_all




Overview
Explore in AI Chat

Overview

The CN_FORMULA_INPUTS_ALL 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 the individual input parameters required by calculation formulas. These formulas are used to compute commissions, bonuses, and other incentive payouts for sales personnel. The table's role is to structurally define the variables—such as revenue amounts, attainment percentages, or fixed rates—that feed into the complex compensation logic, enabling the system to dynamically process earnings based on transactional data and performance metrics. Its "ALL" suffix indicates it is a multi-organization table capable of storing data for multiple operating units.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal the essential data structure. The central column is FORMULA_INPUT_ID, the unique primary key identifier for each input definition. The CALC_FORMULA_ID is a critical foreign key column that links each input to its parent calculation formula in the CN_CALC_FORMULAS_ALL table. Other typical columns in such a table would include SEQUENCE_NUMBER to define the order of inputs, INPUT_NAME or DISPLAY_NAME for identification, DATA_TYPE (e.g., NUMBER, VARCHAR2), and potentially DEFAULT_VALUE. The table essentially stores the metadata that describes what data points a formula expects to receive during calculation execution.

Common Use Cases and Queries

This table is primarily accessed for formula design, validation, and troubleshooting within the Incentive Compensation engine. A common use case is auditing all inputs associated with a specific calculation formula to understand its dependencies. For example, a compensation analyst might run a query to list all inputs for a formula named 'QTRLY_BONUS_2024'. Sample SQL patterns often involve joining to CN_CALC_FORMULAS_ALL:

  • SELECT fi.input_name, fi.data_type, fi.sequence, cf.name AS formula_name FROM cn_formula_inputs_all fi, cn_calc_formulas_all cf WHERE fi.calc_formula_id = cf.calc_formula_id AND cf.name = 'QTRLY_BONUS_2024' ORDER BY fi.sequence;

Technical consultants may also query this table to diagnose calculation errors by verifying that all required inputs for a formula are correctly defined and populated by the upstream processing of transactions and rates.

Related Objects

The CN_FORMULA_INPUTS_ALL table has defined relationships with other key Incentive Compensation objects, as per the provided metadata:

  • CN_CALC_FORMULAS_ALL: This is the parent table. The relationship is maintained via the foreign key CN_FORMULA_INPUTS_ALL.CALC_FORMULA_ID, which references CN_CALC_FORMULAS_ALL. This links every formula input to its master formula definition.
  • CN_CALC_EDGES_ALL: This table references CN_FORMULA_INPUTS_ALL. The foreign key CN_CALC_EDGES_ALL.PARENT_ID points to CN_FORMULA_INPUTS_ALL.FORMULA_INPUT_ID. The CN_CALC_EDGES_ALL table typically models the dependencies and execution flow between formulas and their inputs/outputs, meaning a formula input can be a parent node in the calculation dependency graph.