Search Results fm_oprn_mst




Overview
Explore in AI Chat

Overview

The FM_OPRN_MST table is the central master data repository for operations within Oracle E-Business Suite Process Manufacturing Product Development (GMD). It defines the fundamental units of work or processing steps that can be sequenced to form a manufacturing or laboratory process, known as a routing. Each record represents a discrete operation, such as mixing, heating, or testing, which can be consistently applied across multiple formulas and recipes. Its role is to provide a standardized library of operations, promoting reusability, consistency, and efficient maintenance in the definition of complex manufacturing procedures. As a master table, it is referenced extensively by transactional and planning modules throughout the Process Manufacturing suite.

Key Information Stored

The table's structure is designed to capture the essential definition of an operation. The primary identifier is OPRN_ID, a system-generated unique key. For user-facing identification, the OPRN_NO column stores the unique operation code or number. Critical descriptive attributes include the operation's name and revision. The table links to classification data via the OPRN_CLASS foreign key to FM_OPRN_CLS, allowing for logical grouping and categorization of operations. It also holds a TEXT_CODE pointer to FM_TEXT_HDR for storing detailed, long-form instructions or notes. For operations involving quantitative processing, the PROCESS_QTY_UM column references SY_UOMS_MST to define the applicable unit of measure for the operation's throughput or capacity.

Common Use Cases and Queries

This table is primarily accessed for master data maintenance, process design, and integrated reporting. Common scenarios include searching for operations by class or name during routing development, validating operation details before use in a production schedule, and generating operational reference lists for laboratory notebooks. A typical query retrieves operation details along with their classification description.

  • Sample Query: SELECT m.oprn_no, m.oprn_name, m.revision, c.oprn_class_desc FROM fm_oprn_mst m, fm_oprn_cls c WHERE m.oprn_class = c.oprn_class AND m.oprn_class = 'LAB_TEST' ORDER BY m.oprn_no;
  • Reporting Use Case: Reports often join FM_OPRN_MST to routing detail tables (FM_ROUT_DTL, PM_ROUT_DTL) to list all operations within a specific process, including their sequence and associated resources or specifications.

Related Objects

FM_OPRN_MST has defined relationships with numerous key tables in the GMD and related modules, as documented by its foreign key constraints. It is a parent table to several detail and transactional tables.

  • Primary Parent Tables: FM_OPRN_CLS (via OPRN_CLASS), FM_TEXT_HDR (via TEXT_CODE), SY_UOMS_MST (via PROCESS_QTY_UM).
  • Primary Child Tables (referencing OPRN_ID):
    • CR_SQDS_TBL: Stores sequence-dependent setup data.
    • FM_OPRN_DTL: Holds detailed parameters and resources for an operation.
    • FM_ROUT_DTL & PM_ROUT_DTL: Define the steps within a formula or process routing.
    • QC_RSLT_MST, QC_SMPL_MST, QC_SPEC_MST: Link quality management results, samples, and specifications to specific operations.