Search Results ec_xml_utils




Overview
Explore in AI Chat

Overview

EC_XML_UTILS is an internal utility package body in the APPS schema that provides the XML generation and parsing infrastructure used by Oracle E-Business Suite's e-Commerce Gateway (EC/ECE) module. In EBS 12.1.1 and 12.2.2, the package functions as a reusable library of XML processing routines that translate between Oracle's internal hierarchical data structures and XML documents exchanged with external trading partners. Its central abstraction is the "VO" (VO or view object) tree — an in-memory hierarchical representation of transaction data that the package serializes to XML on outbound processing and reconstructs from XML on inbound processing.

Key Procedures and Functions

  • CREATE_TOPLEVEL_VO — Builds the root node of the VO tree, establishing the top-level structure that represents the document envelope and topmost transaction level.
  • CREATE_CHILD_VO — Creates descendant nodes within the VO hierarchy, allowing nested XML elements to be assembled level by level according to the configured document structure.
  • CREATE_VO_TREE — Orchestrates the complete hierarchical tree by invoking the top-level and child node constructors, producing the full in-memory model for a transaction.
  • PRODUCE_XML — Serializes the assembled VO tree into an XML document for outbound transmission to trading partners.
  • CONSUME_XML — Parses an inbound XML document and maps its contents into the internal VO structure for further processing.
  • EC_XML_PROCESSOR_OUT_GENERIC — Generic outbound processor that drives XML production for supported outbound transaction types.
  • EC_XML_PROCESSOR_IN_GENERIC — Generic inbound processor that drives XML consumption for supported inbound transaction types.

Tables Accessed

  • ECE_EXTERNAL_LEVELS — Defines the external (partner-facing) level structure of the transaction hierarchy, guiding how VO nodes and XML elements are nested.
  • ECE_INTERFACE_COLUMNS — Supplies the column-level mapping metadata used when translating interface records to and from XML.
  • ECE_MAPPINGS — Provides the mapping definitions between external XML elements/levels and internal interface structures.
  • ECE_OUTPUT_RUNS_S — References output run information associated with outbound XML processing.
  • DUAL — Used for singleton SQL evaluations within the package logic.

Usage Notes

EC_XML_UTILS is not intended for direct invocation by end users or custom applications. It is called internally by the e-Commerce Gateway processing programs and related EC_UTILS routines when transactions are formatted as XML rather than flat files. Inbound and outbound XML transactions are typically triggered through the e-Commerce Gateway concurrent programs or scheduled processing, which select a transaction definition and hand control to the generic processors. The package is marked VALID in the documented environment and is referenced by eight other database objects, confirming its role as a dependency of higher-level EC processing logic. Customizations should avoid modifying this package; extensions are better implemented by adding mapping configurations or by wrapping the documented generic processors. Because it holds no application state, it is safe to call within larger EC processing flows and is compatible with both 12.1.1 and 12.2.2 releases.