Search Results ec_document




Overview
Explore in AI Chat

Overview

The APPS.EC_DOCUMENT package is a core component of the Oracle E-Business Suite e-Commerce Gateway (EC) module, which provides the infrastructure for exchanging electronic business documents (EDI) between Oracle applications and external trading partners. The package encapsulates the runtime logic required to transform, assemble, and transmit outbound business documents—such as purchase orders, invoices, acknowledgements, and advance ship notices—that have been staged by the e-Commerce Gateway processing engine. It operates within the APPS schema and is classified under the ETRM API taxonomy as OTHER, indicating it is an internal processing utility rather than a public, end-user-facing API.

In both Oracle EBS 12.1.1 and 12.2.2, EC_DOCUMENT functions as a bridge between the document data stored in the ECE interface tables and the transport mechanism that delivers the finalized document to the trading partner. It depends on FND_API for standard API error and message handling, and on SYS.STANDARD for PL/SQL built-in functionality.

Key Procedures and Functions

The ETRM metadata documents three procedures within this package:

  • SEND — Drives the transmission of a prepared outbound document. This procedure orchestrates the handoff of the document payload to the appropriate outbound transport or delivery handler, respecting the destination configuration maintained for the trading partner.
  • PROCESS_OUTBOUND — Executes the outbound document processing flow. It assembles document records, applies the relevant mapping rules, and stages the output for delivery. This is the principal entry point invoked during an outbound e-Commerce Gateway run.
  • POPULATE_TMP_PARM_STACK — Populates a temporary parameter stack used to pass runtime parameters between processing stages. This internal helper supports the parameterized execution of the outbound document pipeline.

No parameter signatures are documented in the source metadata; callers should treat these as internal procedures invoked through the standard e-Commerce Gateway processing framework rather than as a stable custom-call interface.

Tables Accessed

The package reads and writes the following tables, referenced through APPS synonyms:

  • ECE_MAPPINGS — Stores the mapping definitions that translate Oracle application data into the external EDI document format.
  • ECE_OUTPUT_RUNS_S — Holds the sequence and run-level information for outbound processing executions, tracking each document generation run.
  • ECE_TRAN_PARAMETERS — Contains trading-partner-specific transmission parameters that govern how a document is delivered.
  • DBMS_UTILITY, DUAL, and PLITBLM — Utility references used for PL/SQL operations and temporary collection handling.

Usage Notes

EC_DOCUMENT is not intended for direct invocation by end users. It is invoked indirectly by the e-Commerce Gateway processing infrastructure and by other packages that participate in the outbound document lifecycle. The metadata confirms it is referenced by ECE_AP_PAYMENT, IGW_EDI_PROCESSING, WSH_DSNO, and recursively by EC_DOCUMENT itself. In practice, this package fires during concurrent program runs such as the e-Commerce Gateway outbound extract and transmission programs. Custom code should avoid calling these procedures directly, as their behavior is tied to the internal state managed by the ECE processing framework and is subject to change across patch levels in 12.1.1 and 12.2.2.