Search Results ece_rule_null_default_pk

Overview

ECE_RULE_NULL_DEFAULT is a configuration table in the e-Commerce Gateway (EC) module of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. The table stores the null-default information associated with e-Commerce Gateway column rules. When the gateway transforms or validates inbound and outbound interface data, individual columns are governed by rules held in ECE_COLUMN_RULES. Those rules may require a substitute value whenever a source column arrives null; ECE_RULE_NULL_DEFAULT is the repository that defines that defaulting behavior per column rule. The ETRM metadata classifies the object as VALID and standalone.

The object resides in the EC schema and is documented as containing "the column rule null default information." Mined from its foreign-key structure, the heuristic Data Vault classification is standalone — no subordinate tables resolve to it. From a modeling perspective this suggests treating it as a reference or satellite-style attribute table hanging off the column-rule hub, rather than as a hub or link in its own right. In practical EBS terms it is a low-volume setup table read at runtime by the e-Commerce Gateway processing engine.

Key Information Stored

The physical schema spans 13 columns. The most significant are:

• NULL_DEFAULT_ID — the surrogate primary key, enforced by ECE_RULE_NULL_DEFAULT_PK and also carried by unique index ECE_RULE_NULL_DEFAULT_U1. This is the only documented business-key candidate; there is no composite natural key.
• COLUMN_RULE_ID — foreign key to ECE_COLUMN_RULES, tying each null-default definition to exactly one column rule.
• DEFAULT_TYPE_CODE — the lookup or code indicating how the default is applied (for example constant value versus value drawn from another column).
• VALUE_COLUMN_NAME — the source column name used when the default is populated from another column, complementing DEFAULT_TYPE_CODE.
• CREATION_DATE, CREATED_BY — standard WHO audit columns recording row creation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns recording the most recent change.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent-program tracking columns identifying the request and program that last touched the row.

The audit and concurrent-program columns follow Oracle EBS conventions and support change tracking and diagnostics.

Common Use Cases and Queries

Typical uses centre on troubleshooting e-Commerce Gateway transformations and auditing gateway configuration.

• Retrieve all null defaults for a given column rule:
  SELECT NULL_DEFAULT_ID, DEFAULT_TYPE_CODE, VALUE_COLUMN_NAME FROM EC.ECE_RULE_NULL_DEFAULT WHERE COLUMN_RULE_ID = :column_rule_id;
• Join to the parent rule to see the full rule context:
  SELECT r.COLUMN_RULE_ID, r.RULE_NAME, d.DEFAULT_TYPE_CODE, d.VALUE_COLUMN_NAME FROM EC.ECE_COLUMN_RULES r JOIN EC.ECE_RULE_NULL_DEFAULT d ON d.COLUMN_RULE_ID = r.COLUMN_RULE_ID;
• Audit recent maintenance activity using the concurrent-program columns to identify which request changed the configuration.
• Report which destination columns will receive substituted values during inbound or outbound processing, supporting data-quality review.

Related Objects

The principal related objects, grounded in the documented relationships, are:

• ECE_COLUMN_RULES — the parent table; ECE_RULE_NULL_DEFAULT.COLUMN_RULE_ID references it. This is the mandatory join path.
• ECE_RULE_NULL_DEFAULT_PK / ECE_RULE_NULL_DEFAULT_U1 — primary key and unique index on NULL_DEFAULT_ID, used for direct row access.
• Other EC configuration objects such as interface-column, rule-mapping and code-conversion setup tables that the gateway consults alongside column rules during data transformation.
• e-Commerce Gateway concurrent programs that read these definitions at runtime rather than referencing them by foreign key.

Because the table is standalone, deletion or modification carries no cascading dependency risk to child tables; impact is limited to the behavior of the referenced column rule.