Search Results validate_payload

Overview

EDR_ERES_EVENT_PUB is a public PL/SQL package in the Application Object Library schema of Oracle E-Business Suite, classified as a PUBLIC API within the ETRM (E-Business Suite Technical Reference Manual) repository. Its principal business function is to enable applications to raise and validate e-record (ERES) and event-related transactions in the Oracle EBS environment. Specifically, the package handles the validation of e-record payloads, the retrieval of event and e-record metadata, and the publication of e-signature and e-record events to the Oracle Workflow Business Event System. In regulated environments where electronic records and electronic signatures must comply with 21 CFR Part 11-style controls, this package provides the technical foundation for propagating ERES-related events throughout the EBS instance. The package body is dated 2007 and shipped with the APPLDEV source label, confirming it is a delivered, supported object available across both 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes seven documented program units:

• VALIDATE_ERECORD — Validates the existence and integrity of an e-record, confirming that the referenced record is eligible for e-signature processing.
• VALIDATE_PAYLOAD — Performs payload validation, the function most frequently targeted by developers searching this object. It verifies that the data submitted for an ERES event conforms to expected structural requirements before the event is raised.
• VALIDATE_PAYLOAD_FORMS — A forms-specific variant of the payload validation routine, invoked when processing originates from an Oracle Forms (Oracle E-Business Suite Forms) user interface.
• GET_EVENT_DETAILS — Retrieves descriptive metadata for a given event, supporting downstream processing and logging.
• RAISE_ERES_EVENT — Publishes an e-record/e-signature event to the Workflow Business Event System, triggering any configured event subscriptions.
• RAISE_INTER_EVENT — Raises an internal or inter-application event, used for event propagation across modules.
• GET_ERECORD_ID — Returns the identifier of an e-record, typically used to link a parent transaction to its signature record.

Private helper routines within the body include VALID_EVENT_NAME, which confirms an event exists in WF_EVENTS_VL, and GET_OVERALL_STATUS, which derives an aggregate status across a collection of ERES events using constants from EDR_CONSTANTS_GRP.

Tables Accessed

The package references the following documented tables through APPS synonyms:

• EDR_PSIG_DOCUMENTS — The e-record/signature document repository, read and written during payload and e-record validation.
• WF_EVENTS (WF_EVENTS_VL) — The Workflow Business Event definitions, consulted to confirm event names are valid before publication.
• WF_EVENT_SUBSCRIPTIONS — Subscription definitions consulted when determining event routing during event raise operations.
• PLITBLM — The standard PL/SQL index-by table handling mechanism used internally for bulk processing.

Usage Notes

EDR_ERES_EVENT_PUB is typically invoked from ERES-enabled Oracle Forms (particularly Oracle Process Manufacturing and quality modules), from concurrent programs that must generate signature events, and from custom PL/SQL that requires programmatic event publication. Because it is classified as a PUBLIC API, direct calls are supported and preferred over modifications to underlying private logic. The package is referenced by twelve other packages within the instance, indicating its role as a central integration point for ERES event handling. Developers should always route payload validation and event raising through this package rather than writing directly to WF_EVENTS or WF_EVENT_SUBSCRIPTIONS.