Search Results edr_psig_rule




Overview
Explore in AI Chat

Overview

EDR_PSIG_RULE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM metadata as an "OTHER" API. It resides within the Oracle E-Records (EDR) product family, which provides electronic signature and electronic record retention capabilities for regulatory compliance initiatives such as 21 CFR Part 11. The package implements a signature rule function used by the Oracle Workflow Business Event System to evaluate subscription events and determine whether a given event should be routed for electronic signature processing or handled as an ordinary electronic record.

The header comment in the source (EDRRULES.pls, version 120.0.12000000.1, dated 2007/01/18) identifies the package simply as a "Signature Rule function," confirming its narrow, single-purpose role: to act as a rule function plugged into Workflow event subscriptions so that the subscription can decide, at runtime, how one specific event should be processed. In the EDR architecture, the signature rule is one of the rule functions that govern behavior of the e-records processing pipeline, including decisions about whether signatures are required, deferred, or bypassed for a particular business event.

Because the package is compiled under APPS and references WF_EVENT_T and other Workflow objects, it is intended to be invoked by the Workflow engine rather than called directly by application forms. It therefore functions as infrastructure plumbing for the Oracle E-Records and Oracle Approvals Management integration rather than as an end-user-facing API.

Key Procedures and Functions

ETRM documents a single callable program unit for this package:

  • PSIG_RULE — A function that implements the signature rule for a Workflow event subscription. It accepts a subscription GUID identifying the event subscription being processed and an event record of type WF_EVENT_T, which carries the event payload. It returns a VARCHAR2 value that the Workflow Business Event System interprets as the outcome of the rule evaluation, typically controlling whether the subscription continues processing, is deferred, or is skipped. The function is declared with the event parameter as an IN OUT NOCOPY parameter, indicating that the rule may modify the event payload before processing continues.

The source excerpt confirms the exact signature documented above; no additional procedures or functions are exposed by this package in the documented metadata, and no other packages reference it, underscoring its role as a leaf-level rule function invoked only by the Workflow engine.

Tables Accessed

The documented list of tables and views reached through APPS synonyms reflects the data the signature rule inspects while evaluating an event:

  • WF_EVENTS, WF_EVENT_SUBSCRIPTIONS, WF_PARAMETER_LIST_T — Workflow Business Event System tables used to resolve the subscription GUID passed into the function, confirm the subscription is active, and read rule parameters and event definitions.
  • EDR_ERECORDS, EDR_ERECORDS_S, EDR_ERECORD_ID_TEMP — Electronic record header and identifier tables, used to locate the e-record associated with the event and to determine whether an e-record already exists.
  • EDR_ESIGNATURES, EDR_ESIGNATURES_S — Electronic signature tables, queried to determine whether required signatures have already been captured for the record.
  • EDR_FINAL_XML_GT and EDR_REDLINE_TRANS_DATA — Global temporary and transactional structures holding final XML renderings and redline transaction data associated with the record.
  • AME_CALLING_APPS, FND_APPLICATION — Oracle Approvals Management and application registry data used to identify the calling application and apply application-specific signature configuration.
  • WF_EVENT_T, DBMS_LOB, DUAL — The Workflow event type and standard utilities used for payload manipulation and single-row queries.

Usage Notes

EDR_PSIG_RULE is not intended for direct invocation by forms, concurrent programs, or custom code. It is wired into the Oracle Workflow Business Event System as a rule function attached to an event subscription; when the subscribed event is raised, Workflow calls PSIG_RULE with the subscription GUID and the event payload. The return value governs subsequent processing of that subscription.

Because the package is compiled in APPS and marked as an "OTHER" API, Oracle does not document it as a public, supported programming interface. Customizations that need to influence signature behavior should use the supported EDR and AME configuration rather than calling or overriding this package. The comment header and version string indicate the package has been stable since 2007 and has not required patching in later 12.1.1 or 12.2.2 releases beyond recompilation against the current Workflow and EDR data model.