Search Results ec_xml_processor_in_generic

Overview

EC_XML_UTILS is an Oracle E-Business Suite PL/SQL utility package owned by APPS that supports the E-Commerce Gateway (EC) and EDI Transaction Manager (ETRM) infrastructure for generating and consuming XML messages. It operates under AUTHID CURRENT_USER, meaning that its unqualified database object references resolve against the privileges and schema of the calling session rather than the APPS schema itself. This is significant because the package is designed to be invoked in the context of a specific trading partner or transaction definition rather than in a fixed schema.

The package bridges the gap between the Oracle EBS object layer and XML message payloads. Its core responsibilities include constructing runtime view objects (VOs) that expose the columns needed to build an outbound message, producing XML output from those view objects, consuming inbound XML and mapping it back into EBS interface tables, and orchestrating the resulting VO tree used for hierarchical message structures. The package is therefore a foundational building block of the ETRM message pipeline rather than a user-facing feature.

Key Procedures and Functions

• CREATE_TOPLEVEL_VO — Builds the top-level runtime view object for a message. Callers supply the singular and plural names, the entity object, the SELECT/FROM/WHERE/ORDER BY clauses, attributes to hide, and receive product code, error code, five generic parameter slots, and an error string. It establishes the query structure the XML generatation will later serialize.
• CREATE_CHILD_VO — Constructs a subordinate view object linked to a parent view object through bind attribute aliases and bind columns. This supports nested XML structures such as header/line/detail hierarchies. It returns the same standard diagnostic output structure as the top-level variant.
• PRODUCE_XML — Serializes the assembled view object data into an XML file identified by file name, returning product code, error code, parameter slots, and an error string. This is the outbound generation entry point.
• CONSUME_XML — Reads an inbound XML file identified by file name and maps its content back into the relevant interface structures, again returning the standard diagnostic set.
• CREATE_VO_TREE — Assembles the complete parent/child view object hierarchy used by produce and consume operations, coordinating the VO definitions created by the other procedures.
• EC_XML_PROCESSOR_OUT_GENERIC — The generic outbound processor invoked from runtime configuration (for example, a mapping or output run). It drives creation of the VO tree and calls PRODUCE_XML.
• EC_XML_PROCESSOR_IN_GENERIC — The generic inbound processor, the counterpart of the outbound routine. It consumes an XML file and populates the EBS interface tables for downstream processing.

Tables Accessed

The package reads configuration and runtime metadata from ETRM tables via APPS synonyms. ECE_EXTERNAL_LEVELS supplies the hierarchical level definitions that determine the shape of the XML document. ECE_INTERFACE_COLUMNS defines the columns available in each interface and drives VO attribute selection. ECE_MAPPINGS holds the mapping rules between EBS entities and XML elements. ECE_OUTPUT_RUNS_S is the output run sequence used to track outbound processing. DUAL is used for simple control and singleton queries.

Usage Notes

EC_XML_UTILS is typically invoked indirectly. ETRM concurrent programs, EDI transaction definitions, and the E-Commerce Gateway XML processing engine call the generic processor routines, which in turn call the utility procedures. Custom code should generally not call the low-level VO builders directly but should use the generic in/out processors to preserve ETRM's expected error handling and diagnostic return conventions. Because the package runs AUTHID CURRENT_USER, callers must ensure the invoking schema has the necessary object privileges on the underlying tables.