Need your help.
Create a custom workflow SAMPRREQ. Its having following processes.
1. Start Process
2. Respond Notification.
3. Function to update Table with the responded value.
4. End process.
After lauching the workflow, Notification send to the performer. Open the notification. When approver click the any of the result value (approve, reject, onhold) system giving followign message.
3101: Status row for item 'SAMPRREQ/20130206161924', activity ID '242956' does not exist.
I have seen some threads in the forums and bounce the database , purge the item type completly. But, still getting the error.
When i run the wfstat nothing wrong in the info. unable to find the issue.
But, i have narrow down the issue. In the function process in my workfow i am calling a custom function called update_approval_status_new.
In this the value of the respond notification to be updated to a header table of this workflow and insert into events tables.
When i comment these two dml ( update to header status & insert into events ) there is no error.
Can any one tells me can i update and insert custom tables in workflow or not. If I want to do this, what is procedure.
What you describe is something that can be done in a post-notification activity (a PLSQL function associated to the notification activity) so that in it you do any processing after the notification is responded. Should I assume this is what you are doing? If not sure please check the WF Dev guide regarding post-notification activities. Or provide more details on how you are doing that.