Submit concurrent program from backend in Oracle Apps

Hi friends, we are going to discuss about how to Submit the concurrent program from Backend in Oracle Apps. We will share the detail steps and the complete plsql source code to Submit concurrent program from Backend in Oracle Apps. In oracle apps , We do submit or run the concurrent program as a concurrent request in oracle apps. To submit the concurrent program request we need to goto the concurrent requests page. In this page , we can see all the running and submitted concurrent program requests and do submit the new concurrent program requests also. We have another option to submit the concurrent program and that option is backend. Oracle apps has provided the standard api to submit the concurrent program from backend. In Interfaces and integration program , we must need this feature to submit the concurrent program from backend. In this post , We will share the complete plsql source code to call or submit the concurrent program from Backend in Oracle Apps. Please find below the complete detail about Submit concurrent program from Backend in Oracle Apps.

Submit concurrent program from backend in Oracle Apps

Standard API to Submit concurrent program from backend in Oracle Apps

1. fnd_request.submit_request

3 required things to Submit concurrent program from backend in Oracle Apps

1. Short Application Name under which the Concurrent Program registered .

2.Concurrent Program short code name which we want to call from pl/sql.

3.Needs to know the Concurrent Program Parameters , which we also needs to pass while calling the concurrent program from pl/sql package.

Sample PLSQL source code to Submit concurrent program from backend in Oracle Apps

Here below , is the detail plsql source code to Submit concurrent program from backend in Oracle Apps. Please use this code to submit the concurrent program request from oracle backend.

DECLARE

v_con_req_id            NUMBER;

v_resp_id  NUMBER;

v_appl_id     NUMBER;

v_usr_id             NUMBER;

BEGIN

--Here we are providing the sample code to Submit concurrent program from backend in Oracle Apps--

SELECT user_id INTO v_usr_id  

   FROM fnd_user WHERE user_name = 'xx_running_user';

   

  SELECT DISTINCT fr.responsibility_id,

    frx.application_id

     INTO v_resp_id,

    v_appl_id

     FROM apps.fnd_responsibility frx,

    apps.fnd_responsibility_tl fr

    WHERE fr.responsibility_id = frx.responsibility_id

  AND LOWER (fr.responsibility_name) LIKE LOWER('XXTest Resp');

 

  

  apps.fnd_global.apps_initialize (v_usr_id ,v_resp_id,v_appl_id);

  

  -- Here below ,  we are calling the concurrent request from Oracle DB--

  

  

  v_con_req_id := fnd_request.submit_request ( 

                            application   ='XXGL', 

                            program       ='XXTEST_CON_PROG, 

                            description   ='XXTest Concurrent Program', 

                            start_time    =sysdate, 

                            sub_request   =FALSE,

    argument1     ='84','TEST' -- 2 PARAMETERS OF THIS CONCURRENT PROGRAM--

  );

 

 

  COMMIT;

  IF v_con_req_id = 0

  THEN

     dbms_output.put_line ('Concurrent Program failed to Call from plsql');

  ELSE

     dbms_output.put_line('Concurrent Program Sucessfully Call from plsql');

  END IF;

  

EXCEPTION

WHEN OTHERS THEN

  dbms_output.put_line('Error In Concurrent Program Call Main Procedure 2 '||TO_CHAR(SQLCODE)||'-'||sqlerrm);

END;

Submit concurrent program from backend in Oracle Apps

Submit concurrent program from backend in Oracle Apps