Wednesday, May 12, 2010

Business Events in Oracle Applications (R12 )

<< Business Events in Oracle Apps >>

Here in this post, I tried to explain the creation of custom business event in a step by step manner.
Our example will create a business event and through which we will populate a Custom table.

Stage 0: Navigate to System Administrator Responsibility

Move to System Administrator Responsibility and follow the below navigation to reach the Business Events HTML page. 

Stage 1: Creation of Business Event

Click the “Create Event” Button as shown in the screen to create a new custom Event 


Populate the necessary values as given in the screenshot below and click Apply. 
Our Event Name “”

Once applied successfully, you will get the confirmation message as below in the screenshot

Now go back to Business event Screen and query for our new event. Now click on the “Subscription icon” to view the available subscriptions.


Stage 2: Creation of Subscription

It can be created by clicking the “create subscription” button below


In the create subscription screen populate the values as given in the below screenshot and proceed with “NEXT”

Populate the PLSQL function name in the appropriate field and click “APPLY” to create.

Once created successfully, you will get a confirmation message as below


Query for Subscription again and check its status.


Stage 3: Creation of necessary tables and function mentioned above

  1. Creation of Table

        ( user_name VARCHAR2(10)
         ,event_time TIMESTAMP

  1. Creation of Subscription Function

CREATE OR REPLACE FUNCTION xx_apps_myevent_subs(
                 p_subscription_guid IN RAW
                ,p_event             IN OUT NOCOPY wf_event_t)
l_user_name VARCHAR2(100);  
 l_user_name := p_event.getvalueforparameter('XX_USER_NAME');
END xx_apps_myevent_subs;

Stage 4: Raising the Business Event

Query for the business event again and click the “TEST” icon to raise the test event.

Populate the necessary values like shown in the below screenshot and click the “Raise in PLSQL” button to raise the event

Once event got successfully submitted, you will get the confirmation as shown below

Check the custom table for Values inserted and time of event.

Thus the brief explanation about the creation of Business event came to end.

Thanks for reading my article.

8 Responses to “Business Events in Oracle Applications (R12 )”

Chris angel said...
June 14, 2010 at 9:11 AM

Great article about the business events

Anonymous said...
March 25, 2012 at 9:41 PM


Do you think it is mandatory to register a function and its spec should be as defined . Can we not call a procedure instead.

Please revert to

Team Share said...
July 3, 2017 at 11:11 AM

Awesome Article!!

Anonymous said...
June 19, 2021 at 12:38 PM

There's no doubt i would fully rate it after i read what is the idea about this article. You did a nice job.. store name ideas

UNKNOWN said...
September 19, 2021 at 1:48 PM

Wow, What a Excellent post. I really found this to much informatics. It is what i was searching for.I would like to suggest you that please keep sharing such type of info.Thanks creative business names

sadasda said...
December 5, 2021 at 9:04 PM

For many people this is important, so check out my profile:

Anonymous said...
February 14, 2022 at 7:14 AM

After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article. Alexander Malshakov

sadasda said...
April 16, 2022 at 3:03 AM

For true fans of this thread I will address is a free online! click here

Post a Comment


The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.