Search Results sy_uoms_typ

Overview

The SY_UOMS_TYP table serves as the master repository for unit of measure (UOM) types within Oracle Process Manufacturing (OPM), a core component of the Global Manufacturing Applications (GMA) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a classification system that categorizes individual units of measure into logical groups, such as weight, volume, length, or each. This categorization is fundamental for managing item specifications, recipe formulations, and inventory transactions where consistent measurement logic is required. A critical aspect of its design is its synchronization with the MTL_UOM_CLASSES table in the Oracle Inventory (INV) module, ensuring data integrity and consistency between the specialized Process Manufacturing and broader Supply Chain Management suites.

Key Information Stored

The primary data element stored in this table is the unit of measure type code. While the provided ETRM metadata does not list all columns explicitly, the structure and common patterns in OPM suggest the table typically contains key descriptive and control attributes. The primary key column is UM_TYPE, which holds the unique identifier for the UOM classification. Other common columns likely include a description field (e.g., DESCRIPTION), a disable flag (e.g., DELETE_MARK), and a text code (TEXT_CODE) for associating multilingual descriptive flexfield or textual information, as evidenced by its foreign key relationship to SY_TEXT_HDR. This text code enables the storage of translated descriptions for global deployments.

Common Use Cases and Queries

This table is primarily referenced during setup and master data maintenance. Common operational use cases include validating that a new unit of measure being defined in SY_UOMS_MST is assigned a valid, existing type, and ensuring conversion rules between units are logically constrained within the same type (e.g., converting grams to kilograms). A typical query would retrieve all active UOM types for a setup LOV or report. For instance, a validation query before creating a new UOM might be:

• SELECT um_type, description FROM sy_uoms_typ WHERE delete_mark = 0 ORDER BY um_type;

Another common pattern is joining SY_UOMS_TYP to the unit of measure master table to generate a categorized list:

• SELECT mst.um_code, mst.description, typ.um_type FROM sy_uoms_mst mst, sy_uoms_typ typ WHERE mst.um_type = typ.um_type AND mst.delete_mark = 0;

Related Objects

SY_UOMS_TYP maintains integral relationships with several core OPM tables. It is the parent table for the unit of measure master (SY_UOMS_MST), where each defined UOM must belong to a type. It also governs the standard UOM definitions (SY_UOMS_STD) and item-specific unit conversions (IC_ITEM_CNV). The foreign key to SY_TEXT_HDR manages descriptive text. As noted in the metadata, its most significant cross-module relationship is with MTL_UOM_CLASSES in Oracle Inventory, where it is synchronized to maintain a unified UOM classification framework across the E-Business Suite. It is important to note that the ETRM indicates this specific table is "Not implemented in this database," which may suggest it is a legacy object or that its functionality is fully represented in MTL_UOM_CLASSES in certain configurations.