Oracle Applications:
To obtain version of form from any applications form, navigate to the form. Then in the Menu tool bar .
Help --> About Oracle Applications
Or
select release_name from fnd_product_groups;
Database Objects:
select text from user_source where name='&package_name' and text like '%$Header%';
Views:
select VIEW_NAME, TEXT
from
USER_VIEWS
where VIEW_NAME = '&VIEW_NAME';
Oracle Workflow:
$FND_TOP/sql/wfver.sql
OR
select TEXT from WF_RESOURCES where NAME='WF_VERSION';
Unix:
uname -a
Windows:
Start => Parameters => Control Panel => System
Java:
java -version
Sqlplus :
start --> Run --> cmd
sqlplus
TnsPing:
start --> Run --> cmd
TNSPING
D2k version:
ORACLE_HOME\Orainst\nt.rgs
File versions:
On Unix: strings -a "File name" | grep Header
On Windows : find "Header" File_name
To obtain version of form from any applications form, navigate to the form. Then in the Menu tool bar .
Help --> About Oracle Applications
Or
select release_name from fnd_product_groups;
Database Objects:
select text from user_source where name='&package_name' and text like '%$Header%';
Views:
select VIEW_NAME, TEXT
from
USER_VIEWS
where VIEW_NAME = '&VIEW_NAME';
Oracle Workflow:
$FND_TOP/sql/wfver.sql
OR
select TEXT from WF_RESOURCES where NAME='WF_VERSION';
Unix:
uname -a
Windows:
Start => Parameters => Control Panel => System
Java:
java -version
Sqlplus :
start --> Run --> cmd
sqlplus
TnsPing:
start --> Run --> cmd
TNSPING
D2k version:
ORACLE_HOME\Orainst\nt.rgs
File versions:
On Unix: strings -a "File name" | grep Header
On Windows : find "Header" File_name