INV Unit Of Measure Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
INV Unit Of Measure Upload ====================== Note: This upload can only be used in R12.2 or later.
This upload can be used to create and update Unit of Measure Classes and Units of Measures
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, Unit of Measure Class
Oracle EBS Tables Used
mtl_uom_classes_vl, mtl_units_of_measure_vl
Report Categories
Related Reports
CAC WIP Account Value, CAC WIP Jobs With Complete Status But Not Ready for Close, CAC Material Account Detail, CAC ICP PII WIP Material Usage Variance, CAC Purchase Price Variance, CAC WIP Resource Efficiency, CAC Material Account Summary, CAC Receiving Account Summary, CAC WIP Jobs With Complete Status Which Are Ready for Close
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_Upload.xml |
| SQL Source | INV Unit Of Measure Upload.sql |
| Full Report on Enginatics | www.enginatics.com/reports/inv-unit-of-measure-upload/ |
INV Unit Of Measure Upload - Case Study & Technical Analysis
Executive Summary
The INV Unit Of Measure Upload is a foundational setup tool. It allows for the creation and maintenance of the UOM Classes (e.g., “Weight”, “Count”, “Volume”) and the individual Units of Measure (e.g., “Kg”, “Lb”, “Each”, “Dozen”). This is typically used during the initial system implementation or when expanding into new markets.
Business Challenge
Defining UOMs is the bedrock of the inventory system.
- Standardization: “We need to ensure that ‘Kilogram’ is defined as ‘KG’ across all our global instances.”
- Compliance: “We are expanding to the US and need to add imperial units (Lbs, Oz) to our metric system.”
- Volume: Manually defining 50 different units of measure and their classes is tedious.
Solution
The INV Unit Of Measure Upload allows for the bulk definition of these codes. It ensures consistency and completeness.
Key Features:
- Class Definition: Create UOM Classes (e.g., Quantity, Weight, Time).
- Unit Definition: Create specific UOMs (e.g., Ea, Doz, Gross).
- Standard Conversions: Define the base unit for the class (e.g., “Each” is the base for Quantity).
Technical Architecture
The tool populates the core UOM definition tables.
Key Tables and Views
MTL_UNITS_OF_MEASURE_VL: The table storing individual UOM definitions.MTL_UOM_CLASSES_VL: The table storing UOM Class definitions.
Core Logic
- Upload: Reads the Class and Unit definitions from Excel.
- Validation: Checks for duplicate codes or names.
- Creation: Inserts records into the UOM tables.
Business Impact
- Global Consistency: Ensures that all business units speak the same “language” regarding quantities.
- Implementation Speed: Accelerates the initial setup of the inventory module.
- Data Quality: Prevents the creation of duplicate or ambiguous units (e.g., “ea” vs “EA”).
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