INV Unit Of Measure Conversion Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
INV Unit Of Measure Conversion Upload ============================= In R12.2 and later: This upload enables the user to
- upload new unit of measure conversions
- update existing unit of measure conversions.
The upload supports the following unit of measure conversion types:
- Standard, Intra-Class and Inter-Class, Lot Specific Inter-class
In R12.1: The functionality is restricted to creating new Item specific Intra-Class and Inter-Class conversions only. Update of existing unit of measure conversions is not supported in R12.1 Creation of Standard and Lot specific unit of measure conversions is not supported in R12.1
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Upload Mode, Conversion Type, From Unit of Measure Class, From Unit of Measure, To Unit of Measure Class, To Unit of Measure, Item, Lot Number
Oracle EBS Tables Used
mtl_uom_conversions, mtl_units_of_measure_vl, mtl_uom_classes_vl, mtl_system_items_vl, mtl_parameters, mtl_uom_class_conversions, mtl_lot_uom_class_conversions
Report Categories
Related Reports
INV Items, INV Item Upload, CAC Manufacturing Variance, INV Item Upload 11i, CAC Internal Order Shipment Margin, INV Item Templates, CAC Invoice Price Variance, INV Cycle count entries and adjustments
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | Example |
| Blitz Report™ XML Import | INV_Unit_Of_Measure_Conversion_Upload.xml |
| SQL Source | INV Unit Of Measure Conversion Upload.sql |
| Full Report on Enginatics | www.enginatics.com/reports/inv-unit-of-measure-conversion-upload/ |
INV Unit Of Measure Conversion Upload - Case Study & Technical Analysis
Executive Summary
The INV Unit Of Measure Conversion Upload is a master data management tool. It allows for the bulk creation and update of UOM conversions (e.g., “1 Box = 10 Each”). This is essential for companies with complex packaging hierarchies or those that buy in one UOM and issue in another.
Business Challenge
Managing UOM conversions is complex and critical.
- New Product Introduction: Launching a new product line often requires defining dozens of conversions (Pallet -> Case -> Box -> Each).
- Supplier Changes: “The supplier changed the box size from 12 to 10. We need to update the conversion for 50 items.”
- Data Integrity: If a conversion is missing, the system cannot receive the goods, stopping the warehouse receiving dock.
Solution
The INV Unit Of Measure Conversion Upload streamlines the maintenance of these rules. It supports Standard, Intra-Class, and Inter-Class conversions.
Key Features:
- Bulk Creation: Define conversions for hundreds of items at once.
- Lot Specific: (R12.2+) Supports Lot-Specific conversions (e.g., “Lot A has a potency of 90%”, “Lot B has a potency of 95%”).
- Update Capability: Allows updating existing conversion rates (R12.2+).
Technical Architecture
The tool interacts with the UOM conversion tables, often using the INV_UOM_API or direct interface tables.
Key Tables and Views
MTL_UOM_CONVERSIONS: Standard and Inter-Class conversions.MTL_UOM_CLASS_CONVERSIONS: Intra-Class conversions.MTL_LOT_UOM_CLASS_CONVERSIONS: Lot-specific conversions.
Core Logic
- Upload: Reads the Item, From UOM, To UOM, and Rate from Excel.
- Validation: Checks that the UOMs exist and the item is valid.
- Processing: Calls the API to create or update the conversion record.
Business Impact
- Operational Continuity: Ensures that receiving and shipping processes are not blocked by missing master data.
- Accuracy: Reduces the risk of “fat finger” errors when defining critical conversion factors (e.g., entering 100 instead of 10).
- Efficiency: Saves hours of manual setup time during product launches.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH