Apps 11i

How to get Apps version?

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
11.5.10.2


Webserver/Apache Version:

[avis11i@apps VIS_apps]$ $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Feb 22 2005 18:51:19 (iAS 1.0.2.2.2 rollup 5)

Forms Version:

[avis11i@apps VIS_apps]$ $ORACLE_HOME/bin/f60run | grep Version | grep Forms
Forms 6.0 (Forms Runtime) Version 6.0.8.28.0 (Production)


Report Version:



Jinitiator Version:

[avis11i@apps VIS_apps]$ grep jinit_ver_comma $CONTEXT_FILE
1.6.0_24

Workflow version

SQL> select TEXT Version from apps.WF_RESOURCES where NAME = 'WF_VERSION';

VERSION
--------------------------------------------------------------------------------
2.6.0

Apps Scripts

To get Log and out file location:

select
req.request_id,req.logfile_name LOG, req.outfile_name OUT
FROM v$process pid,
v$session ses,apps.fnd_concurrent_requests req, fnd_concurrent_programs_tl prg ,
fnd_user fu
WHERE req.request_id IN (SELECT request_id
FROM fnd_conc_req_summary_v
WHERE phase_code IN ('R')
AND status_code IN ('R'))
AND req.oracle_process_id = pid.spid(+)
AND pid.addr = ses.paddr(+)
AND req.concurrent_program_id = prg.concurrent_program_id
AND req.requested_by = fu.user_id
and req.request_id=&request_id
ORDER
BY SID ;