Gurujothi wrote:It is possible, just prior providing you the "solution", would like to know on which form you are going to add this "print report" button
I am working on Oracle forms 10g and Oracle Applications : 12.1.2,
already I have created one concurrent program(GRN Report) and which taking Receipt_number and org_id as parameters and its output format is .PDF .Its working fine.
Whenever the clients need the report they have to give correct concurrent program name then parameter values then refreshing and then by clicking the View Output button they are seeing the output.
Now what I want is from the form button (Named as Print Report) is it possible to call this concurrent program and when the button is clicked it has to be prompted for parameter values after giving all parameter values and by clicking SUBMIT/OK button it has to give the same output(.pdf) as like concurrent program.
can anyone tell me how to get this.
Here where I have to mention for PDF output.
Declare l_ord_num NUMBER := 0; l_ord_type_name VARCHAR2 (240); l_req_id_Rep NUMBER; l_request_completed BOOLEAN := FALSE; l_req_phase VARCHAR2 (20); l_req_status VARCHAR2 (1000); l_req_dev_phase VARCHAR2 (1000); l_req_dev_status VARCHAR2 (1000); l_req_message VARCHAR2 (1000); l_conc_mgr_status NUMBER; p_call_stat NUMBER; p_activep_stat NUMBER; l_order_category_code NUMBER; l_inv_report_name VARCHAR2 (40):='XXRS_GRN_REPORT_VAT'; l_ret_report_name VARCHAR2 (40); l_req_id NUMBER; l_order_type_name VARCHAR2(30); Begin l_req_id := fnd_request.submit_request ('XXRS', l_inv_report_name, NULL, SYSDATE, FALSE, /*You can pass a total of 100 parameters, just make sure to pass them in the same order you have defined them in the parameter session for the concurrent program*/ :GRN_PARAMETER.BUSINESS_UNITS,:GRN_PARAMETER.GRN_NUMBER, NULL, NULL --apps.fnd_profile.VALUE ('ORG_ID') ); :SYSTEM.Message_Level := '25'; COMMIT; l_request_completed := fnd_concurrent.wait_for_request (request_id => l_req_id, INTERVAL => 1, phase => l_req_phase, status => l_req_status, dev_phase => l_req_dev_phase, dev_status => l_req_dev_status, MESSAGE => l_req_message); :SYSTEM.Message_Level := '25'; COMMIT; :SYSTEM.Message_Level := '0'; editor_pkg.report (l_req_id, 'Y'); /*for displaying the pdf automatically with a new window or tab after the concurrent request completes successfully*/ END;
its working fine.
Xxnh_Submit_Conc_Request_Pkg.p_submit_request( p_application => 'XXRS', p_program => 'XXRS_GRN_REPORT_VAT', p_lang => 'US', p_xml => 'Y', p_temp_code => 'XXRS_GRN_REPORT_VAT', p_arg1 => :GRN_PARAMETER.BUSINESS_UNITS, p_arg2 => :GRN_PARAMETER.GRN_NUMBER, p_arg3 => NULL, p_arg4 =>Null);