Find file version history of a file in Oracle Apps R12/11i

This post will help you to find File version history of any particular file with in Oracle Apps R12/11i

If you have requirement to find out patches which has updated any particular file, using below query you will be able to find out file history.

·          Below sql will list out details for  particular form  “FNDRSRUN.fmb”

set line 200;

col FILENAME for a15;

col APP_SHORT_NAME for a10;

col VERSION for a25;

col PATCH_NAME for a15;

select distinct af.app_short_name

, af.filename

, afv.version

, afv.creation_date

, apr.end_date

, aap.patch_name

, aprb.applied_flag

, aprb.success_flag

from ad_patch_drivers apd

, ad_applied_patches aap

, ad_patch_runs apr

, ad_patch_run_bugs aprb

, ad_patch_run_bug_actions aprba

, ad_file_versions afv

, ad_files af

where apd.patch_driver_id = apr.patch_driver_id

and apd.applied_patch_id = aap.applied_patch_id

and apr.patch_run_id = aprb.patch_run_id

and aprb.patch_run_bug_id = aprba.patch_run_bug_id

and aprba.patch_file_version_id = afv.file_version_id

and afv.file_id = af.file_id

and af.filename = 'FNDRSRUN.fmb'

order by 2, 4

The above output displays the file versions and patches which had updated this file.

Same way you will be able to find out history of any object.