running requisition import program for mutiple operating units [message #388498] |
Wed, 25 February 2009 00:54 |
manumagic
Messages: 1 Registered: February 2009
|
Junior Member |
|
|
Hi All,
I need to run requisition import for mutilple operating units.
when i tried submitting using fnd_request.submit_request it is getting submitted but its not picking any records from the interface table.
declare
l_req_id fnd_concurrent_requests.request_id%TYPE;
begin
fnd_global.apps_initialize(1531,50597,201);
fnd_request.set_org_id(121);
l_req_id := 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;
Is there anything i need to do to pick the records from the interface table....
|
|
|