Troubleshooting tips for executing demantra workflow from a request set

Hi,

We are testing running a workflow in demantra from apps user using a request set. The request set fails at the stage that triggers the demantra workflow.

But when the concurrent request that triggers the demantra workflow is executed independently, the request completes successfully executing the demantra workflow. After this when the request set is run as a wholeagain, it too completes successfully. I checked the demantra application server was up and working all the time when the request set was running.

SELECT utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema='|| replace(l_schema_name, ' ', '%20') ||'&sync=no'') FROM dual;