Search Results ece_rule_valueset




Overview
Explore in AI Chat

Overview

ECE_RULE_VALUESET is a configuration table owned by the EC schema within the Oracle e-Commerce Gateway module (EC) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the value set information associated with column-level rules that govern how transactional data is extracted, translated, and validated during outbound and inbound e-Commerce Gateway processing. In practice, the table defines which Oracle value sets constrain the acceptable values for a given column rule, giving implementers a declarative mechanism to restrict, validate, or map the data that flows through gateway interface tables.

From a Data Vault modeling perspective, the mined foreign key structure classifies ECE_RULE_VALUESET as a standalone entity. Because it holds descriptive configuration attributes keyed by its own identifier and references a parent rule table through a single foreign key, it is best modeled as a hub or reference satellite rather than a transactional link. This classification is a heuristic suggestion derived from the FK topology, not a mandated design.

Key Information Stored

The table contains twelve documented columns. The most significant are:

The surrogate key VALUESET_RULE_ID uniquely identifies each row, while COLUMN_RULE_ID establishes the relationship to the column rule hierarchy. The standard WHO-column set supports auditing and concurrent manager traceability.

Common Use Cases and Queries

Typical usage centers on diagnosing validation failures in e-Commerce Gateway transactions and documenting rule configuration for compliance. A common query joins the value set definition to its parent column rule:

  • Joining ECE_RULE_VALUESET to ECE_COLUMN_RULES on COLUMN_RULE_ID to report which value sets apply to each column rule.
  • Filtering by VALUESET_NAME to audit all rules using a given value set before modifying or retiring that value set.
  • Reviewing CREATED_BY, LAST_UPDATED_BY, and PROGRAM_ID to determine who configured a rule and which concurrent program applied the change.
  • Extracting configuration for migration or cloning to a target environment, comparing VALUESET_NAME values across instances.

A representative pattern:

SELECT vs.VALUESET_RULE_ID, vs.VALUESET_NAME, cr.COLUMN_RULE_ID FROM EC.ECE_RULE_VALUESET vs JOIN EC.ECE_COLUMN_RULES cr ON vs.COLUMN_RULE_ID = cr.COLUMN_RULE_ID;

Related Objects

The most significant related objects are driven by the documented foreign key relationship and the surrounding e-Commerce Gateway configuration model:

  • ECE_COLUMN_RULES — parent table referenced via COLUMN_RULE_ID; the primary relationship for this object.
  • ECE_RULE_VALUESET_PK / ECE_RULE_VALUESET_U1 — primary key constraint and unique index on VALUESET_RULE_ID.
  • ECE_RULES and associated rule tables — the broader rule framework within which column rules and value sets are defined.
  • FND_FLEX_VALUES_VL / FND_FLEX_VALUE_SETS — Oracle Applications value set definitions that VALUESET_NAME typically references.
  • Gateway interface and open interface tables — transactional tables validated according to these column-rule value sets during processing.

Because ECE_RULE_VALUESET is a standalone configuration table, it should be treated primarily as reference data supporting the column-rule validation layer of e-Commerce Gateway.