INV Unit Of Measure Upload creates and updates Oracle Inventory unit-of-measure classes and their member units of measure, including their descriptive flexfield attributes, from Excel. It is available on Oracle EBS R12.2 and later.
When to use it
- Mass-create new unit-of-measure classes and their units during implementation or a new-organization rollout.
- Add additional units of measure to existing classes.
- Update descriptions or descriptive flexfield attributes on many classes or units at once.
- Set inactive dates to retire units or classes in bulk.
Before you start
- Blitz Report is installed and you are signed in to a responsibility that can maintain units of measure.
- You are on Oracle EBS R12.2 or later.
- When creating a new class, its first row is the base unit, with the Base UOM Flag set to Yes.
Step 1 – Choose a mode, set the parameters and download
In Blitz Report, open INV Unit Of Measure Upload, choose an Upload Mode (Create for an empty template, or Create, Update to download existing data), and optionally restrict to one Unit of Measure Class. Run the upload to download and open the Excel file. Each class and unit is automatically handled as a create or an update depending on whether it already exists.
Step 2 – Enter the classes and units
For a new class, the first row carries the Unit of Measure Class, its Class Description, and the base unit (Unit of Measure and UOM Code) with the Base UOM Flag set to Yes. Add a row per additional unit in the class. Use the Class Inactive Date or UOM Inactive Date to retire a class or unit, and the attribute columns for descriptive flexfield values.
Step 3 – Validate and Save
Click Validate and Save. This checks for missing required values and runs the upload’s validation (for example, that a new class begins with its base unit), then saves the file. Correct anything it flags before continuing.
Step 4 – 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 class and unit. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Created and updated unit-of-measure classes and units.
- A result report listing every row with a status (success or error) and a message.
Common questions
Can I delete a unit or class?
No. There is no delete – set an inactive date to retire it instead.
Why won’t a new class create?
Either you are in Create mode and missing the base-unit first row (Base UOM Flag = Yes), or you are running in Update mode, which cannot create new classes or units.
Can I change the base unit of a class?
No. The base unit of a class cannot be changed once set.
Does this work on R12.1 or 11i?
No. It requires the Oracle R12.2 API; on earlier releases it stops with a not-supported message.
How does it know whether to insert or update?
Automatically – it looks up the class by its code and the unit by its code. No need to set an action.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| This upload is not supported in releases prior to R12.2 | The instance is below R12.2 (the Oracle API is not present). | Run on an R12.2 or later instance. |
| The first row for a new class must contain the base unit with Base UOM Flag set to Yes | A new class is being created but its first row is not the base unit. | Make the first row for the class its base unit and set Base UOM Flag to Yes. |
| New classes or units cannot be created in Update mode | Wrong Upload Mode for the action. | Use Create for new rows, or Create, Update to also update existing rows. |
| The base UOM for a class cannot be changed | An attempt to change which unit is the base. | Leave the base unit as originally defined. |
| A value exceeds the maximum length | A value is too long (class, code, unit name or description). | Shorten the value to within its limit. |