Search Results ecx_outbound




Overview
Explore in AI Chat

Overview

ECX_OUTBOUND is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite EDI/XML Gateway architecture. It belongs to the ECX product family, which provides the core infrastructure for outbound document generation, trading partner mapping, and message transmission. In EBS 12.1.1 and 12.2.2, this package functions as the outbound processing engine that transforms application-generated business events into standardized outbound documents and dispatches them through configured transport and mapping definitions.

The package is a long-standing, valid object whose dependencies span both low-level Oracle utilities (DBMS_LOB, DBMS_SQL, XMLDOM, PLITBLM) and EBS workflow components (WF_AGENT_T, WF_EVENT_T, WF_PARAMETER_LIST_T, WF_PARAMETER_T, WF_SYSTEMS). This combination indicates ECX_OUTBOUND bridges the XML Gateway repository with the Workflow Business Event System, producing and routing outbound messages as part of the broader EDI transaction lifecycle.

Key Procedures and Functions

The ETRM documentation identifies four documented entry points within ECX_OUTBOUND. Descriptions are limited to their documented purpose; no parameter signatures are asserted here.

  • PROCESS_OUTBOUND_DOCUMENTS — The principal driver procedure. It processes outbound documents by iterating the outbound run and event structures held in the ECX repository, applying mapping and standard definitions, and generating the outbound payloads for delivery.
  • GETXML — Retrieves or constructs the XML representation of an outbound document. It supports XMLDOM-based transformation and assembly of the final message body.
  • PUTMSG — Writes or enqueues the outbound message. It interacts with the Workflow event/agent structures (WF_EVENT_T, WF_AGENT_T, WF_PARAMETER_T) to place messages for delivery.
  • Package / Package Body — The package specification and body providing the enclosing implementation, including internal SQL statements and private logic referenced from the procedures above.

The package performs internal SQL statements and is identified as referencing SYS.STANDARD. Its dependency graph shows it is referenced by ECX_DOCUMENT, ECX_STANDARD, ECX_OUTBOUND itself (recursive/overloaded calls), EDR_PSIG_RULE, EDR_UTILITIES, GMO_CBR_GRP, MSC_A2A_XML_WF, OKL_XMLGEN_PVT, and WF_DIAGNOSTICS_APPS.

Tables Accessed

ECX_OUTBOUND references the following tables through APPS synonyms, driving its outbound configuration and runtime behavior:

  • ECX_MAPPINGS — Mapping definitions translating application data to target document structure.
  • ECX_OBJECTS — Registered XML Gateway objects (documents, events) processed by the package.
  • ECX_OUTPUT_RUNS_S — Sequence for outbound run identifiers.
  • ECX_STANDARDS — Standard document/version definitions governing the outbound format.
  • ECX_TP_HEADERS — Trading partner header configuration controlling routing and transport.
  • WF_AGENT_T, WF_EVENT_T, WF_PARAMETER_LIST_T, WF_PARAMETER_T, WF_SYSTEMS — Workflow event, agent, and parameter structures used when raising and delivering outbound events.
  • DBMS_LOB, DBMS_SQL, DUAL, PLITBLM, XMLDOM — Utility/PL/SQL system objects supporting LOB handling, dynamic SQL, and XML manipulation.

Usage Notes

ECX_OUTBOUND is not typically called directly from EBS forms. Instead, it is invoked as part of the XML Gateway outbound document flow — for example, when a business event triggers document generation and the ECX outbound runtime executes PROCESS_OUTBOUND_DOCUMENTS. Because it is referenced by ECX_DOCUMENT, ECX_STANDARD, and external modules such as MSC_A2A_XML_WF and OKL_XMLGEN_PVT, customizations and extensions should treat it as a dependency-sensitive shared component. Validate any patch or upgrade against its dependent list in 12.1.1 and 12.2.2 before modifying surrounding ECX objects.