We developed this tool in response to demand from Oracle E-Business Suite users for a user friendly and robust spreadsheet tool to create and maintain suppliers in Oracle E-Business Suite.
Supplier Wizard is a VBA program embedded in a Microsoft Excel workbook. It is a member of our ‘Wizard’ product suite and shares the same look and feel.
The software uses the Oracle API’s available in Release 12 of Oracle E-Business Suite. These API’s are not available in prior releases; Supplier Wizard is only supported for Release 12 onwards.
It does NOT modify any Oracle objects except during the installation, where it inserts the More4apps Batch Source.
Features
All options are available on ribbons. Double-clicking in the spreadsheet also loads the forms. The forms are optional, and you can simply type, import a file, or paste the values into the spreadsheet.
You can upload Suppliers one at a time, a selection or your entire worksheet.
Access to Employees as Suppliers is controlled by a toggle ‘Include Employee Types’ on the Supplier Wizard - Setup Ribbon.
The program is flexible about the spreadsheet layout. You can move or delete unwanted columns. You can also have multiple sheets or even sheets in other workbooks.
Support
This program has been developed for Oracle Release 12 onwards and cannot be used in prior versions.
