INV Unit Of Measure Conversion Upload creates and updates Oracle Inventory unit-of-measure conversions – standard, intra-class, inter-class and lot-specific inter-class – for an inventory organization, from Excel. Updates, and standard and lot conversions, require Oracle EBS R12.2.3 or later.
When to use it
- Mass-load new unit-of-measure conversions when setting up or extending an organization.
- Add standard, item-specific or lot-specific conversions.
- Update conversion rates or set inactive dates in bulk (R12.2.3 and later).
- Review and export existing conversions for an organization.
Before you start
- Blitz Report is installed and you are signed in to an Inventory responsibility with access to the organization.
- The units of measure, classes, and any items and lots already exist.
- Updates, and standard and lot conversions, require Oracle EBS R12.2.3 or later; on R12.1 only new item-specific conversions can be created.
Step 1 – Choose a mode, set the parameters and download
In Blitz Report, open INV Unit Of Measure Conversion Upload, choose an Upload Mode (Create, or Create, Update to also update existing conversions), and set the parameters:
| Parameter | Purpose |
|---|---|
| Organization Code | The inventory organization. |
| Upload Mode | Create or Create, Update. Default is Create. |
| Conversion Type | Optionally download one type: Standard, Intra-class, Inter-class or Lot Inter-class. |
| From / To Unit of Measure (Class) / Item / Lot | Restrict which conversions are downloaded. |
Run the upload to download and open the Excel file. Each row is automatically handled as a create or an update depending on whether the conversion already exists.
Step 2 – Enter the conversions
On each row choose the From Uom and To Uom (their classes are derived automatically) and enter the Uom Conversion Rate. For an item-specific conversion enter the Item; for a lot conversion enter the Lot Number and the lot update options. The Conversion Type is derived from what you enter. Use the Inactive Date to retire a conversion.
Step 3 – Validate and Save
Click Validate and Save. This checks for missing required values (both units, their classes and a rate) and runs the upload’s validation, 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 conversion. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Created and updated unit-of-measure conversions in the organization.
- A result report listing every row with a status (success or error) and a message.
Common questions
Can I delete a conversion with this upload?
No. There is no delete – set an Inactive Date to retire a conversion.
Why can’t I update a conversion, or create a standard or lot conversion?
Your environment is on R12.1, where the Oracle API only supports creating item-specific intra-class and inter-class conversions. Update, standard and lot conversions require R12.2.3 or later.
Do I have to fill in the Conversion Type?
It is derived from your data: a lot makes it Lot Inter-class; differing from and to classes make it Inter-class; an item with the same class makes it Intra-class; otherwise Standard.
What goes in From/To UOM versus From/To UOM Class?
Pick the units of measure; their classes are derived automatically.
When are the lot update columns used?
Only for Lot Inter-class conversions (when a Lot Number is supplied, R12.2.3+). They tell the system how to recalculate on-hand balances for the lot.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Specify both the From/To UOM and class and a conversion rate | One of the from/to units, their classes, or the rate is missing. | Fill in all the required fields on the row. |
| New conversions cannot be created in Update mode / existing cannot be updated in Create mode | The row’s detected action conflicts with the chosen Upload Mode. | Run with Create, Update mode, or split rows by action. |
| Item is required for lot conversions / standard conversions cannot be created in R12.1 | A lot conversion without an item, or a standard conversion on R12.1. | Supply a valid item; on R12.1 only item-specific conversions can be created. |
| Item is invalid | The item does not exist in the chosen organization. | Pick the item from the list for the correct organization. |
| API error on a row | The Oracle unit-of-measure API rejected the row. | Read the message in the result, correct the row, and re-upload. |