This chapter describes the Technology Inventory Utility that was introduced in Oracle E-Business Suite Release 12. This command-line utility generates reports that list 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. Separate reports are generated for the database and application tiers.
Since there are major differences in technology components between Release 11i and Release 12.x, this utility will also be useful for those who wish to become familiar with the components and versions employed by Release 12.x.
The Technology Inventory Utility generates a consolidated report that summarizes the version levels of all installed technology stack components.
Set your Oracle E-Business Suite environment, then run one of the following commands:
Application tier:
perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=password -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=password -outfile=$ORACLE_HOME/appsutil/temp/Report_Inventory.html
Note: 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.
Application tier:
perl %FND_TOP%\patch\115\bin\TXKScript.pl -script=%FND_TOP%\patch\115\bin\txkInventory.pl -txktop=%APPLTMP% -contextfile=%CONTEXT_FILE% -appspass=password -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=password -outfile=%ORACLE_HOME%\appsutil\temp\Report_Inventory.html
Note: 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.
The following table describes the parameters for the utility:
| Parameter | Usage |
|---|---|
| txktop | Temporary working directory used by perl modules. Required parameter. |
| contextfile | Location of the Applications context file. If not specified, default is picked from environment. |
| appspass | APPS schema password. If not specified, default password is used. |
| outputfile | Location of the report being generated. If not specified, the default location is $APPLTMP/TXK. |
The report generated on both the application and database tiers has the following common header:
| Parameter | Usage |
|---|---|
| Date | Date on which report was generated. |
| Hostname | Details of host on which report was generated. |
| Enabled Services | Services enabled on the host where report was generated (application tier only). |
| Instance | Name of the instance. |
| Platform | OS name of the host where report was generated. |
| OS | OS release version of the host where report was generated. |
| DB Host | Details of the host where database is located. |
| Context File | Location of the context file specified when the report was generated. |
| Report File | Location of the report that was generated. |
| XML Definition File | Lists actions executed to obtain the contents of the report. |
The contents of the main report reflect the role of the node on which the utility is run: Database, Web, Forms, or Concurrent Processing.
A future release of Oracle E-Business Suite will build on the Inventory Utility to validate the components in use.