Results for “fm_oprn_mst”

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

Overview

FM_OPRN_MST is the Operation Master table within the Oracle E-Business Suite Process Manufacturing Product Development module (GMD). It serves as the central repository for operation definitions used throughout process manufacturing routing, recipe, and quality workflows. Each row represents a discrete manufacturing operation — such as mixing, heating, cooling, or packaging — that can be referenced by routings, recipes, quality specifications, and sampling plans. Because operations are reusable across many formulas, routings, and quality plans, FM_OPRN_MST acts as a shared reference entity rather than a transactional table.

The ETRM metadata classifies this object as hub-leaning in Data Vault terms. This is a modeling suggestion: FM_OPRN_MST behaves primarily as a hub, holding the durable identity of each operation keyed by a surrogate identifier. Downstream tables such as FM_ROUT_DTL, PM_ROUT_DTL, and FM_OPRN_DTL function as links or satellites that attach routing-specific or recipe-specific attributes to that hub. The metadata notes that FM_OPRN_MST is "not implemented in this database," indicating the excerpt originates from a documentation repository rather than a live instance.

Key Information Stored

The table is keyed by a surrogate primary key OPRN_ID through the constraint FM_OPRN_MST_PK. A secondary unique constraint, FM_OPRN_MST_UC1, enforces uniqueness on OPRN_NO, making the operation number the natural business-key candidate that users recognize in the application.

• OPRN_ID — Surrogate primary key uniquely identifying each operation record.
• OPRN_NO — Business-facing operation number, enforced unique via FM_OPRN_MST_UC1.
• OPRN_CLASS — Foreign key to FM_OPRN_CLS, classifying the operation (for example, process versus transfer versus quality operation).
• TEXT_CODE — Foreign key to FM_TEXT_HDR, linking the operation to descriptive text stored in the text header.
• PROCESS_QTY_UM — Foreign key to SY_UOMS_MST, defining the unit of measure for the process quantity associated with the operation.

Together these columns define the operation's identity, its classification, its textual documentation, and the unit of measure governing quantities processed by that operation.

Common Use Cases and Queries

Typical uses include resolving operation numbers to surrogate IDs during routing or recipe integration, validating that referenced operations exist before loading detail rows, and building reports that list operations by class or unit of measure. A representative lookup joins the master to its classification:

SELECT m.OPRN_ID, m.OPRN_NO, c.OPRN_CLASS
FROM FM_OPRN_MST m, FM_OPRN_CLS c
WHERE m.OPRN_CLASS = c.OPRN_CLASS;

To find every routing that uses a given operation, join FM_OPRN_MST to FM_ROUT_DTL or PM_ROUT_DTL on OPRN_ID. Quality analysts frequently combine FM_OPRN_MST with QC_SPEC_MST and QC_SMPL_MST to trace which quality specifications and sampling plans are tied to a given operation. Unit-of-measure reconciliation queries join SY_UOMS_MST on PROCESS_QTY_UM to report operations in consistent measurement terms.

Related Objects

FM_OPRN_MST participates in a dense web of foreign-key relationships:

• FM_OPRN_CLS — Joined on OPRN_CLASS; supplies the operation classification.
• FM_TEXT_HDR — Joined on TEXT_CODE; provides descriptive text.
• SY_UOMS_MST — Joined on PROCESS_QTY_UM; supplies the unit-of-measure definition.
• FM_OPRN_DTL — References FM_OPRN_MST via OPRN_ID; holds operation detail lines.
• FM_ROUT_DTL — References FM_OPRN_MST via OPRN_ID; stores routing operation steps.
• PM_ROUT_DTL — References FM_OPRN_MST via OPRN_ID; stores process routing detail.
• QC_SPEC_MST — References FM_OPRN_MST via OPRN_ID; links operations to quality specifications.
• QC_SMPL_MST — References FM_OPRN_MST via OPRN_ID; links operations to sampling plans.
• QC_RSLT_MST — References FM_OPRN_MST via OPRN_ID; records quality results by operation.
• CR_SQDS_TBL — References FM_OPRN_MST via OPRN_ID; used in routing sequence scheduling.