Search Results ece_proc_mappings_upg




Overview
Explore in AI Chat

Overview

The ECE_PROC_MAPPINGS_UPG table is a technical object within the e-Commerce Gateway (EC) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. As explicitly noted in its description, it functions as an upgrade table for the main ECE_PROCEDURE_MAPPINGS table. Its primary role is to support data migration and upgrade processes, specifically for procedure mapping configurations used by the e-Commerce Gateway during system patching or version upgrades. This table temporarily holds mapping data to ensure a controlled and auditable transition, safeguarding the integrity of critical integration mappings between EBS and external trading partners.

Key Information Stored

The core data stored in this table mirrors the procedure mapping definitions from its parent table. The central column, as indicated by the primary key relationship, is PROCMAP_ID. This column stores the unique identifier for a specific procedure mapping record. While the provided metadata does not list additional columns, typical data in such an upgrade table would include the mapping name, the associated inbound or outbound transaction type, the PL/SQL procedure to be executed, and various control flags. The table's sole purpose is to preserve this configuration data during an upgrade window.

Common Use Cases and Queries

Direct interaction with this table by developers or functional users is uncommon, as it is managed internally by Oracle's upgrade scripts. Its primary use case is during the application of e-Commerce Gateway patches or an EBS upgrade. Administrators might query it to verify the progress or state of an upgrade process. A fundamental query would involve selecting records by the key identifier:

  • Identifying Upgrade Records: SELECT PROCMAP_ID FROM EC.ECE_PROC_MAPPINGS_UPG WHERE PROCMAP_ID = <value>;
  • Verifying Upgrade Data Volume: SELECT COUNT(*) FROM EC.ECE_PROC_MAPPINGS_UPG;

Reporting directly against this table is not standard practice, as it contains transient data. Any reporting on active procedure mappings should be performed against the primary ECE_PROCEDURE_MAPPINGS table.

Related Objects

The table's relationship is explicitly defined with its parent table through the PROCMAP_ID column. The documented primary key constraint OCO_18586929 on PROCMAP_ID ensures data uniqueness within the upgrade table itself.

  • ECE_PROCEDURE_MAPPINGS: This is the main operational table. ECE_PROC_MAPPINGS_UPG exists solely to support its upgrade. The PROCMAP_ID column is the logical foreign key to the corresponding record in ECE_PROCEDURE_MAPPINGS, though this specific foreign key constraint may not be explicitly declared in the upgrade table.

Other related objects would include standard EBS upgrade and audit tables, but these are not formally documented in the provided relationship data for this specific object.