Item Wizard
Item Wizard is an Excel-based front-end for the Oracle Inventory Items Form. This program contains the validation and defaulting rules of the Oracle forms plus the capabilities made possible by our popular spreadsheet model.
You can download existing Items, Categories and Catalogs from within Oracle as the basis for your new items and employ the features of Excel to help prepare your data. Item Wizard is an ideal tool for data conversion and data migration.
Benefits
- Increases productivity and accuracy
- Fast, easy to use and flexible
- Harnesses the full power of Microsoft Excel to make Item Maintenance tasks a breeze
- Configures itself to your system set up
- Easy to customize
- Cuts down data entry time
- Eliminates re-keying errors
- Robust integration between Excel and Oracle
- Control the entire process from the spreadsheet
- Close to zero implementation effort
Features
- Optional data entry form, which includes data validation and full list of values capability
- Load one, a selected range or all items from the worksheet
- Supports 'template' and 'copy from' item functionality
- Supports Inventory Item Descriptive Flexfields
- Supports the loading of catalog and category information
- Comes with a customizable database package which enables you to generate your own item numbers
- Supports both item creation and maintenance
- Submit the Item, Category and Catalog Concurrent Programs from within Excel and refresh the spreadsheet to view the result
- Messages are returned to the worksheet
- Can use formulas in place of values
- Can have multiple sheets and even operate on sheets in other workbooks
This program uses the standard Oracle Inventory Items Interface Tables. Installation can be performed minutes by your DBA.
Compatible with Microsoft Excel 2000 and later versions, on any operating system.
Connects to Oracle E-Business Suite Release 11.5.9 onwards, on any platform.