How to trigger business event in oracle apps r12

Hi Friends, we are going to discuss about How to trigger business event in oracle apps r12. We will share the detail steps to about creating business event in oracle apps and how we can trigger the business event in oracle apps r12. Oracle apps has already provided hundreds of business event. We can use these business events to execute our custom code and processed in the middle of the standard processes but we should have the complete idea about the business events and how that business event got trigger in oracle apps r12. If we have configure the standard business events to perform/execute our custom processes but not enable the trigger point for the business event then that business event will not execute. We should have to enable the triggering point to to trigger the business event in oracle apps r12. In this Post , We will try to share one example how we can trigger the business event. Please find below the complete detail about how to trigger business event in oracle apps r12.

Example of Business Event and its trigger in Oracle Apps

In this post , We will configure the Standard Business event 'Concurrent%Request%Completed'. Our business requirement is In the Standard Payment Process request , we want to trigger the custom Report. For this we found that In Standard Payment Process Request when we format the Payment batch then it triggers the 'Format Payment Instruction Program'. So that's the reason i thing to use this report 'Format Payment Instruction Program' as an trigger point to business event 'Concurrent%Request%Completed'. In Business event 'Concurrent%Request%Completed' we will write the custom code to execute the custom report.

Steps to Trigger the Business event in Oracle apps r12

Step 1:- In our example , we are using the Business event 'Concurrent%Request%Completed'. This business event related to Concurrent Programs. We are using the Standard Report 'Format Payment Instruction Program' as an trigger point to trigger the Business event 'Concurrent%Request%Completed'.

Step 2:- To trigger the Business event 'Concurrent%Request%Completed' by the concurrent program Format Payment Instruction Program' we need to create some trigger point in this concurrent program registration as below.

To trigger the Business event 'Concurrent%Request%Completed' by the concurrent program Format Payment Instruction Program' we need to enable checkbox 'Program completed'.

How to trigger business event in oracle apps r12

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

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

Step4:- 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.

How to trigger business event in oracle apps r12

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 trigger business event in oracle apps r12

Step 5-:-

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 trigger business event in oracle apps r12

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 trigger business event in oracle apps r12

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

Step 8:- One important thing related to Business Event in Oracle Apps r12 , 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