How to Find Business Event and Create Subscriptions

·   In this blog we are considering the lookup code insert event for demonstration.

     1. Navigate to Responsibility: Workflow Administrator >> Administrator Workflow >> Business Events

2. All seeded events will start with ‘oracle.apps.’  then next we need to provide the application short name on which we want to create subscription.     

     3. In our case its ‘fnd’ as lookup will be register with application ‘Application Object Library’

·    4. We are taking event named oracle.apps.fnd.lookup.code.insert which will trigger when we insert some code in the lookup.

·    5. Search the event name ‘oracle.apps.fnd.lookup.code.insert’ by typing in the Name field

6.  Click on Create Subscription button.

 7. The System field will get populated with default name, if not click on search button and select appropriate name.

 8. You must specify the source type of the events to which the subscription applies. Events can have the following source types:

• Local--The subscription applies only to events raised on the subscribing system.
• External--The subscription applies only to events received by an inbound agent on the subscribing system.
• Error--The subscription applies to only to errored events dequeued from the WF_ERROR queue or the WF_JAVA_ERROR queue.

     9. The phase number for a subscription controls whether the subscription is executed immediately or is deferred. The Event Manager treats subscriptions with a phase number of 100 or higher as deferred subscriptions. Subscriptions with a phase number from 1 to 99 are executed immediately.

10.  Defining the Action for a Subscription

         Subscription processing can include the following types of processing

Action Type	Description
Custom	Execute custom business logic
Invoke REST Service	Invoke REST Service from BES Subscription
Invoke SOAP Service	Invoke SOAP Service from BES Subscription
Launch Workflow	Launch the workflow specified in the subscription
Receive Trading Partner Message	Receive a message from your trading partner
Send to Agent	Send the event to the agent specified in the subscription
Send Notification	Send a notification using standard or your own message templates
Send Trading Partner Message	Generate a message and send the message to your trading partner

    11. In our case we are calling custom package function, so we select Action type as Custom.

12. We can call below types of Functions

o   Java function.

o   PLSQL function.

o   Workflow.

       13.  In our example we are calling the PLSQL function named ‘xx_event_subscription_pkg event_subscription_func’.

14. An agent is a named point of communication within a system. Communication within and between systems is accomplished by sending a message from one agent to another. A single system can have several different agents representing different communication alternatives. For example, a system may have different agents to support inbound and outbound communication, communication by different protocols, different propagation frequencies, or other alternatives.

When you define an agent in the Event Manager, you must specify the direction of communication that the agent supports on its local system.

• In--Inbound communication to the system. The agent receives messages in a specific protocol and presents them to the system in a standard format.
• Out--Outbound communication from the system. The agent accepts messages from the system in a standard format and sends them using the specified protocol.

     15. Enter Owner Name and Owner Tag with event application owner usually it will be application short name.

    16. In our case its fnd.

    17. Then click on Apply button, that will save the subscription.

   18. In the mentioned package function, we are inserting the event name, sequence number and sysdate in to the table ‘xx_test_event_subscription_tbl’.

   19. So, whenever we insert and record in to the lookup we should see record in this custom table.

20. Insert the record in lookup then query the custom table, you can see record inserted in that table.