Results for “lm_form_mst”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

LM_FORM_MST is a table in the Oracle E-Business Suite Process Manufacturing Product Development module (product code GMD), owned by the GMD schema. It is the master table for process manufacturing formulas, holding the header-level definition of each formula that drives product development, costing, and production activities. Per the ETRM documentation metadata, this object is marked OBSOLETE as of 11.5.6 (OPM PF.G), meaning that in Oracle EBS 12.1.1 and 12.2.2 it is retained for backward compatibility and historical data rather than for new development. Its status remains VALID in the 12.2.2 physical schema, where it is documented with 49 columns under the GMD owner.

Functionally, LM_FORM_MST sits at the center of a hub-and-spoke structure of formula-related data. Based on the foreign-key topology, its heuristic Data Vault classification is hub-leaning: the table anchors identity and business keys for formulas and is referenced by several dependent detail, item, and spreadsheet tables. This classification is a modeling suggestion derived from the FK structure, not a documented Oracle designation.

Key Information Stored

The table stores one row per formula header. The documented primary key constraint LM_FORM_MST_PK is defined on FORMULA_ID, the surrogate identifier. A second unique constraint, LM_FORM_MST_U1, is defined on the business key combination FORMULA_NO and FORMULA_VERS, representing the formula number and version visible to users. FORMULA_ID is the value propagated to all child tables via foreign keys, while FORMULA_NO and FORMULA_VERS provide the human-readable formula identity.

• FORMULA_ID — surrogate primary key; the join key to all dependent tables.
• FORMULA_NO, FORMULA_VERS — business-key pair forming unique index LM_FORM_MST_U1; formula number and version.
• FORMULA_CLASS — formula classification; foreign key to FM_FORM_CLS.
• FMCONTROL_CLASS — formula control class; foreign key to FM_FMCT_CLS.
• TEXT_CODE — reference to descriptive text held in LM_TEXT_HDR.
• SCALE_TYPE, FORMULA_TYPE — characteristics governing how the formula scales and is typed.
• IN_USE, INACTIVE_IND, DELETE_MARK — lifecycle and status indicators controlling active use and logical deletion.
• FORMULA_DESC1#1, FORMULA_DESC2#1 — descriptive text attributes for the formula header.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — the DFF (descriptive flexfield) segment columns used for client-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical reporting scenarios include listing active formulas by class, retrieving the current version of a formula, and joining header to detail to explode ingredients. A representative query filters live formulas and resolves class descriptions:

• SELECT f.formula_no, f.formula_vers, f.formula_class, f.formula_type FROM gmd.lm_form_mst f WHERE f.delete_mark = 0 AND NVL(f.inactive_ind,'N') = 'N';
• Joining to LM_FORM_DTL on FORMULA_ID to report ingredient detail: SELECT m.formula_no, d.* FROM gmd.lm_form_mst m, gmd.lm_form_dtl d WHERE m.formula_id = d.formula_id;
• Resolving class and control descriptions by joining FORMULA_CLASS to FM_FORM_CLS and FMCONTROL_CLASS to FM_FMCT_CLS.
• Retrieving long description text via TEXT_CODE to LM_TEXT_HDR.
• Historical/version analysis using the FORMULA_NO/FORMULA_VERS unique key to compare versions.

Because the table is obsolete for new functionality, queries generally target legacy or migrated data, and any DFF usage should be scoped through ATTRIBUTE_CATEGORY.

Related Objects

The table participates in a well-defined relationship set. Foreign keys referencing this table confirm its hub role:

• LM_FORM_DTL — formula detail lines; joins on FORMULA_ID, and also references the master via TPFORMULA_ID.
• LM_ITEM_DAT — formula item data; joins on FORMULA_ID.
• LM_SPRD_FLS — spreadsheets tied to formulas; joins on FORMULA_ID.
• FM_FORM_CLS — formula class lookup referenced by FORMULA_CLASS.
• FM_FMCT_CLS — formula control class lookup referenced by FMCONTROL_CLASS.
• LM_TEXT_HDR — descriptive text header referenced by TEXT_CODE.

Together these objects form the core formula data model in Process Manufacturing Product Development, with LM_FORM_MST as the central header entity from which detail, item, and spreadsheet records descend.