Search Results ece_interface_column_id_s

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.

• Mapping lookup: EC_GET_MAP_ID, EC_GET_MAP_CODE, EC_GET_UPGRADE_MAP_ID, and EC_GET_MAIN_MAP_ID resolve the identity of a mapping — by numeric identifier or by map code — including the relationship between a current map and its upgraded or main (non-upgrade) counterpart. EC_GET_TRANS_UPGRADE_STATUS reports the upgrade state of a transaction's mapping.
• Upgrade routines: EC_UPGRADE_COLUMN_RULES, EC_UPGRADE_LAYOUT, and EC_UPGRADE_PROCESS_RULES migrate column-rule, layout, and process-rule definitions from the pre-upgrade structures into the corresponding _UPG tables.
• Copy routines: EC_COPY_COLUMN_RULES, EC_COPY_DYNAMIC_ACTIONS, EC_COPY_EXTERNAL_LEVELS, EC_COPY_INTERFACE_COLUMNS, EC_COPY_INTERFACE_TABLES, EC_COPY_LEVEL_MATRICES, EC_COPY_MAPPINGS, and EC_COPY_PROCESS_RULES duplicate mapping metadata, typically to seed a new map definition from an existing one.
• Map data copy and delete: EC_COPY_MAP_DATA_BY_MAPCODE, EC_COPY_MAP_DATA_BY_MAPID, and EC_COPY_MAP_DATA_BY_TRANS replicate the complete set of mapping data using a map code, a map identifier, or a transaction as the selection key; EC_DELETE_COLUMN_RULES removes column-rule definitions. Additional procedures beyond those listed follow the same utility pattern.

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.