Search Results fm_oprn_dtl




Overview
Explore in AI Chat

Overview

The FM_OPRN_DTL table is a core data object within the Process Manufacturing Product Development (GMD) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the detailed repository for defining the specific resources and activities required for a manufacturing operation. While the master operation (FM_OPRN_MST) defines the overall step, this table details its constituent elements, specifying what resources (e.g., equipment, labor) and activities (e.g., setup, processing) are consumed, and in what quantities. This granular data is fundamental for creating accurate process formulas, routings, and subsequently, for production costing, scheduling, and execution within the Process Manufacturing suite.

Key Information Stored

The table's primary purpose is to link an operation to its required resources and activities. Its key columns, as indicated by its primary and foreign keys, establish these critical relationships. The OPRN_ID column foreign key to FM_OPRN_MST ties each detail line to its parent operation. The RESOURCES and ACTIVITY columns are foreign keys to CR_RSRC_MST and FM_ACTV_MST respectively, identifying the specific resource and activity being utilized. The OPRN_LINE_ID serves as a unique identifier for each detail record. Additional important columns support costing and measurement: COST_ANALYSIS_CODE and COST_CMPNTCLS_ID link to costing master tables (CM_ALYS_MST, CM_CMPT_MST), while USAGE_UM (linked to SY_UOMS_MST) defines the unit of measure for the resource or activity consumption.

Common Use Cases and Queries

This table is central to queries that analyze or report on the detailed composition of manufacturing operations. A common use case is generating a bill of resources for a process routing or formula. Technical consultants often query this table to troubleshoot data issues or build custom reports for production analysis. A typical SQL pattern retrieves all detail lines for a specific operation, joining to the relevant master tables for descriptive information:

  • SELECT fdtl.*, fmst.oprn_no, rsrc.resources_code, actv.activity_code FROM fm_oprn_dtl fdtl JOIN fm_oprn_mst fmst ON fdtl.oprn_id = fmst.oprn_id JOIN cr_rsrc_mst rsrc ON fdtl.resources = rsrc.resources JOIN fm_actv_mst actv ON fdtl.activity = actv.activity WHERE fmst.oprn_no = '<OPRN_NUMBER>';

Another critical use case is cost roll-up calculations, where the usage quantities from FM_OPRN_DTL are combined with resource and activity cost rates to determine operational cost.

Related Objects

FM_OPRN_DTL sits at the intersection of several key EBS Process Manufacturing tables, as evidenced by its foreign key constraints. Its primary relationship is with the operation master (FM_OPRN_MST). It directly references master data for resources (CR_RSRC_MST), activities (FM_ACTV_MST), cost analysis codes (CM_ALYS_MST), cost components (CM_CMPT_MST), and units of measure (SY_UOMS_MST). The link to FM_TEXT_HDR allows for attaching descriptive text. A notable relationship is with PM_OPRN_DTL, indicating that detail lines from this development table may be propagated or referenced in production execution tables. This network of relationships underscores its role as a foundational specification table for manufacturing processes.