Search Results fm_oprn_cls_pk

Overview

The FM_OPRN_CLS table is a foundational data object within the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically under the Product Development family. Its primary function is to serve as a master reference table for operation classes, which are logical groupings used to categorize and organize manufacturing operations. In the context of formula and process management, operation classes provide a structured method to classify different types of production steps, such as mixing, heating, or packaging. This classification is critical for standardizing process definitions, enabling efficient reporting, and supporting consistent operational execution across the manufacturing enterprise.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the structure and relationships define its core data. The table's primary key is the OPRN_CLASS column, which stores the unique identifier for each operation class. A critical foreign key relationship exists with the FM_TEXT_HDR table via a TEXT_CODE column, indicating that descriptive, multilingual text for each class is stored in a separate descriptive flexfield (DFF) enabled table. This design separates transactional data from translatable descriptions, a common pattern in Oracle EBS. The table's sole purpose is to maintain this master list of valid classification codes.

Common Use Cases and Queries

The primary use case for FM_OPRN_CLS is as a validation and reporting source for manufacturing operations defined in the FM_OPRN_MST (Formula Operation Master) table. It ensures that any operation assigned a class uses a predefined, consistent value. Common queries involve listing all available classes for setup purposes or joining to the operation master for reports. A typical SQL pattern to retrieve all operations with their class descriptions would involve joining through the text table.

SELECT oprn.oprn_id,
       oprn.oprn_no,
       oprn.oprn_class,
       txt.description
FROM   fm_oprn_mst oprn,
       fm_oprn_cls cls,
       fm_text_hdr txt
WHERE  oprn.oprn_class = cls.oprn_class
AND    cls.text_code = txt.text_code(+);

Administrative use cases include populating list of values (LOVs) in application forms where users assign or search for operations by class.

Related Objects

• FM_OPRN_MST (Formula Operation Master): This is the primary child table. It stores the detailed definition of individual manufacturing operations, each of which can be assigned a class via the OPRN_CLASS column, which references FM_OPRN_CLS.OPRN_CLASS.
• FM_TEXT_HDR (Formula Text Header): This table stores the translatable description for the operation class, linked via the TEXT_CODE foreign key. This relationship is standard for descriptive flexfields in Oracle EBS.
• FM_OPRN_CLS_PK: The primary key constraint enforcing uniqueness on the OPRN_CLASS column.

It is important to note the ETRM metadata states this table is "Not implemented in this database," which may indicate it is a legacy or placeholder object in certain versions or instances, though its defined relationships clarify its intended logical role.