Search Results edr_general_subs




Overview
Explore in AI Chat

Overview

The EDR_GENERAL_SUBS package is a subscriber routine within the Oracle E-Business Suite Electronic Data Records (EDR) module, which governs the XML Gateway and electronic document exchange framework. Its stated purpose is to provide a centralized "subscriber" entry point that the Oracle Workflow Business Event System (WF_EVENT_T) can invoke when an EDR-related business event is raised. As the name "GENERAL_SUBS" implies, the package is deliberately general-purpose: it is designed to be referenced by event subscriptions rather than to implement domain-specific business logic itself.

In Oracle EBS 12.1.1 and 12.2.2, the EDR subsystem is responsible for generating, storing, and transmitting electronic documents such as purchase orders, invoices, and advance ship notices using the XML Gateway. This package exists to support the machinery around those documents, specifically the upload and association of XML stylesheets that determine how transmitted documents are rendered and transformed. The header comment indicates the package has been stable since release 120.0 (2007), signalling that while the EDR framework predates 12.1.1, the subscriber signature remains unchanged across 12.1.x and 12.2.x.

Key Procedures and Functions

The package exposes a single documented procedure:

  • UPLOAD_STYLESHEET — This is the sole public routine. It accepts a workflow item type, item key, activity ID, function mode, and an OUT result parameter, and its role is to upload or register an XML stylesheet against the EDR/XML Gateway infrastructure. In the context of the Business Event System, the parameters follow the standard Workflow subscription callback convention, where the first four parameters are supplied by the event system and the final OUT parameter returns the outcome of the upload. No additional overloads or helper procedures are documented, and the parameter list above should not be extended or altered by custom code.

No functions are documented for this package, and no private procedures are visible in the published specification.

Tables Accessed

The package is documented to reference several underlying objects through APPS synonyms:

  • ECX_FILES — The XML Gateway files repository, which stores stylesheet and document template content. This is the principal target for the upload operation.
  • WF_EVENT_T — The Workflow event data structure, used to read the event payload when the subscription fires.
  • DBMS_LOB — The Oracle-supplied large object package, used to read or write stylesheet contents as CLOBs/BLOBs.
  • UTL_RAW — The Oracle-supplied raw utility package, used for binary/raw conversion during upload.

Because the package reads and writes ECX_FILES, it should be regarded as a data-modifying routine and treated with the same care as any XML Gateway configuration change.

Usage Notes

EDR_GENERAL_SUBS is not designed for direct invocation from custom forms or concurrent programs. It is a Workflow event subscriber: an administrator configures a subscription in the Workflow Administrator responsibility (or via the Business Event System APIs) that references EDR_GENERAL_SUBS.UPLOAD_STYLESHEET as the subscription rule function. When the associated EDR business event fires, Workflow calls the procedure with the event context parameters.

Typical invocation paths include:

  • Automated style­sheet deployment during XML Gateway configuration migration.
  • Event-triggered upload when new EDR templates are delivered via patching or upgrades.
  • Custom subscriptions created by implementers who need to register stylesheets programmatically.

Because the package references ECX_FILES directly, any use should be preceded by a backup of the XML Gateway repository, and any modification should be made only through a supported event context to preserve referential integrity with the Workflow event tables. Direct SQL calls to UPLOAD_STYLESHEET outside the event framework are not recommended and are not documented by Oracle.