Search Results sy_uoms_std_pk

Overview

The SY_UOMS_STD table is a data object within the Oracle E-Business Suite (EBS) Process Manufacturing (GMA) module. Its defined purpose is to establish associations between specific Units of Measure (UOM) and defined UOM Types. This association is a foundational concept in manufacturing systems, where a UOM Type (e.g., 'Weight', 'Volume', 'Each') can have multiple specific units (e.g., 'KG', 'LB', 'LITER', 'GALLON') assigned to it, enabling standardized conversion and comparison. Crucially, the official ETRM documentation explicitly states this table is "Not yet used," indicating it is a structural component of the GMA schema that was implemented for potential future functionality but is not actively populated or referenced by core application logic in the documented releases (12.1.1 / 12.2.2).

Key Information Stored

The table's structure is designed to store a simple mapping. Based on the provided metadata, the key columns and constraints are:

• UM_CODE: This column holds the code for a specific Unit of Measure. It is a foreign key referencing the SY_UOMS_MST table, which is the master list of all valid units of measure within the system.
• UM_TYPE: This column holds the identifier for a Unit of Measure Type. It serves as both a foreign key referencing the SY_UOMS_TYP table and part of the table's primary key.
• Primary Key (SY_UOMS_STD_PK): The combination of UM_TYPE and UM_CODE. This enforces uniqueness, preventing the same UOM from being assigned to the same UOM type more than once.

Common Use Cases and Queries

Given its documented "Not yet used" status, there are no standard application use cases for this table in the referenced EBS versions. Its primary relevance is for technical analysis, schema investigation, or potential custom development. Database administrators or technical consultants might query it to understand the GMA data model's intended design. A sample analytical query would be a join to see any defined associations, though the result set is likely empty:

SELECT typ.um_type, typ.description AS type_desc, std.um_code, mst.description AS uom_desc
FROM gma.sy_uoms_std std,
gma.sy_uoms_typ typ,
gma.sy_uoms_mst mst
WHERE std.um_type = typ.um_type
AND std.um_code = mst.um_code(+)
ORDER BY typ.um_type, std.um_code;

Related Objects

The SY_UOMS_STD table exists within a small network of related UOM master tables in the GMA schema, as defined by its foreign key constraints:

• SY_UOMS_TYP: The referenced parent table for UOM Types (via UM_TYPE). This table defines the categories of measurement.
• SY_UOMS_MST: The referenced parent table for Units of Measure (via UM_CODE). This is the master source for all valid unit codes and their descriptions.

There are no indications of views, public APIs, or application packages that directly reference or depend on SY_UOMS_STD in its current state. Its relationship is purely structural within the database schema.