Search Results ece_rule_list_details




Overview
Explore in AI Chat

Overview

ECE_RULE_LIST_DETAILS is a table within the EC (e-Commerce Gateway) schema of Oracle E-Business Suite, documented as VALID in release 12.1.1 and 12.2.2. Its documented description states that it "contains the column rule list detail information." In practical terms, the table stores the individual value-level entries that make up a rule list used by the e-Commerce Gateway's inbound and outbound processing. Whereas the parent ECE_RULE_LIST table defines the header of a rule list, ECE_RULE_LIST_DETAILS holds the discrete detail rows that a rule evaluates against, such as column values or comparison operands referenced during interface transformation.

From a dimensional modeling perspective, the mined Data Vault classification is satellite-leaning. This suggests modeling the table as a satellite attached to the rule list hub represented by ECE_RULE_LIST, since the detail rows carry descriptive attributes and foreign-key linkage to the parent entity rather than acting as an independent hub or a link between multiple business keys. The classification is heuristic and should be treated as a suggestion rather than a mandated design.

Key Information Stored

The table is documented with twelve columns. The most significant for identification and relationship purposes are:

The distinction between the surrogate key (LIST_DETAIL_ID) and the parent linkage (LIST_RULE_ID) is central: the former establishes row identity, while the latter establishes membership in a rule list.

Common Use Cases and Queries

Typical usage centers on inspecting, validating, or reporting the contents of configured e-Commerce Gateway rule lists. A common query joins the detail table to its parent to resolve rule list context:

  • Retrieving all details for a given rule list: SELECT d.LIST_DETAIL_ID, d.LIST_RULE_ID, d.VALUE FROM EC.ECE_RULE_LIST_DETAILS d WHERE d.LIST_RULE_ID = :rule_id;
  • Joining to the header for descriptive reporting: SELECT h.*, d.VALUE FROM EC.ECE_RULE_LIST h, EC.ECE_RULE_LIST_DETAILS d WHERE h.LIST_RULE_ID = d.LIST_RULE_ID;
  • Audit and traceability reporting using REQUEST_ID, PROGRAM_ID, and the standard who-columns to determine which concurrent program populated or last modified a rule detail.

These patterns support troubleshooting of e-Commerce Gateway processing, where an incorrectly configured rule list detail can cause unexpected mapping or validation behavior during interface runs.

Related Objects

The documented foreign-key relationship ties ECE_RULE_LIST_DETAILS.LIST_RULE_ID to the parent table. The most significant related objects are:

  • ECE_RULE_LIST — the parent header table; joined on LIST_RULE_ID = ECE_RULE_LIST.LIST_RULE_ID.
  • ECE_RULE_LIST_DETAILS_PK — the primary key constraint on LIST_DETAIL_ID.
  • ECE_RULE_LIST_DETAILS_U1 — the unique index on LIST_DETAIL_ID.
  • The broader EC e-Commerce Gateway rule and interface tables that consume rule list configuration during inbound and outbound processing.

Because the metadata documents only the parent relationship, additional dependents should be confirmed against the specific ETRM release before being relied upon.