Wednesday, November 7, 2007

Check Developer Forms Patch Set Level

Print this post 1.Login though applmgr account

2.Create a file fpslevel.sh

cat > fpslevel.sh
copy the following contents in fpslevel.sh file.

#!/bin/sh
########################################
#fpslevel.sh - Used to find out the forms patchset level
########################################
clear
PatchLevel=0
f60gen > /dev/null 2>&1
if [ $? -eq 127 ]
then
echo "Environment is not Set"
else
PatchLevel=`f60gen | grep '(Form Compiler)' | grep -v Release | awk -F. '{print $5}' `
echo 'Forms Patchset Level :' ` expr $PatchLevel - 9 `
fi
echo 'For More Information '
echo 'Refer to Metalink Note:232313.1 for More Information'

3.Grant the execute permission to the script
chmod 777 fpslevel.sh

4.Execute the script.
./fpslevel.sh

3 comments:

kommareddy said...

another simplest way is:
f60gen

you get this:
Forms 6.0 (Form Compiler) Version 6.0.8.27.0 (Production)

just do a 27 - 9 = 18

tqadir said...

The above methods need access to either DB or the Server which might be problem. The simplest way is from the Apps front-end(Forms) go to Help..."About Oracle Applications". This not only gives Forms version, it also provides a lot of useful information like the DB servername, Middle-Tier name, name of the Form, etc.

Famy Rasheed said...

Taqdir >

As DBA point of view, we should be knowing to get the info from the backend. Its not necessary that apps front end is always accessible when there are troubleshooting periods. And you feel it difficult, as you are not used to it. It is just matter of seconds to get details from back end.

Kommareddy >

what you have said is right. And the script does exactly the same and you dont have to even do the calculations, just copy and execut the script. I think you havent reviewed the script.

-Famy