I recently put together a Concurrent Request that queried the database and used the result to create a number of folders named after the customers in the database. This concurrent routine was called from within Oracle Reports Builder in the after_report event. It needed to be called before the FTP Burst concurrent routine so I have to use the fnd_request.wait_for_request command. However it did not seem to wait for me and which had not been mentioned anywhere I checked on the web.

This thing I missed was the commit statement. It needs to be run after your submit_request and before the wait_for_request. See below

l_reqid := fnd_request.submit_request
(application =>
,program => 'XX...' -- child prg short name
,description => ''
,start_time => SYSDATE
,sub_request => TRUE
,argument1 => xx.xx1 -- child prg arguments
);

fnd_request.wait_for_request ...