The scripts in this article can be used to:
\n1) Register the executable and Program
\n2) Attach Concurrent program to a Request Group
\n3) Submit Concurrent program<\/p>\n
1) Registering the Executable from back end<\/p>\n
Usually we create executable in the front-end, but this can be done from the database tier i.e. back-end too.
\nBelow is the PL\/SQL code to create an executable from back-end.<\/p>\n
BEGIN Query in the front-end to see whether your executable is created or not.<\/p>\n 2) Registering the Concurrent program from back end<\/p>\n Usually we create Concurrent program in the front-end, but this can be done from the database tier too. COMMIT; Query in the front-end to see whether your Concurrent program is created or not.<\/p>\n Attaching the concurrent program to the request group<\/p>\n Usually we Attach Concurrent program to the request group in the front-end, but this can be done from database tier too. BEGIN Query in the front-end to see whether your Concurrent program is Attached to Request Group or not.<\/p>\n Submitting Concurrent Program from Back-end<\/p>\n We first need to initialize oracle applications session using l_request_id:= FND_REQUEST.SUBMIT_REQUEST ('XXMZ' --Application Short name, commit; To get the resp_id and resp_appl_id use the below queries.<\/p>\n Once the concurrent program is submitted from back-end, status of the concurrent program can be checked using below query. The scripts in this article can be used to: 1) Register the executable and Program 2) Attach Concurrent program to a Request Group 3) Submit Concurrent program 1) Registering the Executable from back end Usually we create executable in the front-end, but this can be done from the database tier i.e. back-end too. Below is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1856","post","type-post","status-publish","format-standard","hentry","category-scripts"],"yoast_head":"\n <\/p>\n
\n FND_PROGRAM.executable('XXMZ_ERPSCHOOLS_EMPLOYEE' -- executable
\n , 'XXMZ Custom' -- application
\n , 'XXMZ_ERPSCHOOLS_EMPLOYEE' -- short_name
\n , 'Executable for ERPSCHOOLS Employee INFORMATION' -- description
\n , 'PL\/SQL Stored Procedure' -- execution_method
\n , 'XXMZ_ERPSCHOOLS_EMPLOYEE' -- execution_file_name
\n , '' -- subroutine_name
\n , '' -- Execution File Path
\n , 'US' -- language_code
\n , '');
\n COMMIT;
\n END;<\/code><\/p>\n
\nBelow is the program to create a Concurrent program from back-end.<\/p>\n
\n BEGIN
\n FND_PROGRAM.register('Concurrent program for ErpSchools Employee Information' -- program
\n , 'XXMZ Custom' -- application
\n , 'Y' -- enable
\n , 'XXMZ_ERPSCHOOLS_EMPLOYEE' -- short_name
\n , 'ErpSchools Employee Information' -- description
\n , 'XXMZ_ERPSCHOOLS_EMPLOYEE' -- executable_short_name
\n , 'XXMZ Custom' -- executable_application
\n , '' -- execution_options
\n , '' -- priority
\n , 'Y' -- save_output
\n , 'Y' -- print
\n , '' -- cols
\n , '' -- rows
\n , '' -- style
\n , 'N' -- style_required
\n , '' -- printer
\n , '' -- request_type
\n , '' -- request_type_application
\n , 'Y' -- use_in_srs
\n , 'N' -- allow_disabled_values
\n , 'N' -- run_alone
\n , 'TEXT' \u2013 output_type
\n , 'N' -- enable_trace
\n , 'Y' -- restart
\n , 'Y' -- nls_compliant
\n , '' -- icon_name
\n , 'US'); -- language_code<\/p>\n
\n END;<\/code><\/p>\n
\nBelow is the program to Attach Concurrent program to the request group from back-end.<\/p>\n <\/p>\n
\n FND_PROGRAM.add_to_group('XXMZ_ERPSCHOOLS_EMPLOYEE' -- program_short_name
\n , 'XXMZ Custom' -- application
\n , 'xxmz Request Group' -- Report Group Name
\n , 'XXMZ'); -- Report Group Application
\n COMMIT;
\nEND;
\n<\/code><\/p>\n
\nfnd_global.apps_initialize(user_id,responsibility_id,application_responsibility_id) and then run fnd_request.submit_request<\/p>\n
\nDECLARE
\n l_request_id NUMBER(30);
\n begin
\n FND_GLOBAL.APPS_INITIALIZE (user_id => 1318, resp_id => 59966, resp_appl_id => 20064); <\/p>\n
\n 'VENDOR_FORM'-- Concurrent Program Short Name );
\n DBMS_OUTPUT.PUT_LINE(l_request_id); <\/p>\n
\n end;
\n<\/code><\/p>\n
\n SELECT APPLICATION_ID, RESPONSIBILITY_ID
\n FROM FND_RESPONSIBILITY_TL
\n WHERE RESPONSIBILITY_NAME='xxmz Custom';
\n<\/code><\/p>\n SELECT USER_ID FROM FND_USER WHERE USER_NAME='OPERATIONS'<\/code><\/p>\n
\n SELECT * FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID=2766602 <\/code><\/p>\n","protected":false},"excerpt":{"rendered":"