Concurrent Request - Backend [message #477873] |
Tue, 05 October 2010 00:59 |
jesuisantony
Messages: 166 Registered: July 2006 Location: Chennai
|
Senior Member |
|
|
Hi All,
I have a requirement to execute concurrent requests on a daily basis. Hence I have decided to automate it using PL/SQL. The below given code was taken from metalink, and I have modified it as per my needs. When I execute the code, the out is Quote:
PL/SQL procedure successfully completed. .
But I am unable to view the concurrent request displayed either in the front end or backend. Can someone help me on this?
DECLARE
v_request_id varchar2(100);
begin
FND_GLOBAL.APPS_INITIALIZE(0,20420,0);
v_request_id := FND_REQUEST.SUBMIT_REQUEST (application => 'Application Object Library',
program => 'Workflow Directory Services User/Role Validation',
description => NULL,
start_time => NULL,-- To start immediately
sub_request => FALSE,
argument1 => '1000',
argument2 => 'Yes',
argument3 => 'Yes',
argument4 => '',
argument5 => '',
argument6 => '',
argument7 => '',
argument8 => '',
argument9 => '',
argument10 => '',
argument11 => '',
argument12 => '',
argument13 => '',
argument14 => '',
argument15 => '',
argument16 => '',
argument17 => '',
argument18 => '',
argument19 => '',
argument20 => '',
argument21 => '',
argument22 => '',
argument23 => '',
argument24 => '',
argument25 => '',
argument26 => '',
argument27 => '',
argument28 => '',
argument29 => '',
argument30 => ''
);
dbms_output.put_line('Request submitted. ID = ' || v_request_id);
commit ;
exception
when others then
dbms_output.put_line('Request set submission failed - unknown error: ' ||
sqlerrm);
END;
/
Regards,
Antony
|
|
|
|
|
Re: Concurrent Request - Backend [message #478085 is a reply to message #477923] |
Wed, 06 October 2010 02:22 |
jesuisantony
Messages: 166 Registered: July 2006 Location: Chennai
|
Senior Member |
|
|
Thanks for the input. After providing the short names, I was able to view the record when I press F9 in toad. But if I issue F5, the records are not visible. Also, the records are not visible in the front end. What could be the issue?
|
|
|
|
Re: Concurrent Request - Backend [message #478087 is a reply to message #478085] |
Wed, 06 October 2010 02:38 |
eric62
Messages: 24 Registered: January 2009
|
Junior Member |
|
|
Hello.
I don't use Toad -> I don't know F5.
I see :
FND_GLOBAL.APPS_INITIALIZE(User_Id => 0,....).
Do you connected as user_id 0 (SYSADMIN).
Othervise you see all users' requests under responsibility "System Administrator" (Menu: Concurrent -> Requests).
Regard,
Eric.
|
|
|
|
|
|
Re: Concurrent Request - Backend [message #478141 is a reply to message #478096] |
Wed, 06 October 2010 09:43 |
|
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
But you have the commit in the code, which you have posted.
SRS -> Standard Request Submission
Anyway, as you are refreshing everyday, you want to run the PL/SQL. Fine....
By
Vamsi
|
|
|