How to find Oracle Application file versions

FORM 

    1. Use \Help Version 

    2. Or Help, About Oracle Applications (when using 10SC) 

    3. adident   (Ex. adident Header ARXTWINS.fmx) 

    4. strings -a  form.frm |  grep  Revision  (Ex. strings -a POXPOMPO.frm | 

grep Revision) 

    REPORT 

cd $AR_TOP/reports

    1.  adident Header report.rdf (Ex. adident Header ARBARL.rdf) 

    2.  strings -a  report.rdf  |  grep  Header  (Ex. strings -a ARBARL.rdf  |  

grep Header) 

    SQL 

    1.  more  sqlscript.sql  (Ex.  more  arvstrd.sql) 

         The version will be in a line that starts with ¿REM  $Header¿, and 

should be one of the 

         first lines in the .sql file. 

    2.  grep ¿$Head¿ sqlscript.sql  (Ex.  grep  ¿$Head¿  arvsrtds.sql ) 

    BIN or EXECUTABLE 

    An executable in the bin directory will contain numerous C code modules, 

each with its own version. All of the following examples use ident or strings, 

but 

    the difference is what you grep for. 

    1.  Get ALL file versions contained in the executable. 

           adident Header executable (Ex. adident Header RACUST) 

             strings -a  executable  |  grep  Header  (Ex. strings -a RACUST | 

grep Header) 

    2.  Get ALL of the product specific file versions. 

         adident  Header executable (Ex.  adident Header RACUST) 

            strings -a  executable  |  grep  Header

          (Ex.  strings -a  RACUST  |  grep  Header) 

    3.  Get only the version of a specified module. 

         strings -a  executable  |  grep  module  (Ex. strings -a RAXTRX | 

grep raaurt) 

    ORACLE REPORTS 

    To find the version of Oracle Reports the customer is using: 

    1. From the operating system type ¿r20run¿, ¿r25run¿, or ¿r30run¿ (etc), 

depending on Reports version: (find this executable in their $ORACLE_HOME/bin 

directory). Then use the 

        menu patch Help, About Oracle Reports. 

    RDBMS 

    1. Use \Help Version 

    2. Or Help, About Oracle Applications (when using 10SC) 

    3. Get into SQL*Plus using any userid/password. You will get a string that 

gives you the database and PL/SQL version being used.