Wednesday, June 11, 2008

How to get Version of Programs, Files, and Objects

1) ORACLE APPLICATIONS

To obtain version of form from any applications form, navigate to the form. Then in the Menu toolbar
select Help => About Oracle Applications.
Or
Run the following statement
select release_name from fnd_product_group;

2) DATABASE OBJECTS
select text from user_source where name='&package_name' and text like '%$Header%';

You can also obtain the pls version on the database by running:
select name, text
from dba_source
where text like '%.pls%'
and line

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

No comments: