Search Results ece_rule_list_u1

Overview

EC.ECE_RULE_LIST is a seed-data table within the Oracle E-Business Suite E-Commerce Gateway (ECE) module, owned by the EC schema and shipped under the FND Design Data definition EC.ECE_RULE_LIST. It stores information relating to the List Column Rule. When a list column rule is assigned to a column in a transaction, a record is created in this table to indicate the action to be taken. The COMPARISON_CODE column indicates the comparison between the interface column value and the hard-coded list defined in ECE_RULE_LIST_DETAILS. In Oracle EBS 12.1.1 and 12.2.2, this table supports the ECE rule engine that governs how inbound and outbound interface columns are validated or transformed during transaction processing.

The table resides in the APPS_TS_SEED tablespace with PCT Free 10, reflecting its role as a seeded configuration table rather than a high-volume transactional table. The heuristic Data Vault classification for this object is hub-leaning, which suggests it may be modeled as a hub entity in a dimensional or Data Vault representation, given that it holds the primary identity of rule assignments referenced by dependent detail records.

Key Information Stored

The table contains twelve columns, of which LIST_RULE_ID is the surrogate primary key defined by ECE_RULE_LIST_PK. A unique index, ECE_RULE_LIST_U1, additionally constrains LIST_RULE_ID, making it both the documented primary key and a business-key candidate for uniqueness enforcement.

• LIST_RULE_ID (NUMBER, 15) — Surrogate primary key; uniquely identifies each list rule assignment.
• COLUMN_RULE_ID (NUMBER, 15) — Foreign key to ECE_COLUMN_RULES; links the list rule to its parent column rule.
• COMPARISON_CODE (VARCHAR2, 50) — Defines the comparison operator applied between the interface column value and the hard-coded list in ECE_RULE_LIST_DETAILS.
• CREATION_DATE, CREATED_BY — Standard Who columns recording initial record creation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Who columns capturing the most recent modification.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context columns identifying the request that inserted or updated the row.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios include verifying which list rules are attached to a given column rule, auditing comparison logic applied to interface columns, and tracing concurrent program activity that modified rule assignments.

To retrieve all list rules for a specific column rule:

• SELECT LIST_RULE_ID, COLUMN_RULE_ID, COMPARISON_CODE FROM EC.ECE_RULE_LIST WHERE COLUMN_RULE_ID = :p_column_rule_id;

To join list rules with their detail list values defined in ECE_RULE_LIST_DETAILS:

• SELECT L.LIST_RULE_ID, L.COMPARISON_CODE, D.<list_value_column> FROM EC.ECE_RULE_LIST L, EC.ECE_RULE_LIST_DETAILS D WHERE L.LIST_RULE_ID = D.LIST_RULE_ID;

To audit recent changes by concurrent program:

• SELECT LIST_RULE_ID, PROGRAM_ID, REQUEST_ID, LAST_UPDATE_DATE FROM EC.ECE_RULE_LIST WHERE LAST_UPDATE_DATE > SYSDATE - 7;

Related Objects

The following objects participate in the documented referential relationships for EC.ECE_RULE_LIST:

• EC.ECE_COLUMN_RULES — Parent table referenced via ECE_RULE_LIST.COLUMN_RULE_ID. Join on COLUMN_RULE_ID.
• EC.ECE_RULE_LIST_DETAILS — Child table referencing ECE_RULE_LIST.LIST_RULE_ID; stores the hard-coded list values compared against interface column values.
• EC.ECE_RULE_LIST# — The underlying base table object associated with the ECE_RULE_LIST synonym/view layer.
• EC.ECE_RULE_LIST_U1 — Unique index on LIST_RULE_ID enforcing business-key uniqueness.
• EC.ECE_RULE_LIST_PK — Primary key constraint on LIST_RULE_ID.

No additional outgoing foreign key references beyond ECE_COLUMN_RULES are documented, placing ECE_RULE_LIST within the ECE rule configuration hierarchy beneath column rules and above rule detail definitions.