Item Extension Wizard

×
Menu
  • About Item Extension Wizard

About Item Extension Wizard

 
      
 
Welcome to Item Extension Wizard.  This Wizard compliments the standard Item Wizard and is included with any Item Wizard licence.
 
We developed this tool in response to demand from Oracle Inventory Users for a User friendly and robust spreadsheet tool to load additional elements to items. 
 
Item Extension 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.
 
Current Upload Functionality
 
The software uses the standard Oracle Interfaces and API where available (except * listed functions).
 
Using standard Oracle Interfaces and API where available:
 
* Sourcing Assignment
 
Exceptions using direct insert into the base tables:
 
    * ABC Assignment
    * Container Items
    * Manufacturer Part Numbers
    * Pending Item Statuses
    * Customer Item XRefs
             Create by concurrent program
             Update by direct table inserts
    * Related Item
             In 11i instances uses direct table insert for uploading
             (API mode available in Item Wizard from r12.1.3 onwards)                
    * Safety Stock
    * Subinventory
    * Transaction Default (Available in Item Wizard from r12.2 onwards)
    * UOM Inter-class
    * UOM Intra-class
 
It does NOT modify any other Oracle objects except during the installation, where it adds the More4apps Packages and Profile Options.
 
Disclaimer: Direct table inserts do not offer the User any form validation like you would get from an API, so it is the Users responsibility to ensure the validity of their own data before uploading.  More4apps assumes no responsibility for incorrect data. 
 
Features
 
All options are available on the ribbon.  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 records or the entire contents of your worksheet.
 
The program is flexible about the worksheet layout.  You can move or delete unwanted columns.  We recommend you have multiple workbooks defined by the transaction type you are loading.  The Wizard also supports loads from sheets in other workbooks.
 
If you encounter any problems or have any suggestions to enhance the functionality of Item Extension Wizard, please do not hesitate to contact us at https://more4apps.com/support/new-support-request