Tuesday, October 9, 2012

How to get versions used by Oracle E-business suite.

1.Operating system
 uname -a

2. Database
 sqlplus apps/apps

3. Oracle applications
 select release_name from fnd_product_group;

4. Forms, sql, pls, reports
 strings file_name |grep $Header

or use this:
SELECT    'strings $'
       || DECODE (app_short_name,
                  'OFA', 'FA',
                  'SQLGL', 'GL',
                  'SQLAP', 'AP',
                  app_short_name
                 )
       || '_TOP/'
       || subdir
       || '/'
       || filename
       || ' | grep Header'
  FROM ad_files
 WHERE filename = '<your file name>';

5. Database objects
 select text
 from user_source
 where name='&package_name' and text like '%$Header%';

 select name, text
 from dba_source
 where text like '%.pls%' and line < 10;

 select VIEW_NAME, TEXT
 from USER_VIEWS
 where VIEW_NAME = '&VIEW_NAME';

6. Workflow
 select * from WF_RESOURCES where NAME='WF_VERSION';


No comments:

Post a Comment