Search Results oe_def_condn_elems




Overview
Explore in AI Chat

Overview

OE_DEF_CONDN_ELEMS is a table in the ONT (Order Management) schema of Oracle E-Business Suite, documented as VALID in both 12.1.1 and 12.2.2. It stores the individual elements—columns and column values—that together compose a defaulting condition, identified by CONDITION_ID. In the Oracle Order Management defaulting framework, conditions determine whether a particular defaulting rule applies to an order, line, or attribute context. Each row in this table represents one operand of that condition, pairing an attribute (ATTRIBUTE_CODE) with a comparison operator (VALUE_OP) and a comparison value (VALUE_STRING).

The table is classified as VALID and is owned by the ONT schema. Based on the mined foreign-key structure, the heuristic Data Vault classification is standalone. This suggests a modeling interpretation in which the table behaves as an independent entity rather than a conventional hub, link, or satellite with outward foreign-key dependencies. From a Data Vault perspective, practitioners may treat CONDITION_ELEMENT_ID as a candidate hub key and the descriptive condition attributes as satellite-type payload, though the documented relationship data does not confirm formal FK edges.

Key Information Stored

The table documents 29 columns in the 12.2.2 physical schema. The most significant are:

  • CONDITION_ELEMENT_ID — Surrogate primary key, enforced by OE_DEF_CONDN_ELEMS_PK. Uniquely identifies each condition element row.
  • CONDITION_ID — Identifies the parent defaulting condition to which this element belongs. This is the central business linkage.
  • ATTRIBUTE_CODE — The order management attribute (column) being evaluated by the condition.
  • VALUE_OP — The comparison operator applied between the attribute and the value (for example, equals, not equals, contains).
  • VALUE_STRING — The literal value against which the attribute is compared.
  • ATTRIBUTE_CATEGORY — Descriptive flexfield context for the element.
  • GROUP_NUMBER — Groups multiple elements into a logical condition block, enabling AND/OR style grouping.
  • SYSTEM_FLAG — Indicates whether the element is seeded by Oracle or user-defined.
  • ZD_EDITION_NAME — Editioning column supporting Oracle EBS 12.2 online patching.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit and concurrency columns.
  • ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield segments available for extensibility.

The unique index OE_DEF_CONDN_ELEMS_U1 covers (CONDITION_ELEMENT_ID, ZD_EDITION_NAME), reflecting the edition-aware business-key candidate for the 12.2 data model.

Common Use Cases and Queries

Typical usage centers on inspecting, tracing, or auditing defaulting conditions. A common pattern joins this table to its parent condition header to retrieve complete rule definitions:

  • Listing all elements for a given condition: SELECT * FROM oe_def_condn_elems WHERE condition_id = :p_condition_id ORDER BY group_number, condition_element_id;
  • Identifying which rule uses a specific attribute: SELECT condition_id, value_op, value_string FROM oe_def_condn_elems WHERE attribute_code = 'ORDER_TYPE_ID';
  • Distinguishing seeded versus custom elements: SELECT * FROM oe_def_condn_elems WHERE system_flag = 'N';
  • Excluding edition artifacts in 12.2: filter on ZD_EDITION_NAME or use the editioning view where applicable.

Reporting use cases include documenting active defaulting logic for order entry troubleshooting and validating that no orphaned elements reference deleted conditions.

Related Objects

  • OE_DEF_CONDNS — The parent condition definition table; join on CONDITION_ID.
  • OE_DEF_HEADERS / OE_DEF_LINES — Defaulting rule headers and lines that reference conditions.
  • OE_DEF_CONDN_ELEMS — Referenced through OE_DEF_CONDN_ELEMS_PK and the unique index OE_DEF_CONDN_ELEMS_U1 for edition-aware access.
  • FND_FLEX_VALUES / FND_FLEX_VALUE_SETS — Supply valid values for flexfield-based ATTRIBUTE_CATEGORY entries.
  • OE_ORDER_HEADERS_ALL / OE_ORDER_LINES_ALL — Order tables whose attributes are evaluated by these conditions at runtime.
  • ONT Order Management defaulting APIs — OE_DEFAULTING_PUB and related PL/SQL packages that consume condition elements during order entry.