{"id":12006,"date":"2014-10-26T16:23:55","date_gmt":"2014-10-26T16:23:55","guid":{"rendered":"http:\/\/erpschools.com\/?p=12006"},"modified":"2014-10-26T16:29:26","modified_gmt":"2014-10-26T16:29:26","slug":"oracle-business-events","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events","title":{"rendered":"Oracle Business Events"},"content":{"rendered":"

Oracle Business Events<\/strong><\/p>\n

Oracle Business events are like Triggers. So we have event (Business event) based on which an action can be performed. There are two kinds of business events<\/p>\n

    \n
  1. Oracle provided business events \/ Seeded Business Events<\/li>\n
  2. Custom Business Events, which we create as per our business needs.<\/li>\n<\/ol>\n

    In most of the cases we just need to create an action for a seeded business event. Oracle Corp knows most of the business requirements and they have provided us with many seeded business events which are ready to use.<\/p>\n

    I have seen many people using business events for wrong purpose just like how they use oracle workflow just to send a email. Primarily Business Events should be used as a mediator between two applications or two systems.<\/p>\n

    To help you understand business events let me provide a sample business requirement.<\/p>\n

    Business Requirement:<\/strong> We need to send a SMS to business user when certain Concurrent programs are submitted. These concurrent programs contain sensitive data so the SMS alert is required.<\/p>\n

    We can debate about the security level for a concurrent program which can be achieved through Request groups \/ Responsibilities but keep that aside.<\/p>\n

    As I can\u2019t demonstrate the SMS functionality here I will call a PLSQL function which will insert data into a custom table.<\/p>\n

    Step1:<\/span><\/p>\n

    Oracle Business events are enabled for concurrent programs from R12.1 version onwards. Check if your oracle ERP instance has concurrent program level business events enabled by navigating to Concurrent program registration form.<\/p>\n

    Navigation: Application Developer > Concurrent > Program<\/p>\n

    \"Oracle_Applications_Business_Events-1\"<\/p>\n

    Step2:<\/span><\/p>\n

    Set the profile \u201cConcurrent: Business Intelligence Integration Enable\u201d to Yes.<\/p>\n

    \"Oracle_Applications_Business_Events-2\"<\/p>\n

    Step3:<\/span><\/p>\n

    Create a Concurrent program and enable Business Event, \u201cRequest Submitted(Y)\u201d. It can be PLSQL Concurrent program \/ Oracle Report \/ Host or any other type of concurrent program.<\/p>\n

    \"Oracle_Applications_Business_Events-3\"<\/p>\n

    Read the below article to understand how to create a concurrent program. Just in case if you don\u2019t know about it..<\/p>\n

    http:\/\/erpschools.com\/articles\/register-pl-sql-stored-procedure-in-oracle-apps<\/a><\/p>\n

    Step4:<\/span><\/p>\n

    Navigate to \u201cWorkflow Administrator \u2026.\u201d responsibility<\/p>\n

    Search for \u201coracle.apps.fnd.concurrent.request.submitted\u201d business event as shown below<\/p>\n

    \"Oracle_Applications_Business_Event-5\"<\/p>\n

    Click on Subscription button<\/p>\n

    Click on Create Subscription button towards right corner<\/p>\n

    Enter the fields as below<\/p>\n

    \"Oracle_Applications_Business_Events-6\"<\/p>\n

    Click Next button and enter the details as below. Also please compile the PLSQL procedure given below in database.<\/p>\n

    \"Update_Event_Subscription__Custom\"<\/p>\n

    Click Apply button to save the subscription. You should see a successful confirmation message.<\/p>\n

    Step5:<\/span><\/p>\n

    Compile the below PLSQL in databse<\/p>\n


    \ncreate table erps_test_be (request_id number, requested_by varchar2(10));
    \n<\/code><\/p>\n


    \nCREATE OR REPLACE FUNCTION erps_conc_prog_submit_be
    \n(
    \np_subscription_guid IN RAW,
    \np_event IN OUT NOCOPY wf_event_t )
    \nRETURN VARCHAR2
    \nIS
    \nv_request_id \u00a0 NUMBER;
    \nv_requested_by NUMBER;
    \nBEGIN
    \nv_request_id \u00a0 := p_event.getvalueforparameter('REQUEST_ID');
    \nv_requested_by := p_event.getvalueforparameter('REQUESTED_BY');
    \n-- There are other possible parameters like PROGRAM_APPLICATION_ID CONCURRENT_PROGRAM_ID STATUS\u00a0 COMPLETION_TEXT
    \nINSERT
    \nINTO erps_test_be
    \n(
    \nREQUEST_ID,
    \nREQUESTED_BY
    \n)
    \nVALUES
    \n(
    \nv_request_id ,
    \nv_requested_by
    \n);
    \nCOMMIT;
    \nRETURN 'SUCCESS';
    \nEND erps_conc_prog_submit_be;<\/code><\/p>\n

    Step6:<\/span><\/p>\n

    Launch the concurrent program and see if the records are being inserted into the table.<\/p>\n

    \"Oracle_Applications_Business_EventsOracle_Applications_Business_Events\"<\/p>\n

    Query the table in backend to see the data in custom table we created.<\/p>\n

    select * from erps_test_be;<\/code><\/p>\n

    That\u2019s it\u2026You should be able to see the request_id and user_id of the person who submitted the concurrent request.<\/p>\n

    Thank you. If you have any questions \/ comments or suggestions please let me know in the comments section.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Oracle Business events are like Triggers. So we have event (Business event) based on which an action can be performed. There are two kinds of business events 1)Oracle provided business events \/ Seeded Business Events 2) Custom Business Events, which we create as per our business needs.
    \nIn most of the cases we just need to create an action for a seeded business event. Oracle Corp knows most of the business requirements and they have provided us with many seeded business events which are ready to use.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[76],"tags":[],"class_list":["post-12006","post","type-post","status-publish","format-standard","hentry","category-workflow-tools"],"yoast_head":"\noracle business events<\/title>\n<meta name=\"description\" content=\"oracle business events\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Oracle Business Events\",\"datePublished\":\"2014-10-26T16:23:55+00:00\",\"dateModified\":\"2014-10-26T16:29:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events\"},\"wordCount\":470,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Oracle_Applications_-_VIS25.png\",\"articleSection\":[\"Workflow\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events\",\"url\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events\",\"name\":\"oracle business events\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Oracle_Applications_-_VIS25.png\",\"datePublished\":\"2014-10-26T16:23:55+00:00\",\"dateModified\":\"2014-10-26T16:29:26+00:00\",\"description\":\"oracle business events\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#primaryimage\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Oracle_Applications_-_VIS25.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Oracle_Applications_-_VIS25.png\",\"width\":752,\"height\":612},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Business Events\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"oracle business events","description":"oracle business events","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Oracle Business Events","datePublished":"2014-10-26T16:23:55+00:00","dateModified":"2014-10-26T16:29:26+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events"},"wordCount":470,"commentCount":2,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Oracle_Applications_-_VIS25.png","articleSection":["Workflow"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events","url":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events","name":"oracle business events","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Oracle_Applications_-_VIS25.png","datePublished":"2014-10-26T16:23:55+00:00","dateModified":"2014-10-26T16:29:26+00:00","description":"oracle business events","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#primaryimage","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Oracle_Applications_-_VIS25.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Oracle_Applications_-_VIS25.png","width":752,"height":612},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/workflow-tools\/oracle-business-events#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Oracle Business Events"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/12006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=12006"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/12006\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=12006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=12006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=12006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}