FND_REQUEST.SUBMIT_REQUEST is an API used to submit a concurrent program in ORACLE Applications.

Parameters:

Application : Short name of the application associated with the concurrent request to be submitted.

Program - Short name of the concurrent program (not the executable) for which the request should be submitted.

Description - Description of the request that is displayed in the Concurrent Requests form (Optional.)

Start_time - Time at which the request should start running, formatted as HH24:MI or HH24:MI:SS (Optional.)

Sub_request - Set to TRUE if the request is submitted from another request and should be treated as a sub-request.

Argument1...100 - Arguments for the concurrent request; up to 100 arguments are permitted. If submitted from Oracle Forms, you must specify all 100 arguments.

Example: Submission of Standard Order Import Program

SET SERVEROUTPUT ON;

DECLARE

v_request_id NUMBER DEFAULT0;

--Order Import Parameters

p_operating_unit VARCHAR2(20) :=NULL;

p_order_source VARCHAR2(20) :=\'XYZ\';

p_orig_sys_document_ref VARCHAR2(20) :=NULL;

p_operation_code VARCHAR2(20) :=NULL;

p_validate_only VARCHAR2(20) :=\'N\';

p_debug_level VARCHAR2(20) :=\'1\';

p_num_instances VARCHAR2(20) :=\'4\';

p_sold_to_org_id VARCHAR2(20) :=NULL;

p_sold_to_org VARCHAR2(20) :=NULL;

p_change_sequence VARCHAR2(20) :=NULL;

p_perf_param VARCHAR2(20) :=\'Y\';

p_rtrim_data VARCHAR2(20) :=\'N\';

p_pro_ord_with_null_flag VARCHAR2(20) :=\'Y\';

p_default_org_id VARCHAR2(20) :=\'83\';

p_validate_desc_flex VARCHAR2(20) :=\'N\';

-- End of Parameters -----

v_context varchar2(100);

FUNCTION set_context( i_user_name IN VARCHAR2

,i_resp_name IN VARCHAR2

,i_org_id IN NUMBER)

RETURNVARCHAR2

IS

/* Inorder to reduce the content of the post I moved the implementation part of this function to another post and it is available here */

END set_context;

BEGIN

-- Setting the context ----

v_context := set_context(\'&V_USER_NAME\',\'&V_RESPONSIBILITY\',82);

IF v_context =\'F\'

THEN

DBMS_OUTPUT.PUT_LINE(\'Error while setting the context\');

ENDIF;

DBMS_OUTPUT.PUT_LINE(\'Submit Order Import Concurrent Program\');

v_request_id:= FND_REQUEST.SUBMIT_REQUEST (

application => \'ONT\'

,program => \'OEOIMP\'

,description => \'Order Import\'

,start_time => SYSDATE

,sub_request => NULL

,argument1 => p_operating_unit

,argument2 => p_order_source

,argument3 => p_orig_sys_document_ref

,argument4 => p_operation_code

,argument5 => p_validate_only

,argument6 => p_debug_level

,argument7 => p_num_instances

,argument8 => p_sold_to_org_id

,argument9 => p_sold_to_org

,argument10 => p_change_sequence

,argument11 => p_perf_param

,argument12 => p_rtrim_data

,argument13 => p_pro_ord_with_null_flag

,argument14 => p_default_org_id

,argument15 => p_validate_desc_flex

);

COMMIT;

DBMS_OUTPUT.PUT_LINE(\'Request_id: \'||v_request_id);

EXCEPTIONWHENOTHERSTHEN

DBMS_OUTPUT.PUT_LINE(SQLCODE||\' Error :\'||SQLERRM);

END;

FND_REQUEST.SUBMIT_REQUEST in R12