Search Results lm_form_mst




Overview
Explore in AI Chat

Overview

The LM_FORM_MST table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically under the Product Development sub-module. Its primary function is to serve as the master repository for formula definitions. A formula is a critical entity that specifies the ingredients, their quantities, and the processing instructions required to manufacture a product. However, as explicitly stated in the ETRM documentation, this table is OBSOLETE as of version 11.5.6 of the Oracle Process Manufacturing (OPM) product family (PF.G). In later releases, including EBS 12.1.1 and 12.2.2, its data and functionality have been superseded by other, more current application tables and structures. Its presence in the GMD schema is largely for historical data reference and backward compatibility.

Key Information Stored

The table's structure centers on uniquely identifying and classifying a formula. The primary keys indicate that a formula can be identified either by its internal system identifier (FORMULA_ID) or by its unique business key combination of FORMULA_NO and FORMULA_VERS. Other significant columns, as indicated by the foreign key relationships, include FMCONTROL_CLASS, which links to the FM_FMCT_CLS table for formula control classifications; FORMULA_CLASS, linking to the FM_FORM_CLS table for formula type classifications; and TEXT_CODE, linking to the LM_TEXT_HDR table to store descriptive text and instructions associated with the formula.

Common Use Cases and Queries

Given its obsolete status, direct operational use or modification of this table in EBS 12.x is strongly discouraged. Its primary use case in modern implementations is for historical data analysis or migration validation. Sample queries would be diagnostic in nature, such as verifying the existence of legacy data or understanding historical formula structures before a final data purge. A basic informational query would be:

SELECT formula_id, formula_no, formula_vers, formula_class
FROM gmd.lm_form_mst
WHERE formula_no = '<FORMULA_NUMBER>';

Any reporting or transactional processes in EBS 12.1.1 or 12.2.2 should utilize the current, supported application tables and public APIs provided by Oracle for formula management.

Related Objects

The foreign key metadata details this table's central role in the obsolete data model. It has several child tables that stored detailed information related to a formula master record. Key related objects include:

  • LM_FORM_DTL: Stored the detailed ingredient lines and processing steps for a formula, linked via FORMULA_ID and TPFORMULA_ID.
  • LM_ITEM_DAT: Associated formula information with items.
  • LM_SPRD_FLS: Stored data related to formula spreading or scaling.
  • Classification Tables: FM_FMCT_CLS and FM_FORM_CLS provided valid values for the formula's control and type classifications.
  • LM_TEXT_HDR: Held the descriptive text referenced by the formula's TEXT_CODE.
These relationships illustrate the comprehensive, though now outdated, data hierarchy for formula management in earlier OPM releases.