Calling a PL/SQL Concurrent Program in Real-Time
Lets say there is an Oracle Delivered concurrent program of type PL/SQL.
Your requirement is such that you wish to call that PL/SQL Executable [attached to concurrent program] directly from some other process, in real-time mode, in the same session as that of the parent Oracle session[forms or report or some other plsql ]. In order to call that pl/sql program within the same session, your challenge may be that the concurrent program could be writing into log/output file using fnd_file API which you want to display to the user somehow.
To get a handle to the log/output of the API [which is executable of Conc Program], we need to do the following:-
1. Call fnd_global.initialize ensuring you pass it two parameters in bold below
declare
...your variables here
v_session_id INTEGER := userenv('sessionid');
v_trace VARCHAR2(2000) := fnd_trace.get_trace_filename;
n_conc_request_id INTEGER ;
begin
//optionally trace the API Call with bind variable values
execute immediate 'alter session set events=''10046 trace name context forever, level 12''' ;
//the trace file details will be in variable v_trace
//Now call fnd_global.initialize ensuring you pass it two parameters in bold below
fnd_global.initialize
(
session_id => v_session_id
,user_id => 18594 //or pass the current fnd_global.user_id itself
,resp_id => 4650126 //or pass the current fnd_global.resp_id itself
,resp_appl_id => 8405 //or pass the current fnd_global.resp_appl_id itself
,security_group_id => 0
,site_id => NULL
,login_id => 3115003
,conc_login_id => NULL
,prog_appl_id => NULL
,conc_program_id => 229233 //The program id of concurrent request
,conc_request_id => n_conc_request_id //From fnd_concurrent_requests_s.nextval
,conc_priority_request => NULL
);
//Lets assume the nextval from sequence is 14633154
//now call the API, i have arbitrarily typed in just any API
ar_process_trx.place_hold( v_errbuf, v_retcode, v_trx_id ) ;
end ;
2. Run the SQL on fnd_temp_files, as below, using the fictional request_id generated from sequence [ in variable n_conc_request_id ]
3. In order to read those files, ensure that the directory [/usr/tmp in this case] is listed in v$parameter utl_file_dir
In this approach, no change is made to the Original concurrent program. Hence, if need be, users can continue to run the concurrent process as usual from SRS.
Trace file with bind variables
This approach also makes it easy to trace a concurrent program with bind variables. The location of the trace will can be determined by using API fnd_trace.get_trace_filename. The beauty of this API construct is that it takes care of different platforms like Linux, NT, HP, AIX etc , when constructing the name and full path of the trace file for Concurrent Program
Comments
thnx a lot....
I want to know the below database objects are used in which reports.How can I do that,
is there any command or script I can run and get the details.
Pleas e help me.
1) AP_INOVICES
2) AP_INVOICES_ALL
3) AP_INVOICE_DIST RIBUTIONS
4) AP_INVOICE_DIST RIBUTIONS_ALL
5 ) AP_INVOICE_PAYM ENTS
6) AP_INVOICE_LINE S
Thanks In advance
Need your help .Can u tell me while preparing the technical design (TS) whether we have to write the code first and then TS or directly preparing the TS then make the code.
and how we can make the our TS effectively .If you have any prepared TS pls send me for the guidance .
Thanks,
Sand eep
Thanks a lot giving the help on oracle apps
how can we make the one parameter dependent on another parameter in discoverer
I have a requirement to generate 20 BI Publisher reports but other than using the concurrent programs. I planned to calling the java program behind the XDODTEXE executable directly from PL/SQL. I have two parameters for all the 20 reports. I do not know how to pass the parameters to JCP4XDODataEngi ne,which I belive is the java program. Can you help?
Thanks
K
I want to knowing about UTL_FILE.FOPEN whether we have to write the code in PL/SQL programing
I wana What the purpose of UTL_FILE.FOPEN and i want exct answer
In Advance
Thanks,
MMYS
i am new from oracle apps.so please give me a small join query for below details
--COLUMNS--
(SALSE_ORDER_NUMBER,CUSTOMERNAME, STATUS, ORDERTYPE, ITEM, CUSTMERNUMBER, SALSEPERSION, CUSTMER_PO, DATEORDERED, REQUESTDATE, PRICE_LIST, SHIPTO, BILLTO, WAREHOUSE, TERM, CURRENCY, FREIGHTTERMS, FOB, PODATE, PONUMBER.POQTY, POPRICE, QTY, SOPRICE, SUPPLIER)--DATA--
(210007513 Ford Motor Company of Canada Ltd. BOOKED EWI E CA Sales Orders 70000003 05 1004 No Sales Credit B69RL132 47541 18/09/201 3 19/09/13 09:33 Ford US Price List B69-FORD TRUCK & MODULAR ENGINE PL B69-FORD TRUCK & MODULAR ENGINE PL B69-Ford Windsor Engine Plant 60 NET USD 19/09 /13 10:13 220007200 6 82 6 102.5 A DVANCED CUTTING TOOLS INC.
210007514 Ford Motor Company of Canada Ltd. BOOKED EWI E CA Sales Orders 70000015 84 1004 No Sales Credit B69RL132 47542 18/09/201 3 19/09/13 09:33 Ford US Price List B69-FORD TRUCK & MODULAR ENGINE PL B69-FORD TRUCK & MODULAR ENGINE PL B69-Ford Windsor Engine Plant 60 NET USD 19/09 /13 10:13 220007201 3 134 3 157.65 LONERO ENGINEERING CO INC.
210007515 Ford Motor Company of Canada Ltd. BOOKED EWI E CA Sales Orders 70000026 33 1004 No Sales Credit B69RL132 47544 18/09/201 3 19/09/13 09:33 Ford CA Price List B69-FORD TRUCK & MODULAR ENGINE PL B69-FORD TRUCK & MODULAR ENGINE PL B69-Ford Windsor Engine Plant 60 NET CAD 19/09 /13 10:28 220007202 40 4.7 40 5.53 SANDVIK COROMANT
210007516 Ford Motor Company of Canada Ltd. BOOKED EWI E CA Sales Orders 70000019 00 1004 No Sales Credit B69RL132 47547 18/09/201 3 19/09/13 09:33 Ford US Price List B69-FORD TRUCK & MODULAR ENGINE PL B69-FORD TRUCK & MODULAR ENGINE PL B69-Ford Windsor Engine Plant 60 NET USD 19/09 /13 10:29 220007203 50 160 50 200 SPECIAL DRILL & REAMER CO
210007517 Ford Motor Company of Canada Ltd. BOOKED EWI E CA Sales Orders 70000029 35 1004 No Sales Credit B69RL132 47549 18/09/201 3 19/09/13 09:33 Ford US Price List B69-FORD TRUCK & MODULAR ENGINE PL B69-FORD TRUCK & MODULAR ENGINE PL B69-Ford Windsor Engine Plant 60 NET USD 19/09 /13 10:29 220007204 5 11.99 5 14.9 9 SAINT GOBAIN)
Thanks&Regards:
Mahendra.
rwtxdzcvcxbniye bkg
I surprise how so much effort you put to create any such wonderful informative site.
RSS feed for comments to this post