Oracle Form/PLSQL submit concurrent requests in Form or PLSQL

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.