Bill of Materials Wizard

×
Menu
  • About BOM Wizard

About BOM Wizard

 
 
      
 
Welcome to Bill of Materials Wizard. 
 
We developed this tool to help with the data conversion process for Bill of Materials and to provide an alternative to the Oracle Applications Bill of Materials data entry form.
 
Oracle users needing to create Bill of Materials now have a richly featured excel solution allowing them to create their Bill of Materials directly from excel to Oracle Applications Bill of Materials module.
 
The 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’.
 
This documentation is written with the assumption that the User knows how to create Bills of Materials manually via the Oracle forms.  We recommend that you read this documentation in conjunction with the following:
 
        Oracle Bills of Materials User Guide: Chapter 2 - Creating a Bill of Material
 
        Oracle Manufacturing APIs and Open Interface Manual: Chapter 3 - Bill of Materials API Overview
 
The software interfaces with the standard Oracle Bills of Material API Interface for Standard Bills of Materials, Engineering Bills of Materials, and EAM Bills of Materials.  It does NOT modify any Oracle objects. 
 
Features
 
All options are available on a ribbon. 
 
Simply type, import, or paste the values directly into the spreadsheet.  You can also double-click in the spreadsheet to load the form for data-entry.  The data-entry form is optional.
 
You can upload Bill of Materials one at a time, select a range of Bill of Materials, or upload all Bill of Materials on the worksheet.
 
You can choose to have one Bill of Materials per worksheet or multiple Bills of Materials within a worksheet.
 
The program is flexible about the spreadsheet layout.  You can move, delete, or hide unnecessary columns. You can also have multiple sheets or even 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.
 
If you encounter any problems or have any suggestions, do not hesitate to contact us at https://more4apps.com/support/request-product-support/
 
Limitations
 
1.    Product configurator features are not part of the Wizard.  The configurator features are not provided in the interfaces available to us. 
 
2.    Oracle API does not support the creation of Rebuildable Serial Effective Components. It is however possible to Update them.
 
3.    The Implode functionality is not supported for 11i instances.
 
4.    The Implode/Explode functionality is not supported in EAM modes.  The Implode API appears to work inconsistently at level 3 or greater.  This is an issue with the public API we call rather than our product (Bom_Imploder_Pub).
 
5.    Assigning Operations:  To update an existing Assigned Operation requires a two-step process.
 
First you must delete the assigned operation and in a subsequent 2nd step create a new assigned operation.  This can still be achieved in a single upload by:
 
     Setting the Delete field to ‘Yes’ on the existing Assigned Operation.
     Insert another line with the Create action.
 
Note:  It is not possible to Assign Operations(s) to a Component when creating (adding) the Component.  You must do the Component Operation assignment separately in another upload.
 
6.    The Enable Attribute Update functionality is not supported for common BOMs in 11i Instances.
In R12 instances, if Enable Attributes Update flag is checked (Yes), it is possible to update the following attributes of a common Bill of Material:
 
     Operation
     Supply Type
     Supply Sub inventory
     Supply locator
 
7.    Download by Sheet is by default set to download Items in the Users Default Item Category Set.  However, the Download form has Category and Category-Set options available to download items with other than default Item Category-Set or no Category assigned.
 
8.    From R12.2 you can update the Item Basis type from ‘Lot’ to ‘Item’ or ‘Item’ to ‘Lot’.  Unfortunately for 11i or R12.1 only ‘Item’ to ‘Lot’ is possible.
 
9.    Dynamic Locator entry is not supported in the Bill of Materials Wizard because of the API limitations.
 
10.    This Wizard only supports Model, Option Class, Planning and Standard BOM types.
The Product Family BOM type is not supported by this Wizard.