Results for “cond_node_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The ECX.ECX_ATTRIBUTE_MAPPINGS table is a core configuration object within the Oracle E-Business Suite XML Gateway (ECX) module. It stores the mapping information between source and target attributes used when the XML Gateway transforms inbound or outbound business documents. Each row defines how a specific source attribute in an inbound XML message or outbound transaction is associated with its corresponding target attribute in the EBS interface tables or the XML payload, together with conditional logic that governs when the mapping applies. Because the XML Gateway drives integration flows for Order Management, Purchasing, Inventory, and other modules, this table is essential to any implementation that relies on transactional XML messaging.

The table resides in the ECX schema and is documented as VALID in both EBS 12.1.1 and 12.2.2. The primary key is ECX_ATTRIBUTE_MAPPINGS_PK, defined on the composite columns MAP_ID and ATTRIBUTE_MAP_ID. A foreign key on MAP_ID references ECX_MAPPINGS, which anchors each attribute-level mapping to a header-level mapping definition. The heuristic Data Vault classification for this table is satellite-leaning, meaning it behaves as a descriptive child that records the detailed attribute relationships belonging to a parent mapping hub; this classification is a modeling suggestion rather than a documented Oracle designation.

Key Information Stored

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

• MAP_ID — Foreign key to ECX_MAPPINGS; identifies the parent mapping definition to which this attribute mapping belongs. Part of the composite primary key.
• ATTRIBUTE_MAP_ID — Surrogate identifier for the individual attribute mapping entry. Part of the composite primary key.
• LEVEL_MAPPING_ID — Associates the attribute mapping with a specific level within the mapping hierarchy, distinguishing nested or repeated structures.
• SOURCE_ATTRIBUTE_ID — Reference to the source attribute being read from the XML message or EBS object.
• TARGET_ATTRIBUTE_ID — Reference to the target attribute where the value is written.
• PARENT_ATTRIBUTE_MAP_ID — Self-referencing pointer establishing parent/child relationships between attribute mappings, supporting nested XML structures.
• OCCURRENCE — Sequence or repetition indicator controlling the order in which the mapping is applied.
• COND_VALUE — Constant or comparison value used when evaluating the conditional expression for this mapping.
• COND_NODE — Identifies the XML node against which the condition is evaluated.
• COND_NODE_TYPE — Specifies the data type or node classification used during condition processing.
• ZD_EDITION_NAME — Editioning column supporting Oracle EBS 12.2 online patching, present in the unique index ECX_ATTRIBUTE_MAPPINGS_U1.

The unique index ECX_ATTRIBUTE_MAPPINGS_U1 covers MAP_ID, ATTRIBUTE_MAP_ID, and ZD_EDITION_NAME, and represents the business-key candidate in the 12.2.2 editioned environment.

Common Use Cases and Queries

Typical scenarios include diagnosing why an inbound XML document failed to populate an EBS interface table, auditing transformation rules for compliance, and migrating mapping definitions between environments. A common query joins the attribute-level mappings to their parent mapping definition:

• Retrieve all attribute mappings for a given mapping set: SELECT * FROM ECX.ECX_ATTRIBUTE_MAPPINGS WHERE MAP_ID = :map_id ORDER BY OCCURRENCE;
• Trace source-to-target conversion: join SOURCE_ATTRIBUTE_ID and TARGET_ATTRIBUTE_ID to attribute metadata tables to translate internal IDs into human-readable attribute names.
• Inspect conditional logic: filter on COND_NODE and COND_VALUE to enumerate mappings governed by specific conditions.
• Reconstruct hierarchy: use PARENT_ATTRIBUTE_MAP_ID in a recursive query to display nested mapping trees.

Related Objects

• ECX.ECX_MAPPINGS — Parent table; joined via ECX_ATTRIBUTE_MAPPINGS.MAP_ID = ECX_MAPPINGS.MAP_ID.
• ECX_ATTRIBUTE_MAPPINGS_PK — Primary key constraint on (MAP_ID, ATTRIBUTE_MAP_ID).
• ECX_ATTRIBUTE_MAPPINGS_U1 — Unique index supporting editioned lookups.
• ECX_ATTRIBUTE_MAPPINGS self-reference — via PARENT_ATTRIBUTE_MAP_ID for hierarchical mappings.
• XML Gateway attribute and level metadata tables referenced by SOURCE_ATTRIBUTE_ID, TARGET_ATTRIBUTE_ID, and LEVEL_MAPPING_ID supply the descriptive context for each mapping row.