Search Results fm_rout_hdr

Overview

The FM_ROUT_HDR table is the central repository for routing header information within the Process Manufacturing Product Development (GMD) module of Oracle E-Business Suite (EBS). It defines the master record for a production routing, which is a critical manufacturing document specifying the sequence of operations, resources, and materials required to produce a batch of a formula-based product. This table is foundational for managing the process workflow, enabling batch execution, cost roll-ups, and production scheduling. Its integrity is enforced by primary and unique keys, and it serves as a parent to numerous transactional and configuration tables within the GMD and related modules.

Key Information Stored

The table's primary identifier is the system-generated ROUTING_ID. However, for business users, the unique combination of ROUTING_NO and ROUTING_VERS defines a specific version of a routing. Other significant columns include ROUTING_CLASS, which links to the FM_ROUT_CLS table for routing categorization, and ITEM_UM, which references SY_UOMS_MST to define the unit of measure for the output item. The TEXT_CODE column links to FM_TEXT_HDR, allowing for the attachment of descriptive notes and instructions. The table also stores status, effective dates, and other control attributes essential for managing the routing lifecycle.

Common Use Cases and Queries

A primary use case is retrieving active routings for a given product or formula to support batch creation or process planning. Technical consultants often query this table to validate data or build custom reports. A typical query pattern involves joining to related detail and classification tables:

• Find Routings by Class: SELECT r.routing_no, r.routing_vers, c.routing_class_desc FROM fm_rout_hdr r, fm_rout_cls c WHERE r.routing_class = c.routing_class AND r.delete_mark = 0;
• List Routings for a Batch: SELECT b.batch_no, r.routing_no, r.routing_vers FROM pm_btch_hdr b, fm_rout_hdr r WHERE b.routing_id = r.routing_id;
• Identify Routings with Associated Text: SELECT routing_no, text_code FROM fm_rout_hdr WHERE text_code IS NOT NULL;

Related Objects

As indicated by the foreign key relationships, FM_ROUT_HDR is a core entity with extensive integration. Key dependent objects include:

• FM_ROUT_DTL: Stores the detailed operation steps for the routing.
• FM_FORM_EFF and GMP_FORM_EFF: Link routings to formulas and their effectivities.
• PM_BTCH_HDR: References the routing used for a specific production batch.
• GL_ACCT_MAP: Associates routings with general ledger accounts for costing.
• Parent Tables: It references FM_ROUT_CLS (routing class), SY_UOMS_MST (unit of measure), and FM_TEXT_HDR (descriptive text).