Search Results fnd_bes_proc

Overview

FND_BES_PROC is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It is classified under the API classification "OTHER," indicating that it does not conform to the standard Open Interface or public API conventions used by many EBS modules. The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the definer, a common pattern for internal infrastructure routines that must respect the caller's security context.

The package functions as a Business Event System (BES) subscription handler within the Oracle Workflow event framework. Its single documented function, PROCESS_EVENT, is designed to receive an event payload and process it according to the logic encapsulated in the package body. Such handler packages are registered as subscriptions against events in the Business Event System, allowing the application to respond programmatically when specific business events are raised. The naming convention and its proximity to other AF-prefixed Workflow source files (as indicated by the header comment referencing AFBESPROCS.pls) place it within the Oracle Application Framework/Workflow integration layer shipped with EBS releases 12.1.1 and 12.2.2.

Key Procedures and Functions

• PROCESS_EVENT — The sole documented function in the package specification. It accepts a subscription GUID and an event payload of type WF_EVENT_T, and returns a VARCHAR2 result. The subscription GUID identifies the specific Business Event System subscription being executed, while the WF_EVENT_T parameter carries the event name, event key, and parameter data raised on the event queue. The function returns a status value that the Business Event System uses to determine whether the subscription completed successfully. Because the ETRM metadata documents only the signature, the internal processing logic is not exposed; however, the return value and parameter shape conform to the standard Oracle Workflow subscription handler interface used by the Event Manager when dispatching subscriptions.

Tables Accessed

The package references the WF_EVENT_T datatype, which is the Oracle Workflow event message type defined in the Workflow schema and surfaced in APPS through the standard APPS synonym layer. This is a PL/SQL record type rather than a physical table, but it is the primary data structure through which event information flows into the function. The Business Event System itself persists event and subscription metadata in Workflow tables such as WF_EVENTS, WF_EVENT_SUBSCRIPTIONS, and the event queue tables, though the ETRM metadata does not list these as directly referenced by FND_BES_PROC. No other tables are documented as being accessed by this package, and it is not referenced by any other package in the EBS codebase, confirming its role as a leaf-level handler rather than a shared utility.

Usage Notes

FND_BES_PROC is invoked indirectly by the Oracle Workflow Business Event System when a subscription whose handler points to this package is triggered. It is not called directly from forms, concurrent programs, or typical custom code. Administrators configure the association between an event and this handler through the Business Event System subscription setup, specifying the package, function, and any required parameters. When the event is raised via WF_EVENT.Raise or through a deferred subscription, the Event Manager invokes PROCESS_EVENT and interprets the returned status. Because it is not a documented public API and is referenced by zero other packages, customizations should not call it directly; instead, developers extending Business Event System behavior should implement their own subscription handlers following the same signature pattern. The package has remained stable since at least the 2005 source revision indicated in its header comment and continues to ship without modification across both 12.1.1 and 12.2.2.