This discussion is archived
3 Replies Latest reply: Sep 13, 2012 11:34 AM by Srini Chavali-Oracle RSS

FND_REQUEST.WAIT_FOR_REQUEST waits forever over dblink

Sankar. Explorer
Currently Being Moderated
Hi,

I have a strange problem.
As part of Standard Collections, we are launching custom concurrent requests on the Source side (via dblinks) using FND_REQUEST.SUBMIT_REQUEST.
Then the FND_REQUEST.WAIT_FOR_REQUEST is called, to check for the completion of these requests.

The requests are spawned successfully and they complete successfully on Source Side, but the FND_REQUEST.WAIT_FOR_REQUEST on the Planning Side, waits forever over dblink, for the program on the Source side to complete. I am not sure why it is not able to see that the program has completed.
The same program is working fine in another instance, whereas it is not working in one instance. I am at my wits end.
Any pointers will be realllyyyyyy helpful please.

regards,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points