Results for “expression_disp”
38 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:
- ORG_ID — the operating unit that owns the measure; drives multi-org security and uniqueness.
- PERF_MEASURE_ID — surrogate primary key and the value most commonly searched by users.
- NAME / DESCRIPTION — the business name and free-text description of the measure.
- COMMENT_LONG — extended documentation supplied by the implementer.
- EXPRESSION_DISP — the human-readable display form of the measure's expression.
- STATUS — lifecycle state of the measure definition.
- SQL_SELECT / SQL_FROM — the SQL fragments that compute the measure from source data.
- PIPED_SQL_SELECT / PIPED_SQL_FROM / PIPED_EXPRESSION_DISP — the piped (streaming) variant of the calculation SQL and its display expression.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield columns.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling row-level visibility.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — the standard WHO audit columns.
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.
-
Contains information about performance measure. You need one row for each performance measure defined.
-
This table contains the sql expressions used in calculation process.
-
Contains information about performance measure. You need one row for each performance measure defined.
-
This table contains the sql expressions used in calculation process.
-
VIEW: APPS.CN_PERF_MEASURES 12.2.2
-
VIEW: APPS.CN_PERF_MEASURES 12.2.2
-
VIEW: APPS.CN_PERF_MEASURES 12.1.1
-
VIEW: APPS.CN_PERF_MEASURES 12.1.1
-
eTRM - CN Tables and Views 12.1.1
-
eTRM - CN Tables and Views 12.2.2