Oracle R12 - Technology Inventory Utility

Technology Inventory Utility (TIU)  that was introduced in Oracle E-Business Suite Release 12. TIU generated a report that lists the installed technology stack components and  versions on the various nodes of a Release 12.x Oracle E-Business Suite system. The reports can be generated in either HTML (the default) or text format. This report is very useful for Oracle Application upgrade and patching.

Separate reports are generated for the database and application tiers. The details are in the Oracle E-business Suite Maintenance Guide.

Application Tier:

perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP  -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$APPLTMP/Report_Inventory.html

Database Tier:

perl $ORACLE_HOME/appsutil/bin/TXKScript.pl -script=$ORACLE_HOME/appsutil/bin/txkInventory.pl -txktop=$ORACLE_HOME/appsutil/temp -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$ORACLE_HOME/appsutil/temp/Report_Inventory.html

To generate the report in text format, append -reporttype=text to the relevant command, and change the outfile name to have a .txt suffix instead of a .html suffix.

Reference:
http://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T499006.htm#4787733