Results for “sy_uoms_typ”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

SY_UOMS_TYP is the Unit of Measure Type master table for Oracle Process Manufacturing (OPM) applications, delivered under the GMA product family. It stores the definitions of unit of measure types — the classification categories that group individual units of measure (such as weight, volume, length, or count) used throughout process manufacturing transactions. Every unit of measure defined in OPM must ultimately be associated with a type, making this table a foundational reference object for inventory, conversion, and formula calculations.

The table is explicitly documented as synchronized with MTL_UOM_CLASSES, the corresponding Oracle Inventory unit of measure class table. This synchronization ensures that OPM unit of measure types remain consistent with the standard discrete EBS Inventory model, allowing UOM classifications to be shared across the process and discrete sides of the application.

Applying heuristic Data Vault modeling, SY_UOMS_TYP classifies as hub-leaning. Its structure — a single primary key with relatively few attributes and several dependent tables referencing it — suggests it functions as a core business entity (hub) rather than a transactional link or descriptive satellite. Practitioners designing a Data Vault representation would typically model UM_TYPE as a hub key, with descriptive attributes cast into a companion satellite.

Key Information Stored

The documented metadata identifies the following structural elements:

• UM_TYPE — The unit of measure type identifier. This is the primary key column (SY_UOMS_TYP_PK) and the principal business-key candidate, appearing in every foreign key relationship defined for this table.
• TEXT_CODE — A foreign key reference to SY_TEXT_HDR, linking the unit of measure type to a text header record that supplies a descriptive or translated text value. This supports multilingual or flexible description handling.

The primary key SY_UOMS_TYP_PK is enforced on UM_TYPE, distinguishing the surrogate/primary identifier from descriptive attributes. Because the table is narrow, additional descriptive columns (such as a type description or base UOM designation) are implied by the synchronization with MTL_UOM_CLASSES but are not enumerated in the documented metadata. The absence of a note stating it is "not implemented in this database" indicates that the excerpt reflects partial or externally sourced metadata; in a live 12.1.1 or 12.2.2 instance the table is populated by OPM setup.

Common Use Cases and Queries

Typical reporting and validation scenarios involve confirming that each unit of measure defined in OPM carries a valid, recognized type, and reconciling those types against Inventory classes. A representative query joins the type master to the units of measure that depend on it:

• Listing all unit of measure types and the units of measure assigned to each: SELECT t.um_type, m.uom_code FROM sy_uoms_typ t, sy_uoms_mst m WHERE t.um_type = m.um_type ORDER BY t.um_type;
• Identifying types used in standard conversions: join SY_UOMS_STD on UM_TYPE to audit the conversion factors maintained per type.
• Cross-checking against Inventory: compare SY_UOMS_TYP.UM_TYPE with MTL_UOM_CLASSES.UOM_CLASS to detect synchronization gaps between OPM and discrete Inventory setup.
• Item conversion auditing: join IC_ITEM_CNV on UM_TYPE to determine which conversion records depend on a given type before making setup changes.
• Referential integrity checks: query for units of measure whose UM_TYPE has no matching row in SY_UOMS_TYP, which would indicate orphaned reference data.

These queries are commonly used during period-close validation, conversion-factor troubleshooting, and OPM-to-Inventory reconciliation reporting.

Related Objects

The FK metadata identifies the principal objects that reference or are referenced by SY_UOMS_TYP:

• SY_UOMS_MST — The unit of measure master. Joins via SY_UOMS_TYP.UM_TYPE = SY_UOMS_MST.UM_TYPE; records here depend on the type definition.
• SY_UOMS_STD — The standard/alternate unit of measure conversion table. Joins via SY_UOMS_TYP.UM_TYPE = SY_UOMS_STD.UM_TYPE.
• IC_ITEM_CNV — Item conversion factors. Joins via SY_UOMS_TYP.UM_TYPE = IC_ITEM_CNV.UM_TYPE.
• SY_TEXT_HDR — The text header table referenced by SY_UOMS_TYP.TEXT_CODE, supplying descriptive text for the type.
• MTL_UOM_CLASSES — The Inventory UOM class table, maintained in synchronization with this OPM type master as documented.

Together these objects form the reference-data backbone of OPM unit of measure handling, bridging process manufacturing setup and standard Oracle Inventory classification.