How to Create business event in oracle apps

Hi friends, We are going to discuss about the how we can create the business events in oracle apps. We will share the detail steps how we can create events and how we can trigger these events to execute the our custom logic. Oracle apps has already provided hundreds of standard events which we can use to configure our custom code inside that business event in oracle apps. When ever that event will be triggered based on our configuration that custom package will be executed inside that event. To create or use any business event , we also need to write the trigger. Trigger helps to execute the Business event. Without trigger business event cannot be executed. So triggering is also one of the important part to create the business event in oracle apps. In this post , We will try to share the complete example to create Business event in oracle apps. Please find below the complete details Business event in oracle apps.

Purpose of Business event in oracle apps

Business event really helps when we need to add some custom steps in the standard process. For example , If we want to perform some custom activities or code in the standard oracle process then we can use the business event to fulfill that requirement. We just need to write our custom code inside that standard event and when the standard process will be execute , it trigger the business event and business event will execute the custom code or custom activity.

In this below procedure, I am submitting one custom concurrent request automatically when user will submit program “Format Payment Instructions with Text Output” and this program will complete its execution.

Steps by Step to create Business event in oracle apps

Step 1:- The First important thing if we want to use the feature of Business event in Oracle apps. We need to set this below Profile at site level.

Concurrent: Business Intelligence Integration Enable = Yes.

Step 2:- Now Our requirement is , We want to add the custom activity in the the standard Payment Process Request process. When the PPR will submit this request then automatically system will also submit the another custom report which user wants to user but the trigger point is this below report.

Here below is the Standard Program after which our custom concurrent program should be run.

We need to enable checkbox 'Program completed' to trigger business event when this program will complete.

How to create Business event in oracle apps

Step2:- We need to Go to 'Workflow Administrator Web Applications' responsibility è

Then we need to go to 'Business Event' page.

Step3:- Now here below we need to search the business event which will suite our requirement.

Search fnd%req%comp% as below this below business event will be come.

We need to enable this Business event and then configuration on this event.

How to create Business event in oracle apps

Step 4: -After creating the Business Event , then we need to create the Subscription for the event.

Click on Subscription button and then Create Subscription button.

How to create Business event in oracle apps

Step-:-

Give values as below and click next

System: System name will be come in the LOV as we have the Instance name.

Action Type : Custom

On Error : Skip to Next.

Other things will be remain default.

Note: We will use custom procedure so you need to select action type custom.

How to create Business event in oracle apps

Step-6:- Enter the name of PLSQL procedure and give owner name and owner tag as Application name and its short code. Click apply.

As business event is the part of Application Object Library so we will give these below values as per that.

Owner Name : Application Object Library

Owner Tag: FND

How to create Business event in oracle apps

Step 7:- After Apply our Business event will be create and subscription is also created.

We can create Business events in many other scenarios like customer creation, when order will create. We can create business event and perform our task in its subscription.