Search Results ecx_inbound_new




Overview
Explore in AI Chat

Overview

ECX_INBOUND_NEW is an Oracle E-Business Suite PL/SQL package in the APPS schema that supports the inbound processing of XML documents within the e-Commerce Gateway (ECX) framework. Its primary responsibility is to parse and interpret XML payloads that arrive into Oracle EBS through the inbound transaction pipeline, mapping the incoming document structure against the mapping rules and standards defined in the ECX configuration tables. In the context of Oracle EBS 12.1.1 and 12.2.2, this package acts as a parser and orchestration layer that decomposes a raw XML stream into its constituent document, level, and element components, preparing them for downstream consumption by the e-Commerce Gateway's transaction-specific processors.

The package maintains a VALID status and is classified under the API classification OTHER, indicating that it is not a public, externally supported API but an internal component of the ECX inbound architecture. It depends on the ECX_NODE_TBL_TYPE collection type and standard SYS constructs, and is itself referenced by the ECX_INBOUND_NEW package body and the ECX_INBOUND_TRIG database trigger, confirming its tight integration with the inbound trigger mechanism that fires during XML document ingestion.

Key Procedures and Functions

The package exposes five documented procedures and functions that together implement the XML parsing lifecycle:

  • LOADXML — Loads the incoming XML content into the package's working structures, typically from a LOB or file source, so that the document can be subsequently parsed and traversed.
  • STARTDOCUMENT — Signals the beginning of an XML document and initializes the parser context, including any header-level metadata and document-level mapping associations.
  • ENDDOCUMENT — Signals the end of the XML document, finalizing parsing and closing out the document-level context established by STARTDOCUMENT.
  • PROCESSLEVEL — Handles a logical level within the XML document hierarchy, processing the nodes contained at that level according to the ECX mapping and standard attribute definitions.
  • PROCESS_XML_DOC — The orchestrating routine that drives end-to-end processing of an XML document, invoking the load, start, level, and end steps in sequence to complete inbound interpretation.

Tables Accessed

The package references several ECX configuration and infrastructure objects through APPS synonyms:

  • ECX_MAPPINGS — Defines the mapping between external XML document elements and internal EBS transaction fields; read to translate parsed nodes into target application data.
  • ECX_STANDARDS — Stores the standard definitions that govern how a given transaction document is structured and validated.
  • ECX_STANDARD_ATTRIBUTES — Holds the attribute-level detail for each standard, used to resolve and validate XML elements during level processing.
  • DBMS_LOB and PLITBLM — Oracle-supplied packages used to read and manipulate large object (LOB) data representing the XML payload buffer.

Usage Notes

ECX_INBOUND_NEW is invoked internally by the e-Commerce Gateway inbound processing flow, most notably through the ECX_INBOUND_TRIG database trigger, rather than being called directly from Oracle Forms or standard concurrent programs. It is not intended for direct invocation by custom code; developers integrating inbound XML should use the supported e-Commerce Gateway inbound concurrent programs and transaction definitions. Because it is classified as OTHER and is not a public API, any direct dependency on its procedures carries upgrade risk, and customizations should avoid calling it explicitly. Its behavior is governed by the ECX mappings, standards, and attributes configured in the EBS instance, so correct configuration of those tables is a prerequisite for successful XML document parsing.