Sunday, February 04, 2018

Script for finding oracle Forms and Self-Service page file versions

Finding file version from Oracle Forms and Self-Service page

select distinct app_short_name
,b.bug_number
,version,f.filename 
,to_char(prb.creation_date
,'dd-mon-yyyy
,hh24:mi:ss') Patch_date
from
apps.ad_file_versions v
,apps.ad_files f
,apps.ad_patch_run_bug_actions prba
,apps.ad_patch_run_bugs prb
,apps.ad_bugs b
where v.file_id=f.file_id
and f.file_id=prba.file_id
and prba.patch_run_bug_id = prb.patch_run_bug_id
and prb.bug_id=b.bug_id
and prba.patch_file_version_id=v.file_version_id
and lower(f.filename) like lower('<file name>')
order by filename;




Please provide your valuable feedback ............