Search Results gmd_operation_class_b_pk




Overview
Explore in AI Chat

Overview

The GMD_OPERATION_CLASS_B table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically under Product Development. As its documented description states, it serves as the operation class base table, functioning as a master repository for defining and grouping manufacturing operations. In the context of process manufacturing, operations represent discrete steps or activities within a production process. This table provides a classification mechanism, enabling the logical grouping of similar operations for streamlined process definition, standard costing, capacity planning, and reporting. Its role is foundational to structuring and managing the operational hierarchy within manufacturing formulas and routings.

Key Information Stored

The primary data stored in this table centers on the definition and attributes of an operation class. While the full column list is not detailed in the provided metadata, the documented primary key and foreign key relationships indicate critical fields. The primary key column is OPRN_CLASS, which uniquely identifies each operation class code. Another significant column is TEXT_CODE, which, as per the foreign key relationship, links to the FM_TEXT_HDR table. This linkage is standard in Oracle EBS for storing descriptive, translatable text (such as the operation class name and description) separately from the base transactional table, supporting multilingual implementations. Additional typical columns in such base tables would include CONTROL_QUANTITY, CHARGE_TYPE, and standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY).

Common Use Cases and Queries

This table is primarily referenced during the setup and maintenance of manufacturing processes. A common use case is the creation of a new routing or the revision of a formula, where an operation class must be assigned to a routing step. For reporting, it is used to aggregate costs or analyze performance across groups of operations. A typical query would join this table to its descriptive text to retrieve a user-friendly list of operation classes.

  • Sample Query to List Operation Classes with Descriptions:
    SELECT goc.oprn_class, fth.text
    FROM gmd_operation_class_b goc,
         fm_text_hdr fth
    WHERE goc.text_code = fth.text_code(+);
  • Use in Routing Definition: The OPRN_CLASS value from this table is typically selected in the user interface when defining steps in a process routing (GMD_ROUTING_STEPS).

Related Objects

The GMD_OPERATION_CLASS_B table maintains defined relationships with other key EBS objects, as documented in the provided metadata. The primary relationship is enforced via its foreign key.

  • FM_TEXT_HDR (Foreign Key): This is a critical dependency. The TEXT_CODE column in GMD_OPERATION_CLASS_B references the FM_TEXT_HDR table. This relationship separates transactional data from descriptive text, allowing for flexible, multilingual descriptions of the operation class.
  • GMD_OPERATION_CLASS_B_PK (Primary Key Constraint): Enforces uniqueness on the OPRN_CLASS column, ensuring no duplicate operation class codes exist.
  • Implicit Dependencies: While not listed in the provided metadata, this base table is almost certainly referenced by child transactional tables such as GMD_ROUTING_STEPS or GMD_OPERATIONS, where the OPRN_CLASS is used as a foreign key to classify individual operations.