BOM Wizard

BOM Wizard is an Excel based tool for loading Bill of Material information on mass into the Oracle e-Business Suite.

BOM Wizard can be used to create or maintain Bills of Materials within Oracle Bill of Materials.  You can also create or maintain Engineering Prototypes within Oracle Engineering.  The downlod feature extracts existing Bill of Material information from Oracle to use as the basis for creating new records or doing maintenance.

Benefts   

  • Increases productivity and accuracy
  • Fast, easy to use and flexible
  • Harnesses the full power of Microsoft Excel to make BOM data entry 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 forms, include data validation and full list of values capability
  • Load one, a range, or all Bill of Materials on the worksheet
  • Add or end date selected components within an existing Bill of Materials
  • Supports Item Revisions, Alternates and Reference Designators
  • Descriptive Flexfields are configured according to your system set up
  • Add assemblies or components to Delete Groups within Oracle
  • Formulas can be used in place of values
  • Use multiple sheets and even operate on sheets in other workbooks
  • Messages are returned to the worksheet

This program uses the standard Oracle Bill of Materials API Interface. Installation can be performed in minutes by your DBA.

Compatible with Microsoft Excel 2000 and later versions, on any operating system.

Connects to Oracle E-Business Suite Release 11i onwards, on any platform (contact us if you require a version for 11.5.9).