Workflow Business Events XML Test Payload
Written by Anil Passi   
Friday, 19 January 2007
As mentioned in previous article, we will attempt to extract the value of Bank Account Number from the Payload. The extracted value will then be assigned to the WF Attribute. Lets see this working, in steps. You must implement previous article [ Link here for Workflow with Payload ] before trying this exercise.

Step 1. Run the below update
update ap_bank_accounts_all t set t.bank_account_num = '101010' where rownum < 2 ;
commit;
This step will build the XML Payload and initiate the event.


Step 2. Lets go to WF Status Monitor and check to see if Workflow Process has been launched.



Step 3. Click on Workflow details to see if Bank Account Number has been extracted and assigned to desired WF Attribute.



This concludes the testing of XML Payload with Oracle Workflows Business Event.

Note:- You may also decide to use the "Test Functionality" by clicking on Test button in Workflow Event screen. However I preferred testing via a methodology that encapsulates end-to-end approach.




Comments (10)add
...
written by agostino_neto , January 19, 2007
Hi,
For subscriptions, we have to select our system and attach our workflow.
I am able to launch workflow but I can not see bank account number.
XML data is only like this:
-
xx.ap.bank.accountupdate
19486
...
written by Ramakrishna , January 19, 2007
Hi
Anil,
after updating records in ap_bank_accounts_all table. not able to see the status monitor for this process..
...
written by Anil Passi , January 19, 2007
.
.
.
Hi Ram

I am impressed, you were quick in trying this out.
May be your subscription is in the deferred queue.
Is the phase of subscription between 1 and 99?

If so, email me your screenshots of your event/subscription definitions.

Thanks
Anil Passi
...
written by agostino_neto , January 19, 2007
Hi,
For subscriptions, we have to select our system and attach our workflow.
I am able to launch workflow but I can not see bank account number.
XML data is only like this:
-
xx.ap.bank.accountupdate
19486
...
written by Ramakrishna , January 19, 2007
Hi
Anil,
after updating records in ap_bank_accounts_all table. not able to see the status monitor for this process..
...
written by Anil Passi , January 19, 2007
.
.
.
Hi Ram

I am impressed, you were quick in trying this out.
May be your subscription is in the deferred queue.
Is the phase of subscription between 1 and 99?

If so, email me your screenshots of your event/subscription definitions.

Thanks
Anil Passi
...
written by Anil Passi , January 20, 2007
Hi Agostino

Good to see that you are able to initiat Workflow.
So the hard work has been done.

In order to debug your issue, I need your XML Message. Please can you email me that.

Go to Workflow Status Monitor, and click on Workflow Details, and then click on Event Attribute hyperlink to see XML message.

Email me that XML message

Thanks,
Anil Passi
...
written by Anil Passi , January 20, 2007
Hi Agostino

Good to see that you are able to initiat Workflow.
So the hard work has been done.

In order to debug your issue, I need your XML Message. Please can you email me that.

Go to Workflow Status Monitor, and click on Workflow Details, and then click on Event Attribute hyperlink to see XML message.

Email me that XML message

Thanks,
Anil Passi
...
written by bhaskar , June 26, 2007
hi anil ,
how ru this bhaskar i have one query i have instel oracle 11.5.10.vertion in this datbase is 9i ,now i want instel workflow builder witch vertion it works , i dowenloeded 10 g server but its is asking again oracle home/ path ,
...
written by Anil Passi , July 30, 2007
Hi Bhaskar

Simply install the 10g client on your PC. That should come bundled with WF Builder version 2.6.x

This will work with 11.5.10 instance.

Thanks,
Anil Passi
You must be logged in to a comment. Please register if you do not have an account yet.

busy