Search Results fm_rout_mtl




Overview
Explore in AI Chat

Overview

The FM_ROUT_MTL table is a core data entity within the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically for Product Development. Its primary function is to establish and maintain the critical association between a process routing and the specific ingredients or materials defined in a formula. In Process Manufacturing, a formula details the bill of materials, while a routing defines the operational steps. This table acts as the junction, linking individual formula lines (materials) to the specific routing steps where they are consumed or processed. This association is fundamental for accurate production planning, costing, and execution, ensuring materials are accounted for at the correct stage of the manufacturing process.

Key Information Stored

The table's structure is designed to enforce and record the relationship between the three key identifiers. As defined by its primary key constraint (FM_ROUT_MTL_PK), the table uniquely identifies an association through a combination of columns: FORMULA_ID, which references the master formula; ROUTING_ID, which references the process routing; and FORMULALINE_ID, which points to the specific line item within the formula. Additional columns, such as TEXT_CODE linked via a foreign key to FM_TEXT_HDR, may store references to descriptive text or instructions pertinent to the material's use at that routing step. The integrity of the data is maintained through foreign key relationships to the formula detail (FM_MATL_DTL) and text header tables.

Common Use Cases and Queries

A primary use case is generating reports or interfaces that list all materials required at each step of a production batch for pick lists or operator instructions. Development and support activities often involve queries to diagnose missing associations or validate configuration. Common SQL patterns include joining to FM_FORM_MST for the formula header, FM_MATL_DTL for material details, and GMD_ROUTINGS for routing information.

  • Retrieve Material-Step Associations for a Formula: SELECT * FROM FM_ROUT_MTL WHERE FORMULA_ID = <id> ORDER BY ROUTING_ID, FORMULALINE_ID;
  • List All Materials for a Specific Routing Step: SELECT m.*, d.material_detail FROM FM_ROUT_MTL m JOIN FM_MATL_DTL d ON m.FORMULALINE_ID = d.FORMULALINE_ID WHERE m.ROUTING_ID = <id>;

Related Objects

FM_ROUT_MTL is centrally connected to other essential Process Manufacturing tables. Its primary foreign key relationship is with FM_MATL_DTL, which contains the detailed definition of each formula line item (material, quantity, unit of measure). It also references FM_TEXT_HDR for descriptive text. The table is inherently dependent on the master formula (FM_FORM_MST) and routing (GMD_ROUTINGS_B) headers, as identified by FORMULA_ID and ROUTING_ID. This object is crucial for the integration between the Product Development (formula/routing design) and Process Execution (batch production) sub-modules within GMD.