Search Results ecx_xref_dtl_b




Overview
Explore in AI Chat

Overview

The ECX_XREF_DTL_B table is a core data repository within the Oracle E-Business Suite XML Gateway (ECX) module. Its primary function is to store detailed code conversion mappings, enabling seamless electronic data interchange (EDI and XML) between Oracle EBS and external trading partners. When business documents like purchase orders or invoices are exchanged, the internal codes used within EBS (e.g., item numbers, unit of measure) often differ from the codes expected or sent by a trading partner. This table, in conjunction with its parent objects, provides the translation rules necessary to convert values from an internal standard to a partner-specific standard and vice versa, ensuring accurate and automated business communication.

Key Information Stored

The table's structure is designed to manage the granular details of code conversions. The primary key, XREF_DTL_ID, uniquely identifies each conversion rule. Critical foreign key columns link the detail record to its controlling headers and definitions: TP_HEADER_ID references ECX_TP_HEADERS to associate the rule with a specific trading partner; XREF_CATEGORY_ID references ECX_XREF_HDR_B to link to a specific conversion category (e.g., Item, Unit of Measure); and STANDARD_ID references ECX_STANDARDS_B to define the applicable external data standard (e.g., EDI X12, RosettaNet). The table's core payload columns typically store the internal code value, the corresponding external partner code value, and contextual attributes such as effective dates to control the rule's validity period.

Common Use Cases and Queries

The primary use case is the runtime code conversion performed by the XML Gateway engine during document mapping and processing. Administrators also interact with this data during the setup and maintenance of trading partner agreements. Common reporting and diagnostic queries include listing all active conversion rules for a specific partner or identifying mappings for a particular category. A sample query to audit item code conversions for a trading partner might resemble:

  • SELECT d.internal_value, d.external_value
  • FROM ecx_xref_dtl_b d, ecx_xref_hdr_b h, ecx_tp_headers t
  • WHERE d.xref_category_id = h.xref_category_id
  • AND d.tp_header_id = t.tp_header_id
  • AND h.name = 'ITEM'
  • AND t.tp_name = '<PARTNER_NAME>'
  • AND SYSDATE BETWEEN d.start_date_active AND NVL(d.end_date_active, SYSDATE);

Related Objects

ECX_XREF_DTL_B is centrally linked to several key XML Gateway tables, as defined by its foreign key constraints. ECX_XREF_HDR_B is its direct parent, defining the category (e.g., ITEM, CURRENCY) for which conversions are stored. ECX_TP_HEADERS provides the trading partner context, and ECX_STANDARDS_B defines the external messaging standard. The table is integral to the code conversion engine and is referenced by internal Oracle APIs and mapping programs within the ECX module. It is often joined with ECX_XREF_DTL_TL for translated descriptions of the code values.

  • Table: ECX_XREF_DTL_B 12.1.1

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_XREF_DTL_B,  object_name:ECX_XREF_DTL_B,  status:VALID,  product: ECX - XML Gateway ,  description: This table contains the trading partners code conversion values. ,  implementation_dba_data: ECX.ECX_XREF_DTL_B , 

  • Table: ECX_XREF_DTL_B 12.2.2

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_XREF_DTL_B,  object_name:ECX_XREF_DTL_B,  status:VALID,  product: ECX - XML Gateway ,  description: This table contains the trading partners code conversion values. ,  implementation_dba_data: ECX.ECX_XREF_DTL_B , 

  • Table: ECX_STANDARDS_B 12.2.2

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_STANDARDS_B,  object_name:ECX_STANDARDS_B,  status:VALID,  product: ECX - XML Gateway ,  description: This table contains the standards definitions ,  implementation_dba_data: ECX.ECX_STANDARDS_B , 

  • Table: ECX_STANDARDS_B 12.1.1

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_STANDARDS_B,  object_name:ECX_STANDARDS_B,  status:VALID,  product: ECX - XML Gateway ,  description: This table contains the standards definitions ,  implementation_dba_data: ECX.ECX_STANDARDS_B , 

  • View: ECX_XREF_DTL_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:ECX.ECX_XREF_DTL_VL,  object_name:ECX_XREF_DTL_VL,  status:VALID,  product: ECX - XML Gateway ,  description: Code conversion Trading Partner detail ,  implementation_dba_data: APPS.ECX_XREF_DTL_VL , 

  • Table: ECX_XREF_HDR_B 12.2.2

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_XREF_HDR_B,  object_name:ECX_XREF_HDR_B,  status:VALID,  product: ECX - XML Gateway ,  description: This table contains the code conversion categories. ,  implementation_dba_data: ECX.ECX_XREF_HDR_B , 

  • Table: ECX_XREF_HDR_B 12.1.1

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_XREF_HDR_B,  object_name:ECX_XREF_HDR_B,  status:VALID,  product: ECX - XML Gateway ,  description: This table contains the code conversion categories. ,  implementation_dba_data: ECX.ECX_XREF_HDR_B , 

  • Table: ECX_TP_HEADERS 12.2.2

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_TP_HEADERS,  object_name:ECX_TP_HEADERS,  status:VALID,  product: ECX - XML Gateway ,  description: This table contains Trading Partner header information ,  implementation_dba_data: ECX.ECX_TP_HEADERS , 

  • Table: ECX_TP_HEADERS 12.1.1

    owner:ECX,  object_type:TABLE,  fnd_design_data:ECX.ECX_TP_HEADERS,  object_name:ECX_TP_HEADERS,  status:VALID,  product: ECX - XML Gateway ,  description: This table contains Trading Partner header information ,  implementation_dba_data: ECX.ECX_TP_HEADERS , 

  • View: ECX_XREF_DTL_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:ECX.ECX_XREF_DTL_VL,  object_name:ECX_XREF_DTL_VL,  status:VALID,  product: ECX - XML Gateway ,  description: Code conversion Trading Partner detail ,  implementation_dba_data: APPS.ECX_XREF_DTL_VL ,