FND_REQUEST API behavior after upgrade to R12.1.1
- a PL/SQL stored procedure runs and calls the Oracle API fnd_request.submit_request - this API is configured to call a UNIX shell script which does some work, then transfers control back to the original custom procedure
- in Oracle R12.0.6, this process ran very smoothly; after the weekend we upgraded to R12.1.1, it stopped working - the fnd_request API does not make the call to the UNIX shell script, and instead returns a Request ID of zero (it should submit a concurrent request, but it does not)