Search Results fm_form_mst

Overview

The FM_FORM_MST table is the central header table for formulas within the Process Manufacturing Product Development (GMD) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for all formula definitions, storing the core identifying and descriptive metadata for each formula. As a header table, it establishes the primary formula entity, which is then detailed through numerous related child tables that capture version-specific details, ingredients, processing instructions, and operational dependencies. Its existence is fundamental to the formulation, costing, and batch execution processes in Process Manufacturing.

Key Information Stored

While the provided metadata does not list all columns, the primary and unique keys define the table's core structure. Each record is uniquely identified by a system-generated FORMULA_ID (primary key). Business uniqueness is enforced by the combination of FORMULA_NO (the formula number) and FORMULA_VERS (the formula version). Critical foreign key columns link the formula to its classification and descriptive text, including FORMULA_CLASS (linking to FM_FORM_CLS) and FMCONTROL_CLASS (linking to FM_FMCT_CLS). The TEXT_CODE column links to the FM_TEXT_HDR table, storing descriptive notes and instructions for the formula header.

Common Use Cases and Queries

This table is primarily queried to retrieve a list of formulas or to find specific formula headers for integration, reporting, or data validation. Common scenarios include generating a formula catalog, interfacing formula data with external systems, and troubleshooting data integrity. A typical query to retrieve active formula headers with their classifications would resemble the following pattern:

• SELECT f.formula_no, f.formula_vers, f.formula_id, c.formula_class_desc
• FROM fm_form_mst f, fm_form_cls c
• WHERE f.formula_class = c.formula_class
• AND f.delete_mark = 0; -- Assuming a standard delete marker column

Another critical use case is tracing the relationship between a formula and its dependent batch records for production analysis or audit purposes.

Related Objects

FM_FORM_MST is the parent to a significant hierarchy of tables in the GMD module. As indicated by the foreign key relationships, key dependent tables include:

• FM_FORM_EFF: Stores the effective dates and statuses for each formula version.
• FM_MATL_DTL: The formula material details table, listing all ingredients (inputs) and products (outputs).
• PM_BTCH_HDR: The Process Execution (PM) batch header, which references the formula used to create a production batch.
• GMP_FORM_EFF, MR_ACTN_TBL, MR_MESG_TBL: Related to regulatory management (GMP) and material requirements (MR) planning.

It is also referenced by key views and public APIs within the GMD_FORMULA package for programmatic access and validation.