Thursday 25 February 2016

Create Business Event and its Subscription. How to test Business event!!!

Business event will function same as trigger. when ever any create, update or delete action will happen on business event related page it will trigger this Business event. 
We will add any PLSQL function, procedure or any java class to create some action which is related to our requirement.
e.g. if suppose on supplier page we need detail for any updated field then we can assign any custom function in subscription of business event "apps.oracle.pos.supplier.profile"

 To Create Business Event kindly add Workflow Administration Responsibility to your user.
In that responsibility you will find business event setup in below given navigation.
Workflow => Administrator Workflow => Business Events





Press on Create Event Button and enter information for Event Name, Display Name, Owner Name and Owner Tag details as shown in below screenshot.


Click on Apply Button. Then search for xxcust.oracle.test.funcBE in Business event window.
and click on subscription.


Now click on Create subscription Button


Enter system node information and mentioned Action Type as "Custom". and then click on Next Button.


Create custom function which will insert business event related information into temp table.
I have created one function "xxcust_anyevent_log" which have logic to insert business event related detail into custom table.
Mention same function name in PLSQL Rule function section as shown in below given screenshot.


click on Next button. on next page insert information for Owner name and owner Tag and then click on apply button. 


Again go back to business event Tab and search for custom business event name. you confirm business event name and subscription PLSQL function name.

To test this business event click on Test Button.


Enter Event Key as any number and then click on Raise in PLSQL button , It will show you message Event xxcust.oracle.test.funcBE is raised.



Log in to SqlDeveloper and query to custom table xxcust_test_event_log. it will show you records with custom business event.




10 comments:

  1. “I could not have closed on my first home without Mr, Benjamin Lee ! Benjamin and his team went above and beyond for me on this transaction. He handled my very tight turn around time with ease and was always available for me when I had questions (and I had plenty), even when he was away from the office, which I greatly appreciated! He and his team handled many last-minute scrambles with the seller and worked tirelessly to make sure that I could close before my lease (and my down payment assistance, for that matter) expired. Mr Benjamin is incredibly knowledgeable Loan Officer, courteous, and patient. I went through a couple offers on properties before my final purchase and Benjamin was there to help with each one, often coordinating with my agent behind the scenes. I felt supported throughout the entire process. Thanks to Benjamin and the tireless efforts of his team, I am now a proud home owner! I would encourage you to consider Benjamin Briel Lee for any kind of loan.Mr, Benjamin Lee Contact informaions.via WhatsApp +1-989-394-3740  Email- 247officedept@gmail.com.

    ReplyDelete
  2. If you are a creative-artistic entrepreneur - your need for a Business Money Plan (or commonly referred to as a Budget) is a necessity for your best business creative good. This isn't just for reasons of some business advisor or accountant telling you that you need it - you should want to need and rely on it as part of your "creative stream." Workshops In New york

    ReplyDelete
  3. Thumbs up guys your doing a really good job. Big Business

    ReplyDelete
  4. If you're interested in pursuing a technology management MBA, you first need to find an accredited on-campus or online school. This guide will help you find the right online school to earn an MBA with a focus in technology management. http://draftss.com/blog/8-tips-for-writing-a-great-design-brief/

    ReplyDelete
  5. Most Coaches start out in business for reasons such as, wanting to quit their full time job and be their own boss, or they want to gain the financial and personal freedom of being an entrepreneur, they also want to help people and make a difference in their life. No matter what the reason is, being a Coach is a fantastic profession to go in. However, what many Coaches don't realize until they are in the beginning stages of their Coaching career is that starting a coaching business is not always as easy as it seems. Many Coaches struggle trying to make it work and trying to make that leap to a successful Coaching business. In this report I will share with you eleven mistakes new Coaches make that are holding them back from reaching their ultimate goal of having a successful business. Reddit bitcoin vs nano

    ReplyDelete
  6. https://oracleappstechguide.blogspot.com/2016/02/create-business-event-and-its.html?showComment=1601379074298#c4267117139705717996

    ReplyDelete
  7. Learn the top reasons why a business plan will be rejected for funding: 1. The marketing strategy shows the business lacks competitive edge in its industry or the business lacks a robust marketing strategy and is likely to fail. 2. The management team is inadequate and in some cases lack the competencies required for business success. 3.The business strategy is unclear and/or unfocussed with the risk of exposing the funder's capital to losses. 4. Financial projections are based on a rather optimistic assumptions, which when stress-tested show that the business will fail if the most likely outcomes in the marketplace materialised. DUI Attorney Vancouver WA

    ReplyDelete
  8. To hit gold in business, you have to think gold. What is your business all about? account bookkeeping

    ReplyDelete
  9. Most businesses think that business funding is something that you need when your business is short on cash or times are hard. A lot of businesses go out looking for business funding when the business is not good. The time to get business funding is not when your business is doing horrible or you are strapped for cash. landscape supplies

    ReplyDelete
  10. This comment has been removed by the author.

    ReplyDelete

How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>

 How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>  Sometime these xml data tags automatically chang...