Comments

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

6 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  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

    ReplyDelete

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