Techstack Inventory Report for EBS Release 12

Hello Everyone!!

Here is the good utility to check the techstack details of R12 ebiz suite.
After running the utility You will get the techstack details of your R12 environment in HTML report format. You can get in text format too!!

Utility Running Syntax:

Run the command in MT

perl $FND_TOP/patch/115/bin/ -script=$FND_TOP/patch/115/bin/ -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$OA_HTML/techstack_info.html

You can check the URL http://./OA_HTML/techstack_info.html

Same way you can check in DB tier

perl $ORACLE_HOME/appsutil/bin/ -script=$ORACLE_HOME/appsutil/bin/ -txktop=$ORACLE_HOME/appsutil/temp -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$ORACLE_HOME/appsutil/temp/master_db.html

Contents of the report:

DB side contents will look like the one attached here

Mid-Tier techstack inventory page will look like the one attached here

Its very good report having all kinda of information. To name a few

OC4J version
JDK version on HTTP server node
Oracle JDBC driver version using JAVA API (oracle.jdbc.driver.OracleDriver)
Oracle AOLJ version
Oracle BC4J version
Oracle BiBeans version
Oracle HTTP client version
Java object cache
Oracle JRAD libraries version
Oracle MDS version
OA Framework version
Oracle help web version

It also shows patch set of MT oracle homes and one-off patches applied.
I believe you will be benefited using this script when you are struck how to check the individual components version.

Happy Learning!!

No comments: