Results for “ecx_proc_mappings”

47 results




Overview
Explore in AI Chat

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

Overview

ECX_PROC_MAPPINGS is a table in the ECX schema (XML Gateway product) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores procedure-level mapping definitions used by the XML Gateway to describe how transactional data is bound to PL/SQL procedures, parameters, and business events during inbound or outbound message processing. Where ECX_MAPPINGS defines the top-level mapping between a business document and its processing entities, ECX_PROC_MAPPINGS provides the finer-grained procedural detail: the parameter names, data types, directions, positions, and constant or variable values that drive invocation of the mapped procedure at runtime.

From a Data Vault modeling perspective, the mined foreign-key structure classifies ECX_PROC_MAPPINGS heuristically as a link artifact. It associates two parent entities—ECX_MAPPINGS (via MAP_ID) and ECX_TRAN_STAGE_DATA (via TRANSTAGE_ID)—while carrying descriptive attributes of its own. This classification is a modeling suggestion, not a declarative property of the table itself.

Key Information Stored

The table comprises 13 documented columns. The most significant are:

  • MAP_ID – Foreign key to ECX_MAPPINGS; identifies the parent transaction mapping. Part of the composite primary key and unique index.
  • PROCMAP_ID – Identifies the procedure-mapping line. Part of the composite primary key and unique index.
  • TRANSTAGE_ID – Foreign key to ECX_TRAN_STAGE_DATA, linking the procedure mapping to a staging/transaction data record.
  • PARAMETER_NAME – Name of the procedure parameter being bound.
  • ACTION_TYPE – Classifies the action performed for the mapping (for example, call or assignment behavior).
  • VARIABLE_LEVEL – Indicates the scope at which the variable is resolved.
  • VARIABLE_NAME – Logical variable identifier used in the mapping expression.
  • VARIABLE_DIRECTION – Direction of the variable (IN, OUT, or IN/OUT semantics).
  • DATA_TYPE – Datatype of the parameter or variable.
  • VARIABLE_POS – Positional order of the variable within the procedure call.
  • VARIABLE_CONSTANT – Constant value flag or literal indicator.
  • VARIABLE_VALUE – Explicit value or expression assigned to the variable.
  • ZD_EDITION_NAME – Editioning column supporting EBR/online patching in 12.2.x.

Principal keys are ECX_PROC_MAPPINGS_PK (MAP_ID, PROCMAP_ID). The unique index ECX_PROC_MAPPINGS_U1 (MAP_ID, PROCMAP_ID, ZD_EDITION_NAME) serves as the business-key candidate, distinguishing editioned rows. The surrogate-style primary key is therefore best viewed as (MAP_ID, PROCMAP_ID), while the unique index adds the edition discriminator.

Common Use Cases and Queries

Typical scenarios include diagnosing why an XML Gateway message fails to invoke its target procedure, auditing parameter bindings for a given mapping, and reporting the full set of procedure mappings for a transaction type.

  • Resolve procedure mappings for a document: SELECT * FROM ecx.ecx_proc_mappings WHERE map_id = :map_id ORDER BY variable_pos;
  • Join to the parent mapping: SELECT p.*, m.* FROM ecx.ecx_proc_mappings p, ecx.ecx_mappings m WHERE p.map_id = m.map_id;
  • Link to staged transaction data: SELECT p.*, s.* FROM ecx.ecx_proc_mappings p, ecx.ecx_tran_stage_data s WHERE p.transtage_id = s.transtage_id;
  • Inspect parameter direction for debugging: SELECT parameter_name, variable_direction, data_type, variable_value FROM ecx.ecx_proc_mappings WHERE map_id = :map_id;

Related Objects

  • ECX_MAPPINGS – Parent mapping table; joined on ECX_PROC_MAPPINGS.MAP_ID = ECX_MAPPINGS.MAP_ID.
  • ECX_TRAN_STAGE_DATA – Staging data referenced via TRANSTAGE_ID.
  • ECX_PROC_MAPPINGS_PK – Primary key constraint/index.
  • ECX_PROC_MAPPINGS_U1 – Unique index (MAP_ID, PROCMAP_ID, ZD_EDITION_NAME).
  • XML Gateway runtime – Consumes these mappings during procedure invocation.