It also provides helpful feedback and references on Best Practices for areas of disquiet on eBusiness Inventory module. Inventory Analyzer script does not replace existing available diagnostics, health checks, or wizards; however it is a good new addition to help in managing the overall health of Inventory Module. Many of existing scripts are combined in Inventory Analyzer as one validation script.<\/p>\n
Let\u2019s have a look of this tool, how to execute, we will go through step by steps<\/p>\n
1-Down Load from MOS Note: Inventory Analyzer : Health Check For Common Inventory Data Issues, Critical Patches, And Setups [ID 1499475.1]<\/p>\n
2-Place into your application node at custom top like xxcustom through toad ftp or winscp.<\/p>\n
![\"ftp\"](\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2013\/06\/ftp.png?resize=896%2C292\")
<\/p>\n
3-connect to sql and go to your custom location and run the SQL Inventory Analyzer script.<\/p>\n
![\"sql\"](\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2013\/06\/sql.png?resize=450%2C160\")
<\/p>\n
4- eBusiness Inventory Analyzer will create file with the name of inv_analyzer_<host> _<instance>_2013-Jun-23\u00a0<\/i><\/i><\/p>\n \n 5-ftp output of Inventory Analyzer to your local machine and open it. First part of report will show the table of contents<\/p>\n \n \n In this example under Critical\/Recommended Patches section, <\/b>this report is showing priority patches which are missing on the environment and should be applied. You can go through Abstract column of each patch descriptions.<\/p>\n
\n<\/a>![\"sql2\"](\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2013\/06\/report2.png\")
<\/a>
\n<\/a>
\n<\/a>![\"sqlanarun\"](\"https:\/\/i0.wp.com\/oraerp.com\/blog\/wp-content\/uploads\/2013\/06\/report5.png\")
<\/a><\/p>\n<\/p>\n<\/p>\n<\/p>\n
![\n<\/a>](\"http:\/\/oraerp.com\/blog\/wp-content\/uploads\/2013\/06\/report.png\"){kind=link}
![\n<\/a>](\"http:\/\/oraerp.com\/blog\/wp-content\/uploads\/2013\/06\/report3.png\"){kind=link}
![\n<\/a>](\"http:\/\/oraerp.com\/blog\/wp-content\/uploads\/2013\/06\/report4.png\"){kind=link}