OraclePitStop – Lets share some knowledge

Versions of components in Oracle Apps

Posted on April 18, 2007. Filed under: Scripts, Version |

How to find versions of oracle components associated with Oracle Apps in Windows Environment

Many times we find ourselves in a situation where we just couldnt get the steps to ascertain the versions of components associated with our instance, be it on Unix/Windows. I had listed the steps below to ascertain the version for each component. All the steps can be used in both Unix/Windows environment , except for Developer6i version. We also have a shell script which will give all this information in a table format which was not tested till now on a Windows environment. If interested put a comment, we will write the script in a post.

Database

Connect as apps user;
<you should be getting the banner with oracle version information>. Alternatively you can also execute
Select * from v$version;

---

Apps Version

Connect as apps user
select release_name from apps.fnd_product_Groups;

---

Apache/iAS Version

%IAS_ORACLE_HOME%\Apache\Apache\apache.exe -version

---

Developer 6i PatchSet

cd %ORACLE_HOME% (806 Oracle Home)
cd bin
Ifrun60.exe help=yAbove command will pop-up a window simillar to this

Thumbrule : Subtract the fourth integer by 9 to get the patchset level.
Ie., 6.0.8.24.1
Fourth integer => 24
Dev6i PS => 24-9 = 15

---

Discoverer 4i Version

cd %APPL_TOP%\admin
grep -I s_disco_ver_comma *<sid>*xml

---

Jinitiator Version

cd %APPL_TOP%\admin
grep -i s_jinit_ver_dot *<sid>*xml

---

JDK/Java Version

java -version

---

OJSP Version

cd %OA_HTML%
echo “<%= application.getAttribute(“oracle.jsp.versionNumber”) %>” > test.jspLaunch Browser and enter urlhttp://<hostname>.<domain>:port/OA_HTML/test.jsp

---

JDBC Version

http://<hostname&gt;.<domain>:port/OA_HTML/jsp/fnd/aoljtest.jspLook for String ” JDBC driver version” under Connection String

---

OA Framework Version

Option 1http://<hostname&gt;.<domain>:port/OA_HTML/OAInfo.jspOption 2adident Header %FND_TOP%/html/OA.jsp
adident Header %OA_HTML%/OA.jspNote: OA.jsp should be of the same version in both the places

---

AD PatchSet Level

Connect as apps user
select patch_level from fnd_product_installations where patch_level like ‘%AD%’;Note: above sql can be used to identify any modules patchset level by replacing AD with the module name eg., BNE

---

Portal Version

select fnd_oracle_schema.getouvalue(‘PORTAL’) from dual;FND_ORACLE_SCHEMA.GETOUVALUE(‘PORTAL’)
——————————————————————————–
PORTAL30 <= to retrieve the portal userselect version from PORTAL30.wwc_version$;

VERSION
——————————————————————————–
3.0.9.8.1

---

For gathering version information on Unix Flavours click this linkDo you have a better way of finding the version. Feel free to comment.

cheers,

OraclePitStop

Make a Comment

11 Responses to “Versions of components in Oracle Apps”

Comments RSS Feed

Where's The Comment Form?