Results for “piped_expression_disp”

42 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CN_PERF_MEASURES_ALL is a core configuration table in the Oracle Incentive Compensation (CN) module of Oracle E-Business Suite, owned by the CN schema. It stores the definition of every performance measure that can be used to evaluate participant credit, quota attainment, and commission earnings. In Oracle Incentive Compensation, a performance measure is the business quantity against which compensation rules are written — for example, revenue, margin, or unit volume — and this table is where each such measure is formally registered before it can be referenced by calculation formulas and the calculation flow graph. One row exists for each performance measure defined, and the table is dated by ORG_ID, making it a multi-org aware ("_ALL") object. Based on the foreign key structure mined from the ETRM metadata, the object is hub-leaning in a Data Vault modeling sense: it holds the durable identity and descriptive attributes of the performance measure entity, and is referenced by several dependent, link-oriented and satellite-oriented structures rather than itself acting as a transactional link.

Key Information Stored

The surrogate primary key is PERF_MEASURE_ID, enforced through the CN_PERF_MEASURES_PK constraint. Business-key candidates are documented through unique indexes: CN_PERF_MEASURES_U1 on (PERF_MEASURE_ID, ORG_ID) and CN_PERF_MEASURES_U2 on (NAME, ORG_ID), confirming that NAME must be unique within an operating unit. The most significant columns are:

Common Use Cases and Queries

Typical work includes auditing measure definitions, resolving a PERF_MEASURE_ID to a readable name, and tracing which formulas consume a given measure. A common lookup pattern resolves the surrogate key:

  • SELECT perf_measure_id, name, description, status FROM cn.cn_perf_measures_all WHERE org_id = :org_id;
  • Locating formulas that reference a measure: SELECT f.perf_measure_id, m.name FROM cn.cn_calc_formulas_all f JOIN cn.cn_perf_measures_all m ON f.perf_measure_id = m.perf_measure_id WHERE m.perf_measure_id = :id;
  • Tracing parent/child relationships in the calculation graph via CN_CALC_EDGES_ALL joined on PARENT_ID or CHILD_ID to PERF_MEASURE_ID.
  • Reviewing the SQL_SELECT, SQL_FROM, and PIPED_SQL_* columns to validate how a measure is computed for reporting or troubleshooting.

Related Objects

The following objects reference or are referenced by CN_PERF_MEASURES_ALL through the documented foreign keys:

  • CN_CALC_FORMULAS_ALL — references PERF_MEASURE_ID; defines formulas applied to the measure.
  • CN_CALC_EDGES_ALL (PARENT_ID) — parent node in the calculation graph.
  • CN_CALC_EDGES_ALL (CHILD_ID) — child node in the calculation graph.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for row-level security.

Together these relationships establish CN_PERF_MEASURES_ALL as the central definitional hub for performance measures within the Incentive Compensation calculation engine.