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.
