alamo 3alekom

i am tring to run concurrent program from pl/sql using following code but i get zero
can anyone help me to know what is the issue
i run it from test schema not from apps and i grant to test to excute fnd_request

declare
l_req_id apps.fnd_concurrent_requests.request_id%TYPE;
begin

l_req_id := apps.fnd_request.submit_request
(application => 'PO',
program => 'REQIMPORT',
description => 'Requisition Import',
start_time => NULL,
sub_request => FALSE,
argument1 => 'Oracle',
argument2 => NULL,
argument3 => 'ALL',
argument4 => NULL,
argument5 => 'N',
argument6 => 'N'
);
commit;
dbms_output.put_line(l_req_id);
end

1. Call fnd_global.initialize ensuring you pass it two parameters in bold below

declare
...your variables here
v_session_id INTEGER := userenv('sessionid');
v_trace VARCHAR2(2000) := fnd_trace.get_trace_filename;
n_conc_request_id INTEGER ;
begin
//optionally trace the API Call with bind variable values
execute immediate 'alter session set events=''10046 trace name context forever, level 12''' ;
//the trace file details will be in variable v_trace

//Now call fnd_global.initialize ensuring you pass it two parameters in bold below

fnd_global.initialize
(
session_id => v_session_id
,user_id => 18594 //or pass the current fnd_global.user_id itself
,resp_id => 4650126 //or pass the current fnd_global.resp_id itself
,resp_appl_id => 8405 //or pass the current fnd_global.resp_appl_id itself
,security_group_id => 0
,site_id => NULL
,login_id => 3115003
,conc_login_id => NULL
,prog_appl_id => NULL
,conc_program_id => 229233 //The program id of concurrent request
,conc_request_id => n_conc_request_id //From fnd_concurrent_requests_s.nextval
,conc_priority_request => NULL
);
//Lets assume the nextval from sequence is 14633154
//now call the API, i have arbitrarily typed in just any API
ar_process_trx.place_hold( v_errbuf, v_retcode, v_trx_id ) ;
end ;

2. Run the SQL on fnd_temp_files, as in attachment, using the fictional request_id generated from sequence [ in variable n_conc_request_id ]

3. In order to read those files, ensure that the directory [/usr/tmp in this case] is listed in v$parameter utl_file_dir