Results for “operand_expression_id”

30 results




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

Overview

CN_RULE_ATTR_EXPRESSION_ALL is a transactional configuration table in the Oracle Incentive Compensation (CN) module. It stores the expressions that are constructed from rule attributes for a given compensation rule. Each row represents an individual expression node — an operator applied against one or two operands — that together form the rule logic evaluated during incentive plan processing. The table is organization-partitioned through ORG_ID and is secured through SECURITY_GROUP_ID, consistent with the multi-tenant operating unit model used throughout Oracle E-Business Suite Release 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the mined foreign-key structure suggests this object is satellite-leaning. Its grain is the individual expression row keyed by RULE_ATTR_EXPRESSION_ID, with RULE_ID functioning as a parent reference rather than a self-contained hub. The OPERAND_EXPRESSION_ID column provides a recursive link to other expression rows, making the table a hierarchical expression store rather than a flat dimension.

Key Information Stored

The documented schema contains 16 columns. The most significant are:

  • RULE_ATTR_EXPRESSION_ID — the surrogate primary key (CN_RULE_ATTR_EXPRESSION_ALL_PK) uniquely identifying each expression row.
  • OPERAND_EXPRESSION_ID — the recursive operand reference; combined with RULE_ATTR_EXPRESSION_ID and ORG_ID it forms unique index U2, and it is the term most commonly searched by integrators building expression trees.
  • RULE_ID — foreign key to CN_RULES_ALL_B, identifying the parent rule whose logic the expression belongs to.
  • OPERAND1 / OPERAND2 — the literal or attribute values participating in the operator.
  • OPERAND1_RA_RAE_FLAG / OPERAND2_RA_RAE_FLAG — flags indicating whether each operand is a rule attribute (RA) or another rule attribute expression (RAE), driving recursive resolution.
  • OPERATOR — the comparison or arithmetic operator applied to the operands.
  • ORG_ID — the operating unit; part of unique indexes U1 (RULE_ATTR_EXPRESSION_ID, ORG_ID) and U2.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS controlling row-level access.
  • OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/ADF framework.
  • Standard audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

The business-key candidates U1 and U2 distinguish the surrogate PK from the natural identifiers, ensuring no duplicate expression node exists per organization.

Common Use Cases and Queries

Typical usage centers on inspecting, tracing, and validating compensation rule logic. Common patterns include:

  • Retrieving the top-level expression nodes for a rule:
    SELECT r.* FROM cn_rule_attr_expression_all r
    WHERE r.rule_id = :rule_id AND r.org_id = :org_id;
  • Resolving nested expressions through OPERAND_EXPRESSION_ID to reconstruct the full tree.
  • Auditing rules that reference complex nested attribute expressions using the RA/RAE flags.
  • Reporting on which rules use a specific operator or operand for impact analysis before plan changes.

Analysts building expression-dependency reports typically join the recursive relationship on RULE_ATTR_EXPRESSION_ID = OPERAND_EXPRESSION_ID within the same ORG_ID and SECURITY_GROUP_ID to respect data security.

Related Objects

  • CN_RULES_ALL_B — parent rule table; joined via CN_RULE_ATTR_EXPRESSION_ALL.RULE_ID = CN_RULES_ALL_B.RULE_ID.
  • CN_RULE_ATTR_EXPRESSION_ALL (self) — recursive join via OPERAND_EXPRESSION_ID = RULE_ATTR_EXPRESSION_ID.
  • FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID for row-level security resolution.
  • CN_RULE_ATTRIBUTES_ALL — defines the rule attributes referenced by RA/RAE operands.
  • CN_RULE_ATTRIBUTES_TL — translated attribute names for reporting.
  • CN_RULES_ALL_TL — translated rule descriptions for user-facing queries.

Together these objects let developers and functional analysts reconstruct, validate, and report on Incentive Compensation rule expressions across Oracle EBS 12.1.1 and 12.2.2.