Search This Blog

How to run concurrent request manually from code in oracle apps

Here is a sample code, we can run the concurrent request manually from code / PL/SQL.


 declare
  l_resp_id number;
  l_appl_id number;
    g_user_id number;
    --l_return varchar2(2000);
    l_request_id NUMBER;
 begin

--to create a session 

    execute immediate 'alter session set NLS_LANGUAGE = ''AMERICAN''';
    execute immediate 'alter session set NLS_TERRITORY = ''UNITED ARAB EMIRATES''';
     
      if g_user_id is null then
       select user_id
       into g_user_id
       from fnd_user
       where user_name = 'XXABC';
      
       select responsibility_id, application_id
       into l_resp_id, l_appl_id
       from apps.fnd_responsibility
       where responsibility_key = 'XX_MFG_ALL';
     
       fnd_global.apps_initialize(
       user_id => g_user_id,
       resp_id => l_resp_id,
       resp_appl_id => l_appl_id);
      
       --need to set policy context if blow line is uncommedet
       mo_global.init('ONT');
      end if;

   -- Run the concurrent request

      l_request_id := fnd_request.submit_request('PO', 'RVCTP', argument1 => 'BATCH');

    dbms_output.put_line('Request id= '||l_request_id);

  end;