Search Results op_cntr_dtl

Overview

The SY_UOMS_MST table is the central unit of measure (UOM) master for Oracle Process Manufacturing (OPM), a core component of the GMA (Process Manufacturing Systems) product. It functions as the system of record for all UOM definitions within the manufacturing module, storing the codes, types, and descriptive attributes necessary for managing materials, recipes, and costs. A critical aspect of its design is its synchronization with the Oracle Financials inventory tables, specifically MTL_UNITS_OF_MEASURE, when both Process Manufacturing and Financials are implemented. This ensures UOM consistency across manufacturing execution and financial inventory management. The metadata indicates this specific object is "Not implemented in this database," which typically means the table structure exists but is not populated in a standard Oracle Financials instance without OPM.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal its core structure. The table is uniquely identified by the UM_CODE column, which serves as the primary key (SY_UOMS_MST_PK). Other significant columns inferred from the foreign key constraints include UM_TYPE, which classifies the unit of measure (likely referencing SY_UOMS_TYP), and TEXT_CODE for descriptive text (referencing SY_TEXT_HDR). The table's purpose is to define each UOM, enabling its use throughout the OPM suite for quantifying items, resources, burdens, and production outputs in formulas, routings, cost ledgers, and inventory transactions.

Common Use Cases and Queries

This table is foundational for any data retrieval involving quantities in OPM. Common use cases include validating UOMs in interface programs, supporting reports that require UOM descriptions, and ensuring data integrity during migrations. A typical query would join SY_UOMS_MST to various transaction tables to translate UOM codes into meaningful descriptions. For example, to list inventory items with their primary UOM description, one might use a query such as:

SELECT im.item_no, im.item_um, uom.um_code, uom.description
FROM ic_item_mst im, sy_uoms_mst uom
WHERE im.item_um = uom.um_code;

Another critical scenario involves verifying the synchronization between OPM and Inventory UOMs by comparing SY_UOMS_MST with MTL_UNITS_OF_MEASURE on equivalent codes.

Related Objects

As evidenced by the extensive foreign key list, SY_UOMS_MST is a heavily referenced master table. Key dependencies include:

• Master References: SY_UOMS_TYP (for UOM type), SY_TEXT_HDR (for descriptive text).
• Core Manufacturing Tables: FM_FORM_EFF, FM_MATL_DTL, FM_OPRN_DTL, FM_ROUT_HDR (for formula and routing details).
• Cost Management Tables: CM_SCST_LED, CM_RSRC_DTL, CM_BRDN_DTL (for costing quantities).
• Inventory Control Tables: IC_ITEM_MST (primary and secondary item UOMs), IC_ADJS_JNL, IC_INVN_CLS.
• Financial Integration Tables: GL_ACCT_MST, GL_SUBR_LED (for general ledger quantity tracking).
• Synchronization Target: MTL_UNITS_OF_MEASURE in Oracle Inventory (INV).