BOM Bill of Materials Upload creates and updates manufacturing bills of material – the assembly bill headers, their components and component substitutes – in Oracle EBS from Excel, through the standard BOM API. It maintains the bills and their components; it does not create the items, routings or organizations themselves.
When to use it
- Mass-create new bills of material for many assemblies at once instead of entering them in the Bills of Material form.
- Add, change or retire components on existing bills (quantity, supply type, planning percent, yield, effectivity dates).
- Maintain substitute components across many bills.
- Roll out the same bill structure across several organizations by changing the Organization Code per row.
- Populate component, bill or substitute descriptive flexfields in bulk.
Before you start
- Blitz Report is installed and you are signed in to a Manufacturing or Bills of Material responsibility with access to the inventory organization.
- The assembly item exists and is BOM-enabled, and the component items exist in the organization.
- Any operation sequence you reference already exists on the assembly’s routing.
Choose a template
| Template | Use it for |
|---|---|
| BOM Upload Template (default) | Standard bill and component maintenance. |
| BOM Upload Template with DFF Attributes | The standard columns plus the bill, component and substitute descriptive flexfield columns. |
Step 1 – Choose a template and mode, set the parameters and download
In Blitz Report, open BOM Bill of Materials Upload, choose your template, and set the parameters:
| Parameter | Purpose |
|---|---|
| Upload Mode | Create (empty template) or Create, Update (download existing bills). Default is Create, Update. |
| Organization Code | The inventory organization whose bills are downloaded. |
| Assembly | Optionally download the bill of a specific assembly. |
| Alternate BOM | Download a specific alternate bill instead of the primary bill. |
| Include Sub-Assemblies / Implemented Only / Display / Effective Date | Control which components are downloaded. |
Run the upload to download and open the Excel file. Each bill, component and substitute is automatically handled as a create or an update depending on whether it already exists.
Step 2 – Enter the bill and its components
The sheet carries one row per component; the bill header (Organization Code, Assembly Item, optional Alternate BOM) repeats on each of its component rows. On each component row enter the Component Item, the Component Quantity, the Date Effective From (required), and where they apply the Operation Seq, Supply Type and supply subinventory or locator. To retire a component, set its Date Effective To – components are end-dated rather than deleted.
Step 3 – Add substitute components (optional)
To give a component a substitute item, enter the Substitute Item and Substitute Quantity on the component’s row. Changing the substitute to a different item replaces the previous one.
Step 4 – Validate and Save
Click Validate and Save. This checks for missing required values and runs the upload’s validation, then saves the file. Correct anything it flags before continuing.
Step 5 – Upload and view the result
Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which creates or updates each bill through the BOM API. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Created and updated bills of material with their components and substitutes.
- A result report listing every row with a status (success or error) and a message.
Common questions
How do I delete a component from a bill?
Set its Date Effective To (disable date) to retire it – components are end-dated, not physically deleted. Only substitute items are physically removed, by changing the substitute on a component.
Why can’t I create a new bill?
Check the Upload Mode. In Update mode new bills are rejected; use Create or Create, Update. Editing an existing bill in Create mode is also rejected.
Do I need to set an action?
No. The upload detects create versus update automatically from whether the bill, component or substitute already exists.
How do components attach to operations?
Through the Operation Seq, which must be an existing operation on the assembly’s routing. If the assembly has no routing, leave it at the default of 1.
Which template should I use?
Use BOM Upload Template for normal maintenance; use the DFF template only when you need to enter descriptive flexfield values.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| You cannot update an existing BOM in Create Upload Mode | The bill already exists but Upload Mode is Create. | Re-run in Create, Update mode. |
| You cannot create a new BOM in Update Upload Mode | No bill exists yet but you are in Update mode. | Use Create or Create, Update mode. |
| Date Effective From is required | A component row has no effectivity start date. | Enter a Date Effective From on every component row. |
| End Item Unit Number From is required | The assembly uses unit-number effectivity but the field is blank. | Provide the End Item Unit Number From for that component. |
| One or more rows for this BOM have an error | A row on the bill failed, so the whole bill is held back. | Fix the flagged row(s); the entire bill is processed as a unit. |