Search Results ecx_xref_hdr

Overview

The ECX_XREF_HDR table is a core data dictionary object within the XML Gateway (ECX) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master definition table for code conversion categories. In the context of B2B and EDI integrations, trading partners often use different code sets for identical concepts (e.g., order status, unit of measure). The XML Gateway's code conversion framework uses this table to define and manage distinct categories for these mappings, enabling seamless translation of values between internal EBS codes and external partner codes during inbound and outbound XML message processing.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the primary and foreign key relationships define its critical structure. The central column is XREF_CATEGORY_ID, which is the table's primary key. This unique identifier defines each distinct code conversion category. The table likely contains additional descriptive columns, such as a category name or description, to make these categories identifiable within the application setup forms. The essential role of this table is to act as a parent or header, under which the actual code mapping pairs are stored in related detail tables.

Common Use Cases and Queries

This table is primarily accessed during the setup and maintenance of trading partner integrations. Common administrative tasks include querying all defined conversion categories or verifying the existence of a specific category before creating mappings. A typical query would retrieve the list of available categories:

• SELECT xref_category_id, category_name FROM ecx_xref_hdr ORDER BY category_name;

During runtime message execution, the XML Gateway engine references categories defined in this table to locate the appropriate set of conversion rules. For troubleshooting mapping issues, one might join this header table to its detail lines to review all mappings for a category:

• SELECT hdr.category_name, dtl.internal_code, dtl.external_code FROM ecx_xref_hdr hdr, ecx_xref_dtl dtl WHERE hdr.xref_category_id = dtl.xref_category_id AND hdr.category_name = '<CATEGORY_NAME>';

Related Objects

The ECX_XREF_HDR table has direct parent-child relationships with two key detail tables, as defined by its foreign keys:

• ECX_XREF_DTL: This is the primary detail table that stores the actual code conversion pairs (internal and external code values) for each category defined in ECX_XREF_HDR. The relationship is enforced via the foreign key ECX_XREF_DTL.XREF_CATEGORY_ID.
• ECX_XREF_STANDARDS: This table links code conversion categories to specific messaging standards (e.g., OAG, CIDX, RosettaNet) and document types within those standards, allowing for context-specific mappings. It references the header table via ECX_XREF_STANDARDS.XREF_CATEGORY_ID.

Together, these tables form the foundational structure for the XML Gateway's code conversion engine, which is critical for ensuring data consistency in external communications.