INV Manufacturer Upload creates, updates and deletes Oracle Inventory manufacturers – the master list of part manufacturers used for manufacturer part numbers and approved supplier lists – from Excel. It maintains the manufacturer name, description and descriptive flexfield attributes; it does not maintain manufacturer part numbers.
When to use it
- Load a list of new manufacturers in bulk during implementation or data migration.
- Mass-update manufacturer descriptions or descriptive flexfield attributes.
- Rename manufacturers, with built-in uniqueness checking.
- Delete unused manufacturers that have no manufacturer part numbers or approved supplier list entries.
Before you start
- Access to the upload in Blitz Report.
- Manufacturer names are unique.
- A manufacturer can be deleted only when it has no manufacturer part numbers, approved supplier list entries or other associations.
Step 1 – Set the parameters
Open INV Manufacturer Upload in Blitz Report and set the parameters:
| Parameter | Meaning |
|---|---|
| Upload Mode | Create opens an empty sheet for new manufacturers; Create, Update (default) downloads existing manufacturers for editing and lets you add new ones; Update downloads existing manufacturers for editing. |
| Manufacturer | Downloads a single manufacturer. |
| Manufacturer From | Downloads manufacturers whose name is alphabetically from this name. |
| Manufacturer To | Downloads manufacturers whose name is alphabetically up to this name. Defaults to Manufacturer From. |
Leave the manufacturer parameters empty to download all manufacturers.
Step 2 – Run to download the Excel file
Click Run. The Excel file downloads and opens with one row per existing manufacturer, or an empty sheet in Create mode.
Step 3 – Enter or change the manufacturers
Change the Manufacturer Description of a downloaded row, or change its Manufacturer name to rename it; the new name must not be used by another manufacturer. To create a manufacturer, add a row with a new Manufacturer name and a description. To delete a manufacturer, set Delete Manufacturer to Yes on its row. Mfg Part Number Count is informational only: it shows how many manufacturer part numbers exist for the manufacturer, which must be zero for a deletion. The descriptive flexfield columns (Manufacturer Attribute Category and the attribute segments) are not part of the Default template; add them to your own template to maintain them.
Step 4 – Validate and Save
Click Validate and Save. This checks for missing required values and saves the file. Correct any rows it flags before uploading.
Step 5 – Upload the file
In Blitz Report click Upload and select the saved file. This submits the upload request, which creates, updates or deletes each manufacturer.
Step 6 – Review the result report
When the request completes, a result report opens listing every uploaded row with its status and message.
What’s produced
- Manufacturers created, updated, renamed or deleted.
- A result report listing every row with a status (success or error) and a message.
Common questions
Does this maintain manufacturer part numbers?
No. It maintains the manufacturer records only and shows the number of their part numbers for reference. Manufacturer part numbers are maintained with the INV Item Upload.
Can I rename a manufacturer?
Yes. Download it and change the Manufacturer value on its row. The upload rejects the change if another manufacturer already has the new name. Existing part numbers and approved supplier list entries stay linked to the renamed manufacturer.
How do I delete a manufacturer?
Download it, set Delete Manufacturer to Yes and upload. It is deleted only if it has no manufacturer part numbers, approved supplier list entries or other associations.
How is a row matched to an existing manufacturer?
A downloaded row keeps the link to its manufacturer, so it updates that manufacturer even when you change the name. An added row is matched by name: if the manufacturer already exists it is updated, otherwise it is created.
Can I maintain the descriptive flexfield attributes?
Yes. Add the Manufacturer Attribute Category and attribute columns to your own template. The values are validated against the Manufacturers descriptive flexfield setup.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Manufacturer name cannot be updated. This Manufacturer name already exists | A rename to a name another manufacturer already uses. | Choose a unique new name. |
| Duplicate Manufacturer. This Manufacturer had already been processed in this upload. | The same manufacturer name appears more than once in the file. | Keep one row per manufacturer. |
| Manufacturer cannot be deleted. MFG Part Numbers exist for this Manufacturer | The manufacturer has manufacturer part numbers (Mfg Part Number Count is not zero). | Remove the part numbers first, or do not delete this manufacturer. |
| Manufacturer cannot be deleted. Approved Supplier List exists for this manufacturer | The manufacturer is used on an approved supplier list. | Remove the approved supplier list entries first, or do not delete this manufacturer. |
| Manufacturer cannot be deleted. The Manufacturer no longer exists | Delete Manufacturer is Yes for a manufacturer that does not exist, for example one deleted after the download. | Remove the row, or download the manufacturers again. |