Executing Custom Code Using Oracle Workflow Business Event System

Start Here

Get in touch with a
TriCore Solutions specialist

Blog | Nov 5, 2015

Executing Custom Code Using Oracle Workflow Business Event System


The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems. 

Oracle’s eBusiness Suite (EBS) includes many methods for integration and extension. One of the most overlooked methods is the use of the Business Event System. This is not an add-on or an additional module that needs to be installed separately nor are you required to bear extra licensing fees. The business event system has been incorporated by Oracle as part of the EBS and you can start using it today.

Introduction:

The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems. The Business Event System consists of the Event Manager and the workflow process event activities.

The Event Manager contains a registry of business events, systems, named communication agents within those systems, and subscriptions indicating that an event is significant to a particular system. Events can be raised locally or received from an external system or the local system through AQ. When a local event occurs, the subscribing code is executed in the same transaction as the code that raised the event, unless the subscriptions are deferred. 

Executing custom code on the event information

The example below will show how to use custom code in a business event. We are taking an example of an employee creation. Our custom code will execute whenever the new employee creation business event is called internally. The following steps need to be performed.

1) Navigate to Workflow administrator responsibility -> Administrator workflow -> Business Events and search for the business event.

Oracle Workflow Business Event System

2) If it is disabled, change it to “Enabled”.

Oracle Workflow Business Event System

3) Create new subscription to the above event.

Oracle Workflow Business Event System

Oracle Workflow Business Event System
Oracle Workflow Business Event System

Click Apply and save it.

Note - XXCUST_CAPTURE_EMP_EVENT_FNC is the custom code created which we want to execute on the business event.

Conclusion:

A business event can be anything that happens in EBS. Apart from above example, additional example include Purchase Order Approval, Employee Termination, Update Party, User Created, Sales Order Hold and Inventory Item Update. The Oracle EBS has hardwired hundreds of business events that are pre-configured.

Business Events are highly configurable. There are standard (delivered) events, such as those mentioned above, that you can subscribe to. There are over 1200 enabled business events in the EBS. You can also create custom business events. Developers need to search for an event which may meet their extension & integration requirements and configure it accordingly.


Click below to directly get in touch with Kalpit for any questions on the topic:

Ask Ravi

Reference Links:

Oracle Workflow Developer’s Guide Release 12 Part No. B31433-01