Search Results ec_mapping_utils




Overview
Explore in AI Chat

Overview

APPS.EC_MAPPING_UTILS is a utility package body in the Oracle E-Business Suite E-Commerce Gateway (EC) module. It provides the shared mapping engine that governs how trading-partner interface data is translated between external (transaction) hierarchies and the internal staging and interface tables used by E-Commerce Gateway inbound and outbound processing. The package centralizes operations over the mapping metadata — transaction maps, interface tables, interface columns, column rules, external levels, level matrices, process rules, and procedure mappings — so that the individual mapping and translation programs do not embed this logic themselves. A significant portion of the package is dedicated to upgrade support, maintaining a parallel set of "_UPG" tables and reconciling legacy mapping definitions with their upgraded counterparts. In the Oracle EBS 12.1.1 and 12.2.2 releases, the package is documented as VALID in the APPS schema with an API classification of OTHER, indicating that it is an internal support package rather than a published public API.

Key Procedures and Functions

The ETRM metadata documents 34 procedures and functions. They fall into four functional groups.

Tables Accessed

The package operates on the principal E-Commerce Gateway mapping metadata tables through APPS synonyms. ECE_MAPPINGS, ECE_INTERFACE_TABLES, ECE_INTERFACE_COLUMNS, ECE_COLUMN_RULES, ECE_EXTERNAL_LEVELS, ECE_LEVEL_MATRICES, ECE_PROCESS_RULES, ECE_PROCEDURE_MAPPINGS, ECE_TP_DETAILS, and ECE_STAGE hold the current mapping definitions. Parallel upgrade tables — ECE_MAPPINGS_UPG, ECE_INTERFACE_TBLS_UPG, ECE_INTERFACE_COLS_UPG, ECE_COLUMN_RULES_UPG, ECE_EXTERNAL_LEVELS_UPG, ECE_LEVEL_MATRICES_UPG, ECE_PROCESS_RULES_UPG, ECE_PROC_MAPPINGS_UPG, and ECE_TRAN_STAGE_DATA_UPG — hold the target definitions during upgrade. ECE_INTERFACE_COLUMN_ID_S supplies interface column identifiers, and ECE_TRAN_STAGE_DATA stores transaction staging data. Diagnostic output is written through EC_DEBUG, and the package depends on the SYS.STANDARD package.

Usage Notes

EC_MAPPING_UTILS is invoked internally by E-Commerce Gateway setup and processing logic rather than by end users directly. It is called from the gateway's mapping definition forms and concurrent programs whenever mapping metadata is created, copied, validated, or upgraded, and it is referenced by 13 other packages in the APPS schema. The ETRM dependency report records that no database object references the package body directly, consistent with its role as a leaf-level utility. Customizations should not call these routines as a supported API; integrators requiring mapping manipulation should use the documented E-Commerce Gateway interfaces, since the package's behavior and signature are subject to change across 12.1.1 and 12.2.2 patch levels.