We can know the version and translation level of Oracle Application file in Three ways,
1. AD utility - adident.
2.Strings Utility.
3.By using SQL query.
1.AD utility - adident.
Executable -adident .
To find out a file version, oracle have provided ‘ADIDENT’ utility (AD Identification). This is an oracle apps based utility.
Executable Location : $AD_TOP/bin
Action :
$ adident Header <Filename>
Ex: adident Header adconfig.sh
2.Strings Utility.
Strings is a UNIX based utility which is used to print the strings of printable characters in files. We can use this utility to extract header information from the string content of a file.
Action:
strings -a <file_name>|grep Header
Eg:- strings -a OEXWFASG.rdf|grep Header
These two methods can be used to find out file versions for oracle seeded files like rfd, fmx, fmb, xml, txt, pls, etc.
Note:- Letter ‘H’ must be capital in key word ‘Header’
3.By using SQL query.
You can also use the following SQL query which shows the file version number and also the patch number which brought the file to the current version
select sub.filename, sub.version , sub.last_update_date, sub.app_short_name, sub.subdir
from (
select adf.filename filename,
afv.version version,afv.LAST_UPDATE_DATE,adf.app_short_name, adf.subdir,
rank()over(partition by adf.filename
order by afv.version_segment1 desc,
afv.version_segment2 desc,afv.version_segment3 desc,
afv.version_segment4 desc,afv.version_segment5 desc,
afv.version_segment6 desc,afv.version_segment7 desc,
afv.version_segment8 desc,afv.version_segment9 desc,
afv.version_segment10 desc,
afv.translation_level desc) as rank1
from ad_file_versions afv,
(
select filename, app_short_name, subdir, file_id
from ad_files
where upper(filename) like upper('%&filename%')
) adf
where adf.file_id = afv.file_id
) sub
where rank1 = 1
order by 1;
No comments:
Post a Comment