Oracle Apps: Check file version


[root@test ~]# su - appldev

[appldev@test ~]$ . /u01/dev/devapps/apps/EBSapps.env


Check version of the File

Two ways to check version of file.
1. Adident
2. Strings

ADIDENT Utility in ORACLE application is used to find version of any file.

1st Method

Syntax : adident Header filename.
e.g If you want to find out the version of appvndrb.pls

$ cd AP_TOP/patch/115/sql
$ adident Header appvndrb.pls

o/p :
appvndrb.pls:
$Header appvndrb.pls 120.78.12010000.83 2010/04/27 21:00:55 vinaik ship

2nd Method :

Using Strings:
Syntax : strings -a Top_name/location of file/filename | grep ‘$Header’
e.g $ strings -a $AP_TOP/patch/115/sql/appvndrb.pls | grep ‘$Header’
o/p : /* $Header: appvndrb.pls 120.78.12010000.83 2010/04/27 21:00:55 vinaik ship $ */

OR

$ cd $AP_TOP/patch/115/sql
$ strings -a appvndrb.pls | grep ‘$Header’


or from front end


select af.FILE_ID,af.APP_SHORT_NAME,af.SUBDIR,av.VERSION,av.CREATION_DATEfrom ad_files af,ad_file_versions avwhere af.file_id=av.file_idand af.filename = 'XLAAAR01.rtf'and av.CREATION_DATE > to_date('01-08-2017','dd-mm-yyyy')