Help in Submitting Concurrent Request..Urgent [message #312958] |
Thu, 10 April 2008 03:50 |
venkatesham
Messages: 45 Registered: April 2005 Location: Hyd
|
Member |
|
|
Hi,
I have a trigger on table, and on insert it submits a concurrent program thro FND_SUBMIT.REQUEST_SUBMIT..
whoever insert a new record(thro front-end), the request is submitted thro his/her user..(i.e. requested_by)...i want to submit the request thro sysadmin user..
is it acheivable ??
please help...
Thanks,
venkatesham
|
|
|
|
Re: Help in Submitting Concurrent Request..Urgent [message #314035 is a reply to message #312958] |
Tue, 15 April 2008 10:55 |
venkatesham
Messages: 45 Registered: April 2005 Location: Hyd
|
Member |
|
|
Hi,
Thanks for the update.it works!!
I need another help, can we restrict a request not to be visible in 'All my requests'for a particular user.
Eg.- if a scheduled prgm 'Test1' submitted every 10 mins
thro user login "A".. at EOD user will find many requests..
can we make not to show the user these requests though 'All my requests' option is used ?
Thanks,
venkatesham
|
|
|
|
Re: Help in Submitting Concurrent Request..Urgent [message #316032 is a reply to message #312958] |
Wed, 23 April 2008 09:16 |
venkatesham
Messages: 45 Registered: April 2005 Location: Hyd
|
Member |
|
|
Hi All,
got the solution.
we have option to be set before we submit the request,
FND_REQUEST.SET_OPTIONS(IMPLICIT => 'ERROR');
This is optionally called before submitting a concurrent request to set request options.
It determines whether to display this concurrent request in the end–user Concurrent Requests form.
(All requests are automatically displayed in the System Administrator’s privileged Concurrent Requests form, regardless of the value of this argument.) Specify ‘NO’, ‘YES’, ‘ERROR’, or ‘WARNING’.
Parameters Explanation:-
‘NO’ allows the request to be viewed on the end–user Concurrent Requests form.
‘YES’ means that the request may be viewed only from the System Administrator’s privileged Concurrent Requests form.
‘ERROR’ causes the request to be displayed in the end user Concurrent Requests form only if it fails.
‘WARNING’ allows the request to display in the end–user Concurrent Requests form only if it completes with a warning or an error.
Thank you,
Venkatesham
|
|
|