Search Results ecx_attribute_mappings




Overview
Explore in AI Chat

Overview

The ECX_ATTRIBUTE_MAPPINGS table is a core repository within the Oracle E-Business Suite XML Gateway (ECX) module, versions 12.1.1 and 12.2.2. It serves as the definitive store for transformation rules that define how individual data elements are converted between source and target systems during electronic document exchange. This table is fundamental to the mapping engine, enabling the seamless translation of inbound and outbound XML, EDI, or other structured payloads to and from the EBS application's internal data structures. Its role is critical for ensuring data integrity and business logic adherence in B2B and A2A integration scenarios.

Key Information Stored

The table's primary function is to store attribute-level mapping definitions. Each record defines a single transformation rule. The structure is anchored by a composite primary key consisting of MAP_ID and ATTRIBUTE_MAP_ID. The MAP_ID is a foreign key that links the attribute rule to its parent mapping definition in the ECX_MAPPINGS table. The ATTRIBUTE_MAP_ID uniquely identifies the specific attribute rule within that parent map. While the provided ETRM metadata does not list all columns, typical critical columns in this context include source and target attribute identifiers (e.g., SOURCE_ATTR_CODE, TARGET_ATTR_CODE), transformation types, constant values, and sequencing information. These columns collectively define the "how" of moving a specific piece of data from a source field to a destination field.

Common Use Cases and Queries

This table is primarily accessed for mapping configuration, troubleshooting, and impact analysis. Common operational scenarios include diagnosing data transformation failures by reviewing the defined rules for a specific map or analyzing all mappings that reference a particular application attribute. Sample SQL patterns support these activities. For instance, to list all attribute mappings for a specific transaction map, one would query: SELECT * FROM ecx_attribute_mappings WHERE map_id = (SELECT map_id FROM ecx_mappings WHERE map_code = '<MAP_CODE>') ORDER BY attribute_map_id;. Another common pattern is joining with ECX_MAPPINGS to get a comprehensive view: SELECT m.map_code, am.* FROM ecx_mappings m, ecx_attribute_mappings am WHERE m.map_id = am.map_id; to report on all configured transformation rules across the system.

Related Objects

The ECX_ATTRIBUTE_MAPPINGS table has a direct and essential relationship with the ECX_MAPPINGS table, as documented in the provided metadata. The relationship is enforced by a foreign key constraint where ECX_ATTRIBUTE_MAPPINGS.MAP_ID references ECX_MAPPINGS. This means every attribute mapping must belong to a valid, higher-level mapping definition. The ECX_MAPPINGS table defines the overall document transaction map, while ECX_ATTRIBUTE_MAPPINGS stores its detailed execution steps. This parent-child relationship is central to the XML Gateway's architecture. Other related objects, such as ECX_PARTIES or ECX_DOC_ELEMENTS, may be referenced indirectly through the definitions stored within the attribute mapping records themselves.

  • Table: ECX_ATTRIBUTE_MAPPINGS 12.2.2

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_ATTRIBUTE_MAPPINGS,  object_name:ECX_ATTRIBUTE_MAPPINGS,  status:VALID,  product: ECX - XML Gateway ,  description: This table contains the mapping information between the source and target attributes ,  implementation_dba_data: ECX.ECX_ATTRIBUTE_MAPPINGS , 

  • Table: ECX_ATTRIBUTE_MAPPINGS 12.1.1

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_ATTRIBUTE_MAPPINGS,  object_name:ECX_ATTRIBUTE_MAPPINGS,  status:VALID,  product: ECX - XML Gateway ,  description: This table contains the mapping information between the source and target attributes ,  implementation_dba_data: ECX.ECX_ATTRIBUTE_MAPPINGS , 

  • Table: ECX_MAPPINGS 12.1.1

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_MAPPINGS,  object_name:ECX_MAPPINGS,  status:VALID,  product: ECX - XML Gateway ,  description: The table contains the definitions of the maps that are used by XML Gateway ,  implementation_dba_data: ECX.ECX_MAPPINGS , 

  • Table: ECX_MAPPINGS 12.2.2

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_MAPPINGS,  object_name:ECX_MAPPINGS,  status:VALID,  product: ECX - XML Gateway ,  description: The table contains the definitions of the maps that are used by XML Gateway ,  implementation_dba_data: ECX.ECX_MAPPINGS ,