-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Home |
Technical Articles |
Training Articles |
Receive Email for New Articles |
Contributors |
Apps Book |
Oracle Workflows Events with Payload-Part 1 | | Print | |
Written by Anil Passi | |
Monday, 15 January 2007 | |
In our earlier "workflow events" training, we saw an example to raise an event and consume that via a pl/sql function. I hope you have read Oracle Workflows Event Basics Article[linked here] When an event is raised, it must provide subscriber with enough details, by means of parameters. In the previous event article, we passed individual parameters. That works well if you have a small number of parameters. But what if you wish to pass a complete purchase order with its lines or aPayables Invoice or a Customer Record details? Obviously you will not be defining 100s of parameters for the event, hence you will pass a payload, i.e. a XML document as a parameter
The purpose of this article is :- In the next article, a workflow will be attached to this event, and that workflow will read the Payload. How will the event be raised in this example? What is a XML payload?
But why is this payload of type XML?
NOTE:- For simplicity, we will split this article into two parts
Business example:- We will pass the following parameters to event Steps in detail create or replace trigger xxap_bank_accounts_bru1 1. As soon as a Bank Account record gets modified, we are then raising this event. 4. We are using dbms_lob.writeappend to concatenate the text to clob field l_event_data.
In the next article, we will attach a workflow to this event, and the PAYLOAD will be read within the workflow. Comments
(5)
![]() ![]() written by Ramakrishna , January 18, 2007 ![]() written by Ramakrishna , January 18, 2007
Hi
Thanks a lot. And i am waiting for your Updates. ![]() written by uday , February 03, 2007
hi anil,
How are you? Thanks for you to guide us.I want to learn workflow.I dont have the workflow buider to install in my pc. How can I get that one? Is there any free downloads for workflow buider tools? what is the installation process? please mailto me. thanking you, regards, uday.k ![]() written by Anil Passi , February 03, 2007
Hi Uday,
I am very well, thanks for asking. After doing some google search I have managed to find the link for free download of Oracle Workflows. Here it is for you http://www.oracle.com/technology/software/products/workflow/index.html Good luck Anil
I am workig on Billing and Receiopt History Report. I need to raise an On Account Credit Transaction in AR. Can you please let me know whats the navigation.I am stuck here.
Thanx Murali You must be logged in to a comment. Please register if you do not have an account yet.
|
Thanks a lot. And i am waiting for your Updates.