Questions:
How To Register A Concurrent Program From Back End?
How To Create A Concurrent Program from Back End?
How To Create An Executable from Back End?
How to Attach Concurrent program to a Request Group from back end?
How To Submit A Concurrent Program from back end?
Script To register a concurrent program.
Script to create a concurrent program.
Script to create an Executables.
script to Attach concurrent program to a request Group.
Script To submit a concurrent program.
Answer:
The PL/SQL and SQL scripts in this article can be used to:
1) Register the executable
2) Register the Concurrent 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 as well.
Following is the PL/SQL code to create an executable from back-end.
BEGIN
FND_PROGRAM.executable('XXAB_ERPSCHOOLS_EMPLOYEE' -- executable
, 'XXAB Custom' -- application
, 'XXAB_ERPSCHOOLS_EMPLOYEE' -- short_name
, 'Executable for ERPSCHOOLS Employee INFORMATION' -- description
, 'PL/SQL Stored Procedure' -- execution_method
, 'XXAB_ERPSCHOOLS_EMPLOYEE' -- execution_file_name
, '' -- subroutine_name
, '' -- Execution File Path
, 'US' -- language_code
, '');
COMMIT;
END;
You can Query in the front-end to verify whether your executable is created or not.
2) Registering the Concurrent program from back end
Usually we create Concurrent program in the front-end, but this can be done from the back end as well.
Following is the PL/SQl script to create a Concurrent program from back-end.
BEGIN
FND_PROGRAM.register('Concurrent program for ErpSchools Employee Information' -- program
, 'XXAB Custom' -- application
, 'Y' -- enabled
, 'XXMZ_ERPSCHOOLS_EMPLOYEE' -- short_name
, 'ErpSchools Employee Information' -- description
, 'XXMZ_ERPSCHOOLS_EMPLOYEE' -- executable_short_name
, 'XXAB Custom' -- executable_application
, '' -- execution_options
, '' -- priority
, 'Y' -- save_output
, 'Y' -- print
, '' -- cols
, '' -- rows
, '' -- style
, 'N' -- style_required
, '' -- printer
, '' -- request_type
, '' -- request_type_application
, 'Y' -- use_in_srs
, 'N' -- allow_disabled_values
, 'N' -- run_alone
, 'TEXT' – output_type
, 'N' -- enable_trace
, 'Y' -- restart
, 'Y' -- nls_compliant
, '' -- icon_name
, 'US'); -- language_code
COMMIT;
END;
You can Query in the front-end to verify whether your Concurrent program is created or not.
3) Attaching the concurrent program to the request group
Following is the PL/SQL script to Attach Concurrent program to the request group from back-end.
BEGIN
FND_PROGRAM.add_to_group('XXMZ_ERPSCHOOLS_EMPLOYEE' -- program_short_name
, 'XXAB Custom' -- application
, 'xxab Request Group' -- Report Group Name
, 'XXAB'); -- Report Group Application
COMMIT;
END;
You can Query in the front-end to verify whether your Concurrent program is Attached to Request Group or not.
4) Submitting Concurrent Program from Back-end
We first need to initialize oracle applications session using
fnd_global.apps_initialize(user_id,responsibility_id,application_responsibility_id) and then run fnd_request.submit_request
DECLARE
l_request_id NUMBER(30);
begin
FND_GLOBAL.APPS_INITIALIZE (user_id => 1318, resp_id => 12345, resp_appl_id => 20064);
l_request_id:= FND_REQUEST.SUBMIT_REQUEST ('XX' --Application Short name,'VENDOR_FORM'-- Concurrent Program Short Name );
DBMS_OUTPUT.PUT_LINE(l_request_id);
commit;
end;
*****************************************************
To get the resp_id and resp_appl_id and user id use this script.
*****************************************************
Once the concurrent program is submitted from back-end, status of the concurrent program can be checked using below query.
SELECT * FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID=1234567
Other Most Usefull PLSQL Scripts:
- PL/SQL Procedure For Counting All Tables And Respective Rows From Database
- PL/SQL Procedure To Display Monthly Calender
- PL/SQL Procedure To Reverse A String
- PL/SQL Script To Calculate Weekdays Between Two Given Dates
- PL/SQL Script To Change/Reset The Oracle Applications Password From Back End
- PL/SQL Script To Create A User In Oracle Applications
- PL/SQL Script To Remove End Date From Responsibilities Assigned To A User
- PL/SQL Script/Program To Print The Fibonacci Series
- PLSQL Script To UPDATE Oracle FND User
COMMENTS