Search Results ecx_inbound




Overview
Explore in AI Chat

Overview

ECX_INBOUND is a PL/SQL package owned by the APPS schema that forms part of the Oracle E-Business Suite XML Gateway infrastructure, delivered within the EC (e-Commerce Gateway) product family. Its principal business function is to receive, parse, and process inbound XML business documents transmitted by external trading partners and application systems, converting the XML payload into structured data that Oracle EBS applications can validate and import. The package operates at the boundary between the messaging layer and the transactional application layer: it accepts an XML document, applies the mapping definitions configured for the relevant transaction type, and passes the resulting data set to the appropriate inbound processing routine.

The package depends on XMLDOM, STANDARD, and PLITBLM at the database level, and is referenced by ECX_INBOUND_NEW and ECX_INBOUND_TRIG, indicating that it participates in a coordinated set of ECX objects supporting inbound document flow. Its classification in ETRM is OTHER, and it exposes four documented program units. The status recorded is VALID across both 12.1.1 and 12.2.2.

Key Procedures and Functions

  • PROCESS_XML_DOC — The primary entry point for handling an inbound XML document. It drives the parsing and dispatch of the document through the inbound processing cycle, invoking document parsing and subsequently routing the extracted content to downstream processing logic.
  • PROCESS_DATA — Processes the structured data extracted from the XML document. It performs the mapping and transformation steps required to align the incoming content with Oracle EBS application structures, typically applying the definitions held in the ECX mapping and object metadata tables.
  • STRUCTUREPRINTINGSETUP — Establishes or prepares the structural and printing setup associated with the document being processed, supporting the layout and structural definition required for the inbound payload.
  • GETXMLDOC — Retrieves or reconstructs the XML document content, providing access to the document body for the parsing and mapping routines that follow.

Tables Accessed

  • XMLDOM — The XML DOM package interface used to parse, navigate, and manipulate the XML document tree in memory.
  • ECX_MAPPINGS — Stores the mapping rules that translate incoming XML elements and attributes into Oracle EBS application columns and values; central to PROCESS_DATA.
  • ECX_OBJECTS — Holds the registered XML Gateway document definitions, identifying the transaction type, direction, and processing characteristics of the inbound document.
  • DBMS_LOB — Supplies large object handling for reading and writing XML payloads stored as CLOB or BLOB data.
  • PLITBLM — Provides the PL/SQL index-by table support used to pass collections of document or mapping data between program units.
  • XMLPARSER — Performs the underlying parsing of the XML text into a navigable structure prior to mapping.

Usage Notes

ECX_INBOUND is not normally invoked directly by end users. It is called from the XML Gateway inbound processing path, where an inbound message is deposited and then processed, frequently through concurrent program execution or the ECX inbound server flow. External systems may trigger it indirectly by placing an XML document in the designated inbound location or by calling the XML Gateway APIs that delegate to this package.

Because ECX_INBOUND is referenced by ECX_INBOUND_NEW and ECX_INBOUND_TRIG, customizations should avoid modifying the package directly; instead, extensions should be built on the surrounding ECX objects. Any change to mapping or object metadata in ECX_MAPPINGS and ECX_OBJECTS affects the behavior of PROCESS_XML_DOC and PROCESS_DATA, so those configuration tables should be maintained through the supported XML Gateway setup rather than by ad hoc DML. The package remains VALID and is the documented inbound counterpart to the outbound ECX processing packages.