Many Oracle EBS developers have encountered how to submit a concurrent request in Form or PLSQL?
It is actually relatively simple. For more information, see PLSQL.
Declare V_req_id Number; Begin Fnd_global.apps_initialize (4394,505 93, 660, 0 ); Dbms_output.enable (1000000 ); V_req_id: = fnd_request.submit_request ('asn ', 'Xyg _ INV_OUTSOURCING_BALANCE ', Null, Null, False, '123', 'cbc-cp', '2017-06-14 ', '2017-06-14', 'A', NULL ); If v_req_id> 0 then Dbms_output.put_line ('request submitted '); Else Dbms_output.put_line ('request Submitted error '); End if;
/* V_req_id: = fnd_request.submit_request ('inv ', 'Incctcm ', '', To_char (SYSDATE, 'Yyyy/MM/DD HH24: MI: ss '), FALSE, Chr (0 ));*/ COMMIT; Dbms_output.put_line (v_req_id ); End; |
Next, we will give a brief introduction to the above instance parameters:
1. fnd_global.apps_initialize (4394,505 93, 660, 0); initialize the application environment,
Procedure initialize _initialize (
User_id in number,
Resp_id in number,
Resp_appl_id in number,
Security_group_id in number default 0,
Server_id in number default-1 );
User_id: The Oracle EBS user ID;
Resp_id: Is the responsibility ID
Resp_appl_id: ID of the application.
2. In the fnd_request.submit_request parameter:
INV is short for concurrent applications.
NCTCM stands for the concurrency
The following two parameters are empty.
The following parameters correspond to the parameters registered by the concurrent program one by one.
Note: The above can be called in PLSQL. to be called in Form, do not initialize the application environment. The parameters in fnd_request.submit_request must be supplemented with null values after the parameters of the concurrent program are input.