In one of our custom module, I am facing one issue with the fnd_concurrent.wait_for_request. I am calling one custom function through the ‘Workflow Background Process’. This function is submitting a concurrent program using fnd_request.submit_request which in turn submitting two other concurrent programs in the same way. Now all jobs are completing successfully but it is not working as expected.
I am calling fnd_concurrent.wait_for_request in the custom function after submitting the concurrent program with a maximum wait of 200 seconds. But the phase and status returning is RUNNING and NORMAL respectively even if it has completed successfully. I am raising the exception when phase and status not equal to COMPLETED and NORMAL respectively and it is getting into that exception which won't happen idealy. I have even tried to pass maximum wait as 0, at that time the first program is running for a long time and not even completing.
Can anyone help me resolving this issue.
Thanks in advance.
Charls K V