Search Results ece_procedure_mappings




Overview
Explore in AI Chat

Overview

The ECE_PROCEDURE_MAPPINGS table is a core repository within the Oracle E-Business Suite e-Commerce Gateway (EC) module. It functions as a configuration registry that defines how the system maps inbound and outbound electronic data interchange (EDI) transactions to specific PL/SQL procedures for processing. This table is essential for the runtime execution of EDI integrations, as it provides the necessary metadata for the e-Commerce Gateway engine to locate and call the appropriate application logic to handle, validate, transform, and route transaction data between Oracle EBS and external trading partners.

Key Information Stored

The table's primary purpose is to store procedural call information. While the full column list is not detailed in the provided metadata, its structure is defined by its primary key and logical function. The key column is PROCMAP_ID, which uniquely identifies each mapping record. Based on its role, typical columns would include identifiers for the transaction type, direction (inbound/outbound), and the associated Oracle application. Crucially, it stores the name of the target PL/SQL procedure or package.entry point and potentially parameters required for the call, enabling the EDI framework to dynamically execute the correct business logic for each specific transaction flow.

Common Use Cases and Queries

This table is primarily accessed by the e-Commerce Gateway engine during transaction processing. Administrators and developers query it to audit, troubleshoot, or maintain EDI integration mappings. Common scenarios include verifying the procedure assigned to a specific transaction or identifying all mappings for a particular application module. A fundamental query retrieves the mapping for a known transaction:

  • SELECT procmap_id, transaction_type, procedure_name FROM ece_procedure_mappings WHERE application_id = :app_id AND direction = :direction_code;

Reporting use cases focus on generating a complete inventory of all configured EDI procedure mappings to ensure integration integrity, especially during upgrades or migrations where custom logic may be affected.

Related Objects

The ECE_PROCEDURE_MAPPINGS table is a central reference point within the e-Commerce Gateway schema. Its primary key, ECE_PROCEDURE_MAPPINGS_PK (PROCMAP_ID), is likely referenced by foreign keys in other EC transactional or control tables that need to link a specific EDI document instance to its processing instructions. While specific related tables are not listed, it is intrinsically linked to the transaction definition tables (e.g., ECE_TRANSACTIONS, ECE_TRANSACTION_TYPES) and the various inbound and outbound queue tables (e.g., ECE_INBOUND_LOGS, ECE_OUTBOUND_LOGS). The procedures referenced in its records are typically defined within application-specific packages in modules like Order Management (ONT) or Purchasing (PO).