In
order to open concurrent request output or log file in browser by clicking on
button in Custom Oracle form we need to do the following steps to achieve this:
1]
Open custom form in Form Builder and click on Attached Libraries. Then click on + add button.
2] Add FNDCONC.pll
library file. This library file is available in the $AU_TOP/../resource folder.
3]
Now open the FNDCONC.pll library
file from Resource folder in Oracle Form Builder. Inside FNDCONC.pll library there are standard program units defined by
oracle.
4] In
order to open submitted request output file by clicking on Button we need to
use procedure report defined in EDITOR_PKG.
Syntax
- EDITOR_PKG.report (req_id number,
save_output_flag varchar2);
where, req_id is request id of submitted request
save_output_flag is to indicate whether output file to be saved or not.
where, req_id is request id of submitted request
save_output_flag is to indicate whether output file to be saved or not.
5] To
open submitted request log file by clicking on Button we need to use procedure request_log defined in EDITOR_PKG.
Syntax
- EDITOR_PKG .request_log(req_id
number);
where, req_id is request id of submitted request.
where, req_id is request id of submitted request.
6]
Now call the above two procedures on button’s WHEN-BUTTON-PRESSED trigger to
open concurrent request log/output file.
7] Save and compile the form on server, and check the request output and log file by clicking button on custom form.
can you tell me about the FNDCONC.pll library that where will we placed in attach library and pl/sql library ?
ReplyDeleteplace FNDCONC.pll library in attach library
Delete