Home » Applications » Oracle Fusion Apps & E-Business Suite » Concurrent Request - Backend (EBS 11.5.10.2/ Solaris)
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
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri May 02 06:32:21 CDT 2025
|