How To Create and Use Custom Business Events in Oracle E-Business Suite
Oracle Workflow, a component of Oracle E-Business Suite, lets you set up subscriptions to business events which can launch workflows or enable messages to be propagated from one system to another when business events occur.
The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems.
Predefined events are provided with some Oracle E-Business Suite products. For example, the “Create Person Event” (oracle.apps.ar.hz.Person.create) is the name of a seeded business event in the Receivables application. The event is triggered when a person party record is created within the Trading Community Architecture (TCA).
Not all events are seeded. However, Oracle gives you the option to create a custom event. An example would be an event that is triggered when an invoice is matched to a purchase order.
In this article, I will show you how to create and use a custom business event. I will go through the following steps:
- Create a custom business event
- Create a subscription to the event
- Raise the event from PL/SQL
Consume the event in PL/SQL
Five Features You Ought to Know About the Oracle Scheduler
I really enjoyed Kscope last week. It was educational, entertaining and social. Many thanks to ODTUG and the Oracle ACE program and to everyone who made it happen.
Check out Markus‘s awesome Flickr album to get a taste of how good the conference was, especially All Aboard The Queen Mary event. 
My presentation went very well, judging from the postive feedback I got from the audience. Here is the paper that I submitted to Kscope:
Comments Off | Filed in Oracle | Tags: dbms_scheduler, kscope
