We developed this tool in response to demand from Oracle Inventory Users for a user-friendly and robust worksheet tool to load Items, Organization Assignment, UDA Attributes, Cross References, Categories and Catalogs into the Oracle Inventory module.
Item Wizard is a VBA program embedded in a Microsoft Excel workbook. It is a close cousin to our other “Wizard” products and shares the same look and feel.
The software uses the standard Oracle Inventory Open Interfaces and Oracle Public APIs. It does NOT modify any other Oracle objects except during the installation, where it adds the More4apps Packages and Profile Options.
Note – If the package version in the Wizard is smaller than the minimum package version, the Wizard will ask the customer to update the packages.
This documentation is written with the assumption that the User knows how to create and update Items and Categories manually via the Oracle forms.
Features
Options are available on the ribbons. Double-clicking in the worksheet loads the Item form. The form is optional, and you can simply type, import, or paste the values into the worksheet.
You can upload selected items or the entire contents of your worksheet.
The program is flexible about the worksheet layout. You can move or delete unwanted columns. You can have multiple worksheets or even load items from sheets in other workbooks.
This product is supported on most versions of E-Business suite from 11.5.10.2 onwards. Please reference our compatibility section for further details: https://more4apps.com/support/what-we-support
Item Wizard uses the standard Oracle Inventory Interface tables provided with e-Business Suite 11i and R12. Therefore, Item Wizard performs in the same way as Oracle when creating and updating Items via the interface. Before entering Item data for the first time, you may want to look at the performance recommendations in the ‘Manufacturing Open Interfaces Manual, Chapter 7 – Open Item Interface’.
