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.
OS is Linux. Database is 11g and Destination is R12.1.3 with Source 11.5.10.
Even in the instance where we are facing this issue now, it was working for the past 2 months.
I dont know what went wrong here and I am not sure where to start looking.
There is no difference in the architecture or invocation methods. The are all similar.
I know I am not being of much help here, but that is why I am getting confused where to start looking or how to start troubleshoot this.