Search Results fm_rout_cls




Overview
Explore in AI Chat

Overview

The FM_ROUT_CLS table is a foundational data object within the Process Manufacturing Product Development (GMD) module of Oracle E-Business Suite (EBS). Its primary function is to define and manage routing classes, which serve as a classification mechanism for grouping routings. A routing in Process Manufacturing defines the sequence of operations required to produce a specific item or formula. By organizing these routings into logical classes, such as by product line, technology type, or regulatory requirement, the system enables more efficient management, reporting, and assignment of manufacturing processes. This classification structure is critical for maintaining consistency and standardization across complex production environments.

Key Information Stored

Based on the provided ETRM metadata, the table's structure centers on a primary key that uniquely identifies each routing class. The most critical column is ROUTING_CLASS, which serves as the primary identifier (PK: FM_ROUT_CLS_PK). This column stores the unique code or name for the routing class. While the full column list is not detailed in the excerpt, such tables typically include descriptive fields like a description, an enabled flag, creation and last update dates, and the responsible user IDs. The metadata also indicates a relationship to textual descriptions via a foreign key to FM_TEXT_HDR, suggesting the presence of a TEXT_CODE column to store multilingual descriptive text for the routing class.

Common Use Cases and Queries

The primary use case is the creation and maintenance of routing classes during the setup and configuration of the GMD module. These classes are subsequently referenced when defining new routings in the FM_ROUT_HDR table. Common operational queries involve listing all active routing classes for a user to select from in a form or generating reports that analyze routings by their classification. A typical SQL pattern to retrieve basic routing class information would be:

  • SELECT routing_class, description FROM fm_rout_cls WHERE enabled_flag = 'Y' ORDER BY 1;

Another key reporting use case is joining FM_ROUT_CLS with FM_ROUT_HDR to list all routings within a specific class, providing a structured view of manufacturing processes.

Related Objects

The FM_ROUT_CLS table has defined relationships with several other core GMD tables, as per the foreign key metadata. The most significant relationship is with the FM_ROUT_HDR (Routing Headers) table, where the ROUTING_CLASS column is a foreign key. This enforces that every routing must belong to a valid, pre-defined routing class. Additionally, the table is linked to FM_TEXT_HDR via the TEXT_CODE foreign key, which allows for storing extensive, translatable descriptions for the routing class. This relationship is common across EBS for managing flexible descriptive text. It is important to note the metadata states "Not implemented in this database," which may indicate this specific table or its constraints are not present in all instances, and consulting the actual database schema is advised for implementation details.