Search Results ece_rule_valueset_pk

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:

• VALUESET_RULE_ID — surrogate primary key and the unique business-key candidate, enforced by ECE_RULE_VALUESET_PK and the unique index ECE_RULE_VALUESET_U1.
• COLUMN_RULE_ID — foreign key to ECE_COLUMN_RULES; ties each value set definition to its parent column rule.
• VALUESET_NAME — the name of the Oracle value set applied to the column rule, identifying the validation source (for example, a standard or custom value set).
• CREATION_DATE, CREATED_BY — audit columns recording row creation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns capturing the most recent modification and the login context.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context columns identifying the request and program that created or last updated the row.

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.