Search Results xref_category_code

Overview

ECX_XREF_HDR_MAPPED_V is a reporting and integration view in the Oracle E-Business Suite XML Gateway module (product code ECX). It is owned by the APPS schema and is delivered in a VALID state in both release 12.1.1 and 12.2.2. The view exposes cross-reference (XREF) category header information — the "code categories for maps" — that is actually in use in mapping configurations, meaning only those categories that have at least one attribute mapping definition associated with them.

Within the XML Gateway architecture, cross-reference categories provide the lookup mechanism that translates internal Oracle values into the code values expected by trading partners in outbound XML messages, and vice versa for inbound messages. The header view ECX_XREF_HDR_VL supplies the descriptive layer (category code, description), while ECX_OBJECT_ATTRIBUTES holds the mapping definitions linking business objects to those categories. ECX_XREF_HDR_MAPPED_V intersects the two, yielding a clean list of categories that are genuinely referenced by at least one mapping. This makes it directly useful for functional users and developers who need to enumerate populated, mapped categories rather than the full catalog of defined categories.

Underlying Base Objects

The view is defined over two documented objects:

• ECX_XREF_HDR_VL — the multi-language "base" view over the ECX_XREF_HEADERS_B / ECX_XREF_HEADERS_TL table pair. It supplies the translated description and the base header columns. It is aliased as EXH in the view text.
• ECX_OBJECT_ATTRIBUTES — exposed as a synonym in the APPS schema, this table stores object attribute-level mapping configuration, including the XREF_CATEGORY_ID that ties each attribute definition to a cross-reference category.

The join is expressed as a correlated subquery: rows from ECX_XREF_HDR_VL are retained only where EXH.XREF_CATEGORY_ID appears in ECX_OBJECT_ATTRIBUTES. The predicate EOA.XREF_CATEGORY_ID = EXH.XREF_CATEGORY_ID is functionally an existence test (IN with an equi-correlated subquery), so duplicate attribute rows for the same category do not cause row multiplication in the parent result. The effect is a semi-join that filters categories to the mapped set.

Key Columns

• XREF_CATEGORY_ID — the primary identifier for the cross-reference category; the column referenced by xref_category_id searches. It is the join key between the category header and ECX_OBJECT_ATTRIBUTES and the primary lookup value in reporting and troubleshooting queries.
• XREF_CATEGORY_CODE — the functional (user-recognizable) short code for the category, such as the name of the trading partner code set or value-translation group.
• DESCRIPTION — the translated, meaning-bearing text for the category, sourced from the VL view's TL layer.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns recording the most recent modification to the category header.
• CREATION_DATE, CREATED_BY — standard WHO columns recording initial creation of the header record.

Common Use Cases and Queries

Typical uses include validating that a designed cross-reference category is actually wired to an object attribute mapping, generating an inventory of active mappings for a partner interface, and diagnosing mapping failures by first confirming which categories are populated.

• Enumerate all mapped categories: SELECT xref_category_id, xref_category_code, description FROM apps.ecx_xref_hdr_mapped_v ORDER BY xref_category_code;
• Resolve a known category identifier, e.g. a value returned by an inbound message error: SELECT xref_category_id, xref_category_code, description FROM apps.ecx_xref_hdr_mapped_v WHERE xref_category_id = :p_xref_category_id;
• Search by code prefix for administration screens: SELECT xref_category_id, xref_category_code, description FROM apps.ecx_xref_hdr_mapped_v WHERE UPPER(xref_category_code) LIKE UPPER(:p_code || '%');

Because the view yields only mapped categories, it is the preferred source when a report must reflect configuration in active use rather than the complete, possibly unused, category catalog returned by ECX_XREF_HDR_VL alone.