Monday, May 17, 2010

Business Events In Oralce apps (R12)


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 “xx.oracle.apps.myevent”


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

  CREATE TABLE XX_BUSIEVNT_TEST
        ( 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)
RETURN VARCHAR2 IS
l_user_name VARCHAR2(100);  
BEGIN
 l_user_name := p_event.getvalueforparameter('XX_USER_NAME');
 INSERT INTO XX_BUSIEVNT_TEST
            (user_name
            ,event_time)
 VALUES
            (l_user_name
            ,SYSTIMESTAMP);
 COMMIT;
 RETURN 'SUCCESS';
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.

14 Responses to “Business Events In Oralce apps (R12)”

Anonymous said...
April 18, 2011 at 7:41 PM

I do not see the Create Option.

Please advise.


Anonymous said...
May 4, 2012 at 3:35 AM

Thanks a lot. it is really helpfull.


Anonymous said...
May 4, 2012 at 3:36 AM

Can you please porvide the raising the Business event from the PLSQL code if you have the API's?


Unknown said...
October 7, 2016 at 10:56 PM

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.


Unknown said...
December 29, 2018 at 9:50 PM

Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com


Hetuwa Duminda said...
April 9, 2020 at 11:58 PM

You are very cool! I dont suppose I have read something similar to this before. So nice to search out somebody with authentic applying for grants this subject. I really appreciate starting this up. Your website is one area that is needed on the net. Totally a helpful project for bringing new things for the web! app store mockup


Hetuwa Duminda said...
April 11, 2020 at 4:02 AM

Enjoyed looking at this, very good stuff, thanks . apple app store mockup


Stream Line said...
April 16, 2020 at 11:11 PM

Free online games… [...]With havin so much content do you ever run into any problems of plagorism or copyright infringement? My website has a lot of completely unique content I’ve either authored myself or outsourced but it looks like a lot of it is popping it up all ov… desktop mockup


Hetuwa Duminda said...
April 20, 2020 at 4:16 AM

Regards for this post, I am a big fan of this website would like to go along updated. free imac mockup


jhone than said...
April 20, 2020 at 3:46 PM

Some really nice stuff on this web site , I like it. imac mock ups


jhone than said...
April 20, 2020 at 3:47 PM

I want reading through and I conceive this website got some really utilitarian stuff on it! . desktop mockup


Unknown said...
May 10, 2020 at 12:28 PM

As soon as I found this internet site I went on reddit to share some of the love with them. app development companies


Experties said...
May 27, 2020 at 5:09 AM

I am glad that it turned out so well and I hope it will continue in the future because it is so worthwhile and meaningful to the community. front end service


william locas said...
May 31, 2020 at 3:27 AM

Just wanna comment that you have a very nice internet site , I love the design it actually stands out. best logo design company


Post a Comment

Disclaimer

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.