Search Results fm_form_cls




Overview
Explore in AI Chat

Overview

The FM_FORM_CLS table is a foundational data object within the Oracle E-Business Suite Process Manufacturing (GMD) Product Development module. It serves as the master repository for formula classes, which are hierarchical categories used to logically group and organize formulas. This classification is critical for managing complex manufacturing processes, enabling efficient formula search, retrieval, and reporting. The table's primary role is to enforce data integrity and provide a standardized reference for classifying formulas throughout the system. According to the provided ETRM metadata, it is important to note that this table may be flagged as "Not implemented in this database" in certain instances, indicating its structure is predefined by the application but may not be populated or actively used in all deployments.

Key Information Stored

The core data stored in the FM_FORM_CLS table centers on the formula class definition. The primary column is FORMULA_CLASS, which constitutes the table's primary key (FM_FORM_CLS_PK). This column stores the unique alphanumeric code identifying each classification tier. While the specific metadata for additional descriptive columns (such as a description field) is not detailed in the excerpt, typical implementations of classification tables in Oracle EBS include columns for a translated description, enabled flag, start and end dates for validity, and who columns (CREATION_DATE, CREATED_BY, etc.). The table's structure supports a hierarchical relationship, allowing for parent-child linkages between class codes to create multi-level grouping structures.

Common Use Cases and Queries

The primary use case for the FM_FORM_CLS table is to constrain and report on formulas based on their organizational class. Common operational and reporting scenarios include generating lists of all formulas within a specific class for review or mass update, and validating formula assignments during data entry. A typical query would join FM_FORM_CLS to the formula master table (FM_FORM_MST) to retrieve classified formulas. For example, to find all active formulas within a given class, a query might be structured as:

  • SELECT fms.formula_no, fms.formula_desc, cls.formula_class
  • FROM fm_form_mst fms, fm_form_cls cls
  • WHERE fms.formula_class = cls.formula_class
  • AND cls.formula_class = '&CLASS_CODE'
  • AND fms.formula_status = '700'; -- Active status

Administrative use cases involve maintaining the class hierarchy itself through inserts, updates, or disabling of class codes.

Related Objects

The FM_FORM_CLS table has defined relationships with several key tables in the GMD module, as indicated by its foreign key constraints. The most direct relationship is with the formula master table, FM_FORM_MST, where the FORMULA_CLASS column is a foreign key referencing FM_FORM_CLS. This ensures every formula is assigned a valid class. A similar relationship exists with the LM_FORM_MST table. Furthermore, the table is linked to the FM_TEXT_HDR table via the TEXT_CODE foreign key relationship, which associates multilingual descriptive text (flexfields) with the formula class records. These relationships underscore the table's central role in the formula data model, acting as a reference point for core transactional and master data entities.