Thursday, April 25, 2013

Checking the File Versions with SQL Query

Posted by at 1:47 AM Read our previous post

Many a times we need to check the file versions from our environment.
As functional consultants we generally don't have the database access.
Using the following query we can easily find the file versions without needing the help of a DBA

SELECT a.app_short_name, a.subdir, a.filename, b.version 
FROM   apps.ad_files a, 
       apps.ad_file_versions b 
WHERE  a.FILENAME like '%<filename>%' 
AND    a.file_id = b.file_id 
AND    a.app_short_name = 'HZ' --- e.g. : ASF, AMS.... 
AND    b.creation_date = (SELECT MAX (creation_date) 
                          FROM apps.ad_file_versions ver 
                          WHERE ver.file_id = a.file_id)

You may also like to read      Find Profile Option values using SQL queries
                                             Process to Debug a Concurrent Request
                                             Sending Email using PL/SQL Procedure
                                             Find Trace File location using SQL


  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.

  2. thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post.
    SAP SuccessFactors Training
    SAP SuccessFactors Online Training

  3. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check


© Oracle Apps CRM is powered by Blogger - Template designed by Stramaxon - Best SEO Template