FND_CONCURRENT.WAIT_FOR_REQUEST [message #343434] |
Wed, 27 August 2008 05:11 |
spmano1983
Messages: 269 Registered: September 2007
|
Senior Member |
|
|
Hi,
I am using the following codes. I am submitting one reprt first.
after that i am calling FND_CONCURRENT.WAIT_FOR_REQUEST to sleep.
But the second request is called before first request completed.
I need that, first request should completed, then only the request request should start. How can i achieve this?? any ideas?? Please find the code below which i am using...
L_REQ_ID := FND_REQUEST.SUBMIT_REQUEST
('GECA',
'XX_CWB_IND_LETTER
'',
'',
FALSE,
OHR_LOOP.OHRID,
P_FROM_DATE,
P_TO_DATE
);
IF FND_CONCURRENT.WAIT_FOR_REQUEST(
REQUEST_ID=>L_REQ_ID,
INTERVAL=>60,
MAX_WAIT=>0,
PHASE =>L_PHASE,
STATUS=>L_STATUS,
DEV_PHASE=>L_DEV_PHASE,
DEV_STATUS=>L_DEV_STATUS,
MESSAGE=>L_MESSAGE ) THEN
L_REQ_ID1 := FND_REQUEST.SUBMIT_REQUEST(
'GECA',
'XX_CWB_IND_EFMS_INTER_CONC',
'',
'',
FALSE,
L_XML_FILE,
L_XML_DEST,
L_PDF_FILE,
L_PDF_DEST
);
Thanks
|
|
|
|
|
|
Re: FND_CONCURRENT.WAIT_FOR_REQUEST [message #346052 is a reply to message #343773] |
Fri, 05 September 2008 14:11 |
annagel
Messages: 220 Registered: April 2006
|
Senior Member |
|
|
spmano1983 wrote on Thu, 28 August 2008 02:07 | But can you tell me why the COMMIT is necessary here??
|
COMMIT is required after submitting a request because all the SUBMIT_REQUEST procedure is doing is inserting data into the relevant tables. Just like any other data insert, until a COMMIT is issued that data is only visible from your session. As a result the concurrent manager which is actually responsible for running the job is not able to see it and does not start it.
|
|
|