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
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<\/p>\n
FND_PROGRAM.executable(’XXMZ_ERPSCHOOLS_EMPLOYEE’ — executable<\/p>\n
, 'XXMZ Custom’ — application<\/p>\n
, 'XXMZ_ERPSCHOOLS_EMPLOYEE’ — short_name<\/p>\n
, 'Executable for ERPSCHOOLS Employee INFORMATION’ — description<\/p>\n
, 'PL\/SQL Stored Procedure’ — execution_method<\/p>\n
, 'XXMZ_ERPSCHOOLS_EMPLOYEE’ — execution_file_name<\/p>\n
, ” — subroutine_name<\/p>\n
, ” — Execution File Path<\/p>\n
, 'US’ — language_code<\/p>\n
, ”);<\/p>\n
COMMIT;<\/p>\n
END;
\nQuery in the front-end to see whether your executable is created or not.<\/p>\n
Usually we create Concurrent program in the front-end, but this can be done from the database tier too.
\nBelow is the program to create a Concurrent program from back-end.<\/p>\n
BEGIN<\/p>\n
FND_PROGRAM.register(’Concurrent program for ErpSchools Employee Information’ — program<\/p>\n
, 'XXMZ Custom’ — application<\/p>\n
, 'Y’ — enabled<\/p>\n
, 'XXMZ_ERPSCHOOLS_EMPLOYEE’ — short_name<\/p>\n
, 'ErpSchools Employee Information’ — description<\/p>\n
, 'XXMZ_ERPSCHOOLS_EMPLOYEE’ — executable_short_name<\/p>\n
, 'XXMZ Custom’ — executable_application<\/p>\n
, ” — execution_options<\/p>\n
, ” — priority<\/p>\n
, 'Y’ — save_output<\/p>\n
, 'Y’ — print<\/p>\n
, ” — cols<\/p>\n
, ” — rows<\/p>\n
, ” — style<\/p>\n
, 'N’ — style_required<\/p>\n
, ” — printer<\/p>\n
, ” — request_type<\/p>\n
, ” — request_type_application<\/p>\n
, 'Y’ — use_in_srs<\/p>\n
, 'N’ — allow_disabled_values<\/p>\n
, 'N’ — run_alone<\/p>\n
, 'TEXT’ \u00e2\u20ac\u201c output_type<\/p>\n
, 'N’ — enable_trace<\/p>\n
, 'Y’ — restart<\/p>\n
, 'Y’ — nls_compliant<\/p>\n
, ” — icon_name<\/p>\n
, 'US’); — language_code<\/p>\n
COMMIT;<\/p>\n
END;
\nQuery in the front-end to see whether your Concurrent program is created or not.<\/p>\n
Usually we Attach Concurrent program to the request group in the front-end, but this can be done from database tier too.
\nBelow is the program to Attach Concurrent program to the request group from back-end.<\/p>\n
BEGIN\r\n\r\n FND_PROGRAM.add_to_group('XXMZ_ERPSCHOOLS_EMPLOYEE' -- program_short_name\r\n\r\n , 'XXMZ Custom' -- application\r\n\r\n , 'xxmz Request Group' -- Report Group Name\r\n\r\n , 'XXMZ'); -- Report Group Application\r\n\r\n COMMIT;\r\n\r\n END; <\/pre>\nQuery in the front-end to see whether your Concurrent program is Attached to Request Group or not.<\/p>\n
4) Submitting Concurrent Program from Back-end<\/h2>\n
We first need to initialize oracle applications session using<\/p>\n
fnd_global.apps_initialize(user_id,responsibility_id,application_responsibility_id) and then run fnd_request.submit_request<\/p>\n
DECLARE<\/p>\n
l_request_id NUMBER(30);<\/p>\n
begin<\/p>\n
FND_GLOBAL.APPS_INITIALIZE (user_id => 1318, resp_id => 59966, resp_appl_id => 20064);<\/p>\n
l_request_id:= FND_REQUEST.SUBMIT_REQUEST (’XXMZ’ –Application Short name,<\/p>\n
'VENDOR_FORM’– Concurrent Program Short Name );<\/p>\n
DBMS_OUTPUT.PUT_LINE(l_request_id);<\/p>\n
commit;<\/p>\n
end;<\/p>\n
*****************************************************<\/p>\n
To get the resp_id and resp_appl_id use the below queries.<\/p>\n
–SELECT APPLICATION_ID, RESPONSIBILITY_ID<\/p>\n
FROM FND_RESPONSIBILITY_TL<\/p>\n
WHERE RESPONSIBILITY_NAME=’xxmz Custom’<\/p>\n
–SELECT USER_ID FROM FND_USER WHERE USER_NAME=’OPERATIONS’<\/p>\n
*****************************************************
\nOnce the concurrent program is submitted from back-end, status of the concurrent program can be checked using below query.
\nSELECT * FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID=2766602<\/span><\/span><\/p>\n\u0179r\u00f3d\u0142o<\/p>\n