Apps To Fusion

...
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 MR , May 12, 2008

Hi
Though Event is raised , the bank_acc_changed_payload is not getting populated with userid , bank number .
it seems as though the l_event_data is getting only event name and event key
MR

...
written by khan , February 02, 2010

Hi Anil,
I have followed all the steps implementing payload. when i try to update the bank_account table the trigger fires and raises the event but after that nothing and also when i try to search for my workflow in status monitor screen i can not see anything under that.
I have doubt in the procedure, can please explain the procedure you have created by the name of (xx_get_bank_account_number).
Thanks & Regards,
khan

...
written by MAHESWARACHARI KOTTAPALLI , December 03, 2010

I faced the same problem as most of you did. XML payload was not received by the XX_RECEIVE_EVENT. Thats why the next function in the workflow could not parse the bank account number.

The solution to this is we need to pass a dummy parameter like this..

l_parameter_list := WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();

-- Then add a dummy parameter

wf_event.addparametertolist ( p_name => 'FIRST_PARAMETER'
,p_value => 'FIRST PARAMETER VALUE'
,p_parameterlist => l_parameter_list
);
-- Pass this parameter list while raising the event along with xmlpayload

wf_event.RAISE ( p_event_name => l_event_name
,p_event_key => l_event_key
,p_event_data => l_event_data
,p_parameters => l_parameter_list --- This point has been missing from the above exampl

Thanks,
Mahesh.K
);