| 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.... 
		
		
		
 |  
	| 
		
	 | 
 
 
 |